Database Consistency Checks Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Database Maintenance

What you'll be asked

  1. Which command is the standard tool used in Microsoft SQL Server to check the logical and physical integrity of all objects in a database?
  2. When performing a database consistency check on a large production database, why might an administrator choose to use the 'PHYSICAL_ONLY' option?
  3. If a database consistency check reports 'Allocation Errors', what is the most likely cause?
  4. Which of the following is the recommended best practice before running a repair command like 'REPAIR_ALLOW_DATA_LOSS'?
  5. During a DBCC CHECKDB operation, the process encounters a 'Cross-Page' error. What does this specifically indicate about the database state?

Answers and explanations come after you submit.