You are the database administrator of a SQL Server 2000 comp

【名词&注释】

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

[单选题]You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to perfect the physical integrity of the Accounts database. You do not want to slow down server operations.

A. What should you do?
B. Enable the torn page detection database option for each database.
C. Disable write caching on all disk controllers.
D. Ensure that write caching disk controllers have battery backups.
E. Create a database maintenance plan to check database integrity and make repairs each night.

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

学习资料：

[单选题]You want to upgrade 150 computers from Windows NT Workstation 4.0 to Windows 2000 Professional.You create an Unattend.txt file by using Setup Manager. You copy the file to a floppy disk.

A. You then start the installation on a test computer by using the Windows 2000 Professional CD-ROM.
B. You insert the floppy disk after the computer starts.
C. Although you had set the user interaction level to full unattended mode, you are prompted for all the required parameters. You want to ensure that the unattended installation does not prompt you for input.
D. What should you do?
E. Add a [Data] section to Unattend.txt, and set the Unattendedinstall parameter to Yes.
F. Add an [Unattend] section to Unattend.txt, and set the OEMPreinstall parameter to yes.
G. Rename Unattend.txt on the floppy disk to Winnt.sif.
H. Create a \$Oem$\$1 folder on the hard disk of the test computer, and copy Unattend.txt to the folder.

[多选题]You are the administrator of a SQL Server 2000 computer. The server contains your company's order processing database. Two-hundred operators take orders by telephone 24 hours a day. Threehundred data entry personnel enter data from orders received by mail.To ensure that order data will not be lost, your company's disaster recovery policy requires that backups be written to tape. Copies of these tapes must be stored at an off-site company location. Orders must be entered into the database before they can be filled. If the server fails, you must be able to recover the order data as quickly as possible.

A. You need to create a backup strategy that meets the company requirements and minimizes server workload. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)
B. Perform. a combination of full database and filegroup backups.
C. Perform. a combination of full database and file backups.
D. Perform. a combination of full database, differential, and transaction log backups.
E. Back up the data to a local tape drive.
F. Back up the data to a network share, and then use enterprise backup software to write the disk backups to tape.

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