You are the administrator of a SQL Server 2000 database name

【名词&注释】

布丁学网发布"You are the administrator of a SQL Server 2000 database name"考试试题下载及答案，更多微软认证的考试试题下载及答案考试题库请访问布丁学网计算机类考试频道。

[单选题]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

查看答案&解析查看所有试题

学习资料：

[单选题]Your network includes Windows 2000 Professional client computers, Windows NT Workstation 4.0 client computers, Windows 95 client computers and UNIX client computers. Users of the Windows operating systems send print jobs to shared printers on a Windows 2000 Server computer named PrintServ. The UNIX client computers support the LPR printing protocol.You want to make the shared printers on PrintServ available to the UNIX computers. What should you do?

A. Configure each of the printers to use an LPR port.
B. Install Microsoft Print Services for UNIX on PrintServ.
C. Configure each of the printers to support TCP/IP printing.
D. Use the SRVANY utility from the Windows NT Resource Kit to run the LPR program as a service.

[单选题]You are preparing to install Windows 2000 Server on a new computer. The computer is connected to a network that includes Windows 98 computers and Windows 2000 Server computers.You want to install Windows 2000 Server from source files that are located on a server on the network.

A. What should you do?
B. Start the new computer by using a Windows 98 network boot disk. Connect to the network server. Run Winnt32.exe.
C. Start the new computer by using Windows 98 network boot disk. Connect to the network server. Run Winnt.exe.
D. On a Windows 2000 Server computer, use Makebt32.exe to create installation startup disk. Start the new computer by using the first disk.
E. On a Windows 2000 computer, format a floppy disk. Copy NTLDR, boot.ini, Ntdetect.com, Ntbootdd.sys to this disk. Start the new computer by using the disk.

[单选题]You are the administrator of a SQL Server 2000 computer. You create several jobs on the server and schedule them to run during the evening.You configure an operator on the server and configure the jobs to send an e-mail to this operator if a job fails for any reason.

A. While testing the jobs, you discover that e-mail messages are not being sent to the operator when a job fails. You use SQL Server Enterprise Manager to confirm that SQL Mail is started.
B. You need to ensure that e-mail messages are sent to the operator whenever a job fails. What should you do?
C. Configure SQLAgentMail to use a valid MAPI profile
D. Configure SQL Mail to use a mailbox that delegates permissions to the operator
E. Use the net send notification method to send the operator e-mail messages
F. Create a job that executes the xp_startmail stored procedure Configure the job to run whenever SQL Server 2000 starts

本文链接：https://www.51ksbd.net/show/xoq89v.html