题目内容

You are the administrator of a SQL Server 2000 computer. The server contains a database named Acct. You purge the Acct database of old records and perform. a full backup. The database now uses 4 GB of space. The database files are configured as shown in the Acct Properties exhibit.
The server has two hard disks that are configured as shown in the Server Configuration exhibit.
The 3 GB transaction log file for the Acct database is stored on drive C. You need to make room for a new database that has a 3 GB data file and a 1 GB transaction log file. You want to optimize database performance on both databases. You also want to minimize administrative overhead.
What should you do？

A. Shrink the empty data file on drive E. Place the new data file and the new log file on drive E.
B. Shrink the empty data file on drive E. Backup and shrink the log file on drive C to 2 GB. Place the new data file on drive E and the new log file on drive C.
C. Shrink the data file on drive D to 1 GB, and then shrink the data file on drive E to 2 GB. Place the new data file on drive D and the new log file on drive E.
D. Shrink and delete the data file on drive C, and then shrink the database files on drives D and E so that they are both 2 GB. Place the new data file and the new log file on drive C.

查看答案

搜索结果不匹配？点我反馈

更多问题

You are the administrator of a SQL Server 2000 computer. Your company purchased an accounting application from a vendor. The application stores its data in a database named Accounting on the server. The tables in this database contain columns that function as primary keys, but PRIMARY KEY and FOREIGN KEY constraints are not used.
You need to replicate data from this database to another SQL Server computer. This server will use the replicated data to generate reports. Most reports will run each month, but the accounting department needs to have the ability to run reports at any time. Reports should be accurate through the last full working day.
You cannot make any changes to the database, but you need to implement replication. Which two actions should you take？ (Each correct answer presents part of the solution. Choose two)

A. Implement merge replication.
B. Implement snapshot replication.
C. Implement transactional replication.
D. Schedule replication to run continuously.
E. Schedule replication to run during off-peak hours.

查看答案

You are the administrator of a SQL Server computer. Users report that the database times out when they attempt to modify data. You use the Current Activity window to examine locks held in the database as shown in the following screenshot.
You need to discover why users cannot modify data in the database, but you do not want to disrupt normal database activities. What should you do？

A. Use the spid 52 icon in the Current Activity window to discover which SQL statement is being executed
B. Use the sp_who stored procedure to discover who is logged in as spid 52
C. Use SQL Profiler to capture the activity of the user who is logged in as spid 52
D. Use System Monitor to log the locks that are granted in the database

查看答案

作为无形资产人账的商誉，既可以白创，也可以外购。

A. 正确
B. 错误

查看答案

You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.
You want to complete the data load as quickly as possible. What should you do？ (Each correct answer represents part of the solution. Choose all that apply.)

Apply a bulk update lock to the table.
B. Use separate client connections to load the files into the table simultaneously.
Create a clustered index on the table.
D. Specify the Full Recovery model for the database.
E. Specify the Bulk-Logged Recovery model for the database.

查看答案