2. 计算机
  3. You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot

You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot

admin2009-05-19  13
问题 You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.


You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.


You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?
选项 A、Increase the maximum file size of Sales_Data to 1,500MB.
B、Use the DBCC SHRINKDATABASE statement.
C、Set automatic file growth to 10 percent.
D、Create another data file named Sales_Data2 in a new SECONDARY filegroup.
答案A
解析 Explanation: By examining the first exhibit we see that the database has reached its maximum size of 1001 MB. The data file is located on drive E and the second exhibit shows us that there is enough free space on that disk to increase the maximum size of the data file to 1,500 MB.

Incorrect Answers:
B: DBCC SHRINKDATABASE could possibly shrink the database and new records could be added for a while, but it would just be a temporary solution.

C: The database is already set to automatic file growth, but it has reached the maximum size.

D: The primary file has reached it maximum size. A secondary filegroup would help if it was set to the default file group. New data would still be added to the primary filegroup which is at its maximum size.
转载请注明原文地址:https://kaotiyun.com/show/7uhZ777K
本试题收录于： 微软70228题库微软认证分类
0

微软70228

微软认证

相关试题推荐
随机试题
最新回复(0)