Microsoft
70-432 · Question #185
You design a maintenance plan for a SQL Server 2008 instance that contains a database named SalesDB. The SalesDB database includes spatial indexes to support queries on spatial data. You need to…
The correct answer is A. DBCC SYS_CHECK (SalesDB). See the full explanation below for the reasoning.
Question
You design a maintenance plan for a SQL Server 2008 instance that contains a database named SalesDB. The SalesDB database includes spatial indexes to support queries on spatial data. You need to perform physical consistency checks on SalesDB. You also need to ensure that the performance effect on the SalesDB database is minimized. Which Transact-SQL statement should you execute?
Options
- ADBCC SYS_CHECK (SalesDB);
- BDBCC SQLPERF (SalesDB);
- CDBCC RSPAIRDB (SalesDB);
- DDBCC CHECKDB (SalesDB);
How the community answered
(48 responses)- A75% (36)
- B4% (2)
- C15% (7)
- D6% (3)
Community Discussion
No community discussion yet for this question.