You are a professional level SQL Server 2005 datab...
单选题

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as the administrator of a SQL Server 2005 computer. And recently the server performs gradually slowly. The indexing environment is troubleshooted by you. The clustered indexes are rebuilt by you, and the clustered indexes are utilized the most frequently. The most frequently accessed nonclustered index will be optimized by you. The sys.dm_db_index_usage_stats dynamic management view (DMV) is accessed by you. You can see the results from the table listed below. When the entire index is not read, the nonclustered index which is being utilized the most frequently should be identified.  From the following four object_id and index_id combinations, which one should be utilized to finish the task?()

发布日期:2021-01-28

A.To finish the task, the object_id 869578136 and the index_id 1 should be utilized.

B.To finish the task, the object_id 869578136 and the index_id 5 should be utilized.

C.To finish the task, the object_id 309576141 and the index_id 1 should be utilized.

D.To finish the task, the object_id 2066106401 and the index_id 1 should be utilized.

E.To finish the task, the object_id 2066106401 and the index_id 2 should be utilized.

热门试题

热门资讯

    暂无相关推荐~

分享给好友

分享到朋友圈

取消

使用浏览器的分享功能,把这篇文章分享出去

确定