移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

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

发布日期:2021-03-17

You work in a company which uses SQL Server 2008. ...
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;

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!

此试题出现在

微软认证考试

护理学章节练习

去刷题