Microsoft
70-432 · Question #25
You are the administrator of a SQL Server 2008 instance with a database named DB1 in the instance. The DB1 database includes spatial data types. On DB1 database, you have to perform a database…
The correct answer is D. DBCC CHECKDB (DB1) WITH EXTENDED_LOGICAL_CHECKS. See the full explanation below for the reasoning.
Question
You are the administrator of a SQL Server 2008 instance with 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. Which Transact-SQL statement should you run?
Options
- ADBCC CHECKCATALOG (DB1);
- BDBCC CHECKALLOC (DB1) WITH TABLOCK;
- CDBCC CHECKDB (DB1) WITH TABLOCK, PHYSICAL_ONLY;
- DDBCC CHECKDB (DB1) WITH EXTENDED_LOGICAL_CHECKS;
How the community answered
(21 responses)- A5% (1)
- B10% (2)
- C5% (1)
- D81% (17)
Community Discussion
No community discussion yet for this question.