70-432 Sample Question: 14

Question: 14


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. The DB1 database includes spatial data types. On DB1 database, 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;

Correct Answer: D