Which Transact-SQL statement should you execute?

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?

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:



Leave a Reply 0

Your email address will not be published. Required fields are marked *