You are a profes_睦霖题库

单项选择题 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 a database administrator for your company. Your job is to manage a SQL Server 2005 database， and there are several indexes in the SQL Server 2005. A stored procedure should be written， and the procedure should be utilized to check the indexes for fragmentation. From the following four Transact-SQL statements， which one should be utilized achieve the goal？（）: A、To achieve the goal， DBCC DBREINDEX should be utilized.; B、To achieve the goal， SELECT * FROM sys.indexes should be utilized.; C、To achieve the goal， SELECT * FROM sys.dm_db_index_physical_stats should be utilized.; D、To achieve the goal， DBCC INDEXDEFRAG should be utilized.

热门试题