多做题,通过考试没问题!

微软认证考试

睦霖题库>其他计算机考试>微软认证考试

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.
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题