PrepAway - Latest Free Exam Questions & Answers

Which database option should you turn on?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
OFFLINE

B.
READ_ONLY

C.
RESTRICTED_USER

D.
SINGLE_USER


Leave a Reply