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

微软认证考试

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

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. TheDB1 database includes spatial data types. On DB1 databse, you have to perform a database consistency check to include the spatial indexes. Besides this, you must make sure that you can reduce the effect on the database concurrency to the least.  So which Transact-SQL statement should you run? () 

  • A、DBCC CHECKCATALOG (DB1); 
  • B、DBCC CHECKALLOC (DB1) WITH TABLOCK; 
  • C、DBCC CHECKDB (DB1) WITH TABLOCK, PHYSICAL_ONLY; 
  • D、DBCC CHECKDB (DB1) WITH EXTENDED_LOGICAL_CHECKS; 
正确答案:D
答案解析:
进入题库查看解析

微信扫一扫手机做题