Microsoft
70-432 · Question #215
You maintain a SQL Server 2008 instance that contains a database named Finance. You suspect that three large tables in the Finance database are corrupt. You plan to execute the DBCC CHECKTABLE…
The correct answer is D. SINGLE_USER. See the full explanation below for the reasoning.
Question
You maintain a SQL Server 2008 instance that contains a database named Finance. You suspect that three large tables in the Finance database are corrupt. You plan to execute the DBCC CHECKTABLE statement concurrently on the three tables to minimize downtime. You need to set the database option to prevent users from accessing the database during the execution of the statement. Which database option should you turn on?
Options
- AOFFLINE
- BREAD_ONLY
- CRESTRICTED_USER
- DSINGLE_USER
How the community answered
(47 responses)- A6% (3)
- B11% (5)
- C2% (1)
- D81% (38)
Community Discussion
No community discussion yet for this question.