You administer a Microsoft SQL Server 2008 R2 instance. You need to check the physical consistency of the 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 CHECKDB along with the REPAIR_REBUILDcla.se
• 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
  2% (1)
• B
  84% (42)
• E
  4% (2)
• G
  2% (1)
• H
  8% (4)

No community discussion yet for this question.