Microsoft
70-432 · Question #25
70-432 Question #25: Real Exam Question with Answer & Explanation
Sign in or unlock 70-432 to reveal the answer and full explanation for question #25. The question stem and answer options stay visible for context.
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;
Unlock 70-432 to see the answer
You've previewed enough free 70-432 questions. Unlock 70-432 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.