未分类题
You are the administrator of a SQL server 2000 computer that contains a database named Acct. The database contains 1.5 GB of data. The server has one 9-GB hard disk that is configured as shown in the Exhibit.
.jpg)
You need to import data into the database without adversely affecting database performance. The data will require an additional 2GB of storage space.
What should you do?
A．Add another data file on drive E, and then add the file to the PRIMARY filegroup.
B．Move the transaction log file to drive E, and set the file growth of Acc_Data.mdf by selecting the Unrestricted file growth option.
C．Rebuild all clustered indexes so that they have a fill factor of 100.
D．Compress drive D.
A.5
B.
You
D.
What
E.Add
F.
B．Move
G.mdf
H.
C．Rebuild
I.
D．Compress
【参考答案】
A
解析：Explanation: We must take precautions so that the i......
(↓↓↓ 点击下方‘点击查看答案’看完整答案 ↓↓↓)
B.
You
D.
What
E.Add
F.
B．Move
G.mdf
H.
C．Rebuild
I.
D．Compress
【参考答案】
A
解析：Explanation: We must take precautions so that the i......
(↓↓↓ 点击下方‘点击查看答案’看完整答案 ↓↓↓)