You administer a Microsoft SQL Server 2008 R2 instance. The database has been marked as suspect. You need to place the database into an EMERGENCY state for troubleshooting. What should you do?

Question

Options

• AExecute sp_helpfile.
• BExecute DBCC CHECKDB.
• CExamine the msdb..suspect_pagestable.
• DExecute DBCC CHECKDBalong with the REPAIR_FASTclause.
• EExecute DBCC CHECKDBalong with the REPAIR_REBUILDclause.
• FRestore the database from the most recent full backup. Apply any differential and log backups.
• GUse the ALTER DATABASEstatement along with the SET EMERGENCYclause.
• HUse the RESTORE DATABASEstatement along with the PAGESclause.

• A
  2% (1)
• B
  2% (1)
• D
  5% (2)
• E
  7% (3)
• G
  84% (37)

No community discussion yet for this question.