计算机类 - 微软认证

不定项选择题

You want to upgrade a Windows NT Server 4.0 computer to Windows 2000 Server. The system partition uses the FAT file system. You start the Setup program by starting the computer from the Windows 2000 Server CD-ROM. However, you receive the following error message, "You chose to install Windows 2000 on a partition that contains another operating system. Installing Windows 2000 on this partition might cause the operating system to function improperly". You are unable to perform. the upgrade. What should you do to resolve the problem？

A. Convert the system partition to NTFS.
B. Disable Advanced Configuration and Power Interface (ACPI) support for the computer.
C. Restart the computer, and then run Winnt32.exe from the Windows NT Server 4.0 environment.
D. Remove the Windows 2000 Server CD-ROM and restart the computer by using the setup floppy disks.

查看答案

不定项选择题

Exhibit: UPDATE EzonexamConsolidated SET District = ‘Mexico’ WHERE RtvID = 45 You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer and one database. When users run the query in the exhibit above the receive the following error message: Server: Mrh3612, Level 16, Stats 1, Line 1 View or function ‘EzonexamConsolidated’ is not updateable because it contains aggregates: How should you enable the query to run？

A. Create a non-normalized EzonexamConsolidated table and populate the table with data from the base tables.
B. The appropriate users should be granted UPDATE permissions on each base table.
C. To enable updates on the composite tables create an INSTEAD OF trigger on the view.
D. On each base table add a cascading update trigger.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. The server contains a database named inventory. The database has a Parts table that has a field named InStock. When parts are shipped, a table named PartsShipped is updated. When Parts are received, a table names PartsReceived is updated. The relationship of these tables is shown in the exhibit. You want the database to update the InStock field automatically. What should you do？

Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table.
B. Create a user-defined function those calculations that calculates current inventory by running aggregate queries on the PartsShipped and PartsReceived tables.
C. Use a view that creates an InStock as a part of an aggregate query.
D. Create stored procedures for modifying the PartsReceived and the PartsShipped tables that also modify the InStock fielding the parts table. Use these procedures exclusively when modifying data in the PartsReceived and the PartsShipped tables.

查看答案

不定项选择题

You are the administrator of a new Microsoft Windows 2000 Server computer named CPSRV1. CPSRV1 is a member server in your company's Windows NT 4.0 domain, which is named CPDOMAIN. A separate Windows NT domain named CPUSERS contains all of your company's user accounts. A trust relationship exists between the CPDOMAIN domain and the CPUSERS domain. You are installing SQL Server 2000 on CPSRV1. You specify a service account for each SQL Server service as shown in the following table: After the installation is complete, the MSSQLServer service and the SQLServerAgent service do not start. You need to configure the services to start without changing any security settings in either domain. What should you do？

A. Configure the services to run under the local system account
B. Add CPSRV1 to the CPUSERS domain
C. Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the local administrators group on CPSRV1
D. Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the CPUSERS\Domain Admins groups.
E. Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the CPUSERS\Domain users groups.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit. You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName. You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible. What should you do？

A. Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.
B. Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.
Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.
D. Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.

查看答案

不定项选择题

You need to install Windows 2000 Professional on 300 computers for a customer company called Ezonexam. The computers have different manufacturers and different hardware abstraction layers (HALs). You plan to use a Windows 2000 Server computer running Remote Installation Services (RIS) to perform. the installation. After the installation is complete for the first 25 computers, users of those computers report problems. You discover that the latest Windows 2000 service pack resolves those problems. You want to apply the service pack to the remaining 275 computers during the installation. What should you do？

A. Install the service pack on a reference Windows 2000 Professional computer, and then run the Riprep command on that computer. Use the resulting image for RIS.
B. Install the service pack on the RIS server, and then run the Riprep command on that server. Use the resulting image for RIS.
Copy the service pack to the CD-based image shared folder used by RIS.
D. Slipstream the service pack into a new i386 distribution shared folder, and then run the Risetup command to create a new CD-based image for the RIS server.

查看答案

不定项选择题

You want to use the database Maintenance Plan wizard to configure log shipping from FLPSQL01 to FLPSQL02 and FLPSQL03. You do not want users to add any new data on FLPSQL02 and FLPSQL03, but they must be able to run queries and reports. Which two actions should you take？ (Each correct answer presents part of the solution. Choose two)

A. Set the database load state for each destination server to No recovery mode.
B. Set the database load state for each destination server to standby mode.
C. Enable the allow database to assume primary role option for both destination servers.
D. Enable the allow database to assume primary role option for one destination server and then disable this option for other destination server.
E. Disable the allow database to assume primary role option for both destination servers.

查看答案

不定项选择题

You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. Users report that several storage locations in the UnitsStored field contain negative numbers. You examine the database's table structure. The table properties are configured as shown in the exhibit. You correct all the negative numbers in the table. You must prevent the database from storing negative numbers. You also want to minimize use of server resources and physical I/O. Which transact-SQL statement should you execute？

ALTER TABLE dbo.storagelocations ADD CONSTRAINTS CK_storagelocations_UnitsStored CHECK (UnitsStored＞= 0)
B. CREATE TRIGGER CK_UnitsStored On StorageLocations FOR INSERT, UPDATE AS IF INSERTED, UnitsStored ＜ 0 ROLLBACK TRAN
CREATE TABLE ck_unitsstored As @Units ＞= 0 GO Sp_bindrule ‘OK_UnitsStored’, ‘StorageLocations, UnitsStored’ GO
D. CREATE PROC UpdateUnitsStored (StorageLocationID int, @UnitsStored bigint)AS IF @UnitsStored ＜ 0 DATSERROR (50099, 17) ELSE UPDATE storaheLocations SET UnitsStored = @UnitsStored WHERE StorageLocationID = @storageLocationID

查看答案

不定项选择题

You need to install Windows 2000 Server on one of your older Windows NT Server 4.0 computers. The server has dual processors, 2 GB of RAM, a RAID controller with five SCSI hard disks in an array, and a generic 10/100-MB network adapter. You begin the server installation by updating the SCSI firmware. You then start the installation of the Windows 2000 Server operating system. During the next portion of the installation, you receive an error message indicating that no hard disks can be found. You want to successfully install Windows 2000 Server on the computer. What should you do？ (Each correct answer presents part of the solution. Choose two)

A. Restart the installation by using the Windows 2000 Installation CD-ROM. Press F3 during the text-mode setup.
B. Restart the installation by using the Windows 2000 Installation CD-ROM. Press F6 during the text-mode setup.
C. Restart the installation by using a MS-DOS boot disk with a CD-ROM driver.
D. Insert a disk with the original SCSI firmware.
E. Insert a disk with the OEM SCSI driver.

查看答案

不定项选择题

You are installing Windows 2000 server on Windows NT using an unattended installation. You

A. Specify $OEM$/Textmode
B. Specify $OEM$/C$/Drivers
Create a subfolder pointing to the share point
D. Create a subfolder called drivers.

查看答案