You administer a SQL Server 2008 instance that contains a database named SpatialDB. The
SpatialDB database includes spatial data types.
You need to perform a database consistency check on SpatialDB to include the spatial
indexes. You also need to ensure that the effect on the database concurrency is minimized.
Which Transact-SQL statement should you execute?
A.
DBCC CHECKCATALOG (SpatialDB);
B.
DBCC CHECKALLOC (SpatialDB) WITH TABLOCK;
C.
DBCC CHECKDB (SpatialDB) WITH TABLOCK. PHYSICAL_ONLY:
D.
DBCC CHECKDB (SpatialDB) WITH EXTENDED_LOGICAL_CHECKS:
Explanation: