1. [单选题]You are the administrator of a SQL Server 2000 database named Articles. A large city newspaper uses this database to store its archived newspaper articles. Journalists query the database as part of their research. You have created full-text indexes so that users can query the articles quickly.A hardware failure forces you to restore the entire database from backup. After you restore the database, the journalists report that they can no longer run queries without receiving errors.
A. You want to ensure that the journalists can query the database. What should you do?
B. Create a new full-text catalog for the Articles database
C. Rebuild the full-text catalog for the Articles database
D. Create a new full-text index on the table that holds the text for the articles
E. Repopulate the full-text index on the table that holds the text for the articles
2. [单选题]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
3. [单选题]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.
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. [多选题]You recently upgraded all Windows NT Workstation 4.0 computers to Windows 2000 Professional. You want to give a new employee named Maria the ability to back up files, share resources, and install programs on a client computer that she shares with other users. You do not want Maria to be able to read other users' files.What should you do to accomplish these goals? (Choose all that apply)
A. Add Maria's user account to the System group.
B. Add Maria's user account to the Interactive group.
C. Add Maria's user account to the Power Users group.
D. Add Maria's user account to the Administrators group.
E. Add Maria's user account to the Backup Operators group.
