1. [单选题]You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.A Data Transformation Services (DTS) package transforms the sales records, as they are loaded. The package writes the transformed sales records to the Sales table, which has a column for integer primary key values. The IDENTITY property automatically assigns a key value to each transformed sales record.
A. After loading this month's sales data, you discover that a portion of the data contains errors. You stop loading data, identify the problem records, and delete those records from the database.
B. You want to reuse the key values that were assigned to the records that you deleted. You want to assign the deleted key values to the next sales records you load. You also want to disrupt users' work as little as possible.
C. What should you do?
D. Export all records from the Sales table to a temporary table. Truncate the Sales table, and then reload the records from the temporary table.
E. Export all records from the Sales table to a text file. Drop the Sales table, and then reload the records from the text file.
F. Use the DBCC CHECKIDENT statement to reseed the Sales table's IDENTITY property.
G. Set the Sales table's IDENTITY_INSERT property to ON. Add new sales records that have the desired key values.
2. [单选题]You are the administrator of two SQL Server 2000 computers. One of these servers contains a 4-GB database named marketing. You want to remove the marketing database from one server and add it to the other as quickly as possible.What should you do?
A. Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure.
B. Use the DTS export wizard to transfer all database objects from the original server to the new server. Drop the database from the original server.
C. Run a full backup of the database on the original server. Create a new database named marketing on the new server. Restore the backup in the new marketing database. Drop the database from the original server.
D. Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server.
3. [多选题]You are installing Windows 2000 Server on a new computer that has a single 10-GB SCSI disk. The disk controller is not included on the current Hardware Compatibility List (HCL). You start the computer by using the Windows 2000 Server CD-ROM.When the computer restarts at the end of the text mode portion of Windows 2000 setup, you receive the following STOP error: "INACCESSIBLE_BOOT_DEVICE."
A. Which two actions should you take to eliminate the STOP error? (Choose Two)
B. Restart the Windows 2000 Setup by using the Windows 2000 Server CD-ROM.
C. Select Safe Mode from the Windows 2000 boot menu.
D. Remove the Windows 2000 Server CD-ROM from the CD-ROM drive.
E. Install a driver for the SCSI controller from a floppy disk.
F. Use Device Manager to update the driver for the SCSI controller.
4. [单选题]You are the administrator for Ezonexam's network.Your network includes Windows 2000 Professional client computers, Windows 2000 Server computers, Windows XP Professional computers, and UNIX client computers. Users of the UNIX operating system send print jobs to shared printers on a UNIX computer named PrintServ.
A. You want to make the shared printers on PrintServ available to the Windows 2000 Professional computers, the Windows 2000 Server computers and the Windows XP Professional computers.
B. What should you do?
C. Use the SRVANY utility from the Windows NT Resource Kit to run the LPR program as a service.
D. Configure each of the printers to support TCP/IP printing.
E. Create an LPR port on each client that is configured to use PrintServ.
F. Configure each of the printers to use LPR port
5. [单选题]Ezonexam has 50 offices. The employees in these offices have limited knowledge of Windows 2000. Each office has a network of between five and 20 client computers. The office networks are connected to each other. The company is buying 50 identical computers to run Windows 2000 Server in these offices. The server must be installed to the company's standard configuration. You use Setup Manager to create a network shared distribution folder and a Unattend.txt file that specifies the company's standard configuration.You want to automate the installation process as much as possible, in the least possible amount of time.
A. What should you do?
B. Run Makebt32.exe to create four installation startup disks and add the Unattend.txt file to the first disk. Instruct an employee at each office to start the installation by using these disks.
C. Create a Microsoft MS-DOS network boot disk that makes a connection to the network shared distribution folder and runs the winnt command with the /s and /u switches. Instruct an employee at each office to start the installation by using this disk.
D. Create a floppy disk that contains only the Unattend.txt file. Instruct an employee at each office to start the installation by using the Windows 2000 Server compact disc, with the floppy disk inserted.
E. Create a Windows 2000 folder on a hard disk. Copy the Windows 2000 Server compact disc to the folder. Add the Unattend.txt file to the folder. Copy the folder to a writeable C Instruct an employee at each office to start the installation by suing this C
