You administer a Microsoft SQL Server 2008 R2 instance. You need to ensure that no suspect pages have been detected in your database. 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.
• GUse the ALTER DATABASEstatement along with the SET EMERGENCYclause.
• HUse the RESTORE DATABASEstatement along with the PAGESclause.

• A
  4% (2)
• B
  2% (1)
• C
  79% (38)
• E
  10% (5)
• G
  4% (2)

No community discussion yet for this question.