可学答题网 > 问答 > MCTS(70-432)题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You work in a com


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? () 

  • ADBCC CHECKCATALOG (DB1); 
  • BDBCC CHECKALLOC (DB1) WITH TABLOCK; 
  • CDBCC CHECKDB (DB1) WITH TABLOCK, PHYSICAL_ONLY; 
  • DDBCC CHECKDB (DB1) WITH EXTENDED_LOGICAL_CHECKS;&e
参考答案
参考解析:
分类:MCTS(70-432)题库
相关推荐

1、You work in a com

You work in a company which uses SQL Server 2008. You are the administrator of the co...

2、You work in a com

You work in a company which uses SQL Server 2008. You are the administrator of the co...

3、You work in a com

You work in a company which uses SQL Server 2008. You are the administrator of the co...

4、You work in a com

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. ...

5、You work in a com

You work in a company which uses SQL Server 2008. You are the administrator of the co...

6、You work in a com

You work in a company which uses SQL Server 2008. You are the administrator of the co...