You are the administrator of two SQL Server 2000 computers.

【名词&注释】

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

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

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

学习资料：

[单选题]You want to install Windows 2000 Professional on 45 new computers on your company's network. You first install Windows 2000 Professional on one of the new computers.You log on to the computer by using the local Administrator account. You install Microsoft Office 97, a virus scanner, and other company-standard applications. You then create a RIS image of the computer you configured.

A. You want to configure the RIS image so that the standard applications will be accessible to the user when the user first logs on to the network. What should you do?
B. Run Rbfg.exe before installing the standard applications.
C. Run RIPrep.exe before installing the standard applications.
D. Copy the All Users profile to the Default Users profile.
E. Copy the local Administrator account profile to the Default Users profile

[单选题]You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.You want the package to execute automatically each evening at 8:00 P.M. What should you do?

A. Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.
B. Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.
C. Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system account
D. Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.

[单选题]You are the network administrator for Ezonexam.The network includes a Windows 2000 Server computer that contains a single 36-GB hard disk. The drive is configured as a basic disk and has two partitions. Partition C is 4 GB in size and contains the operating system files. Partition D is 32 GB in size and contains user data that is updated frequently.

A. for the computer, and Recovery Console is installed on the computer.
B. One day at2:00 P.M., the server fails. You attempt to restart the computer, but you receive the following error message: "Boot disk or operating system not found." You use Recovery Console to discover that the files on partition C are corrupted.
C. You want to recover the server from the failure as quickly as possible. You also want to recover as much user data as possible.
D. What should you do?
E. Start the computer by using a Windows 2000 Server compact disc. Select the Repair option in Setup.
F. Install a second hard disk in the computer. Install Windows 2000 Server on the new hard disk. Re-create the shared folders on the first hard disk.
G. Use a Windows 2000 Server boot floppy disk to start the computer. Replace the corrupted files on partition C by copying them from the Emergency Repair Disk.
H. Boot to the Recovery Console. Copy any files that have changed since 11:00 P.M. the previous evening to a second server. Use the most recent tape backup to restore the remaining user data to the second server.

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