Multiple choice technology databases

If DBCC CHECKDB for a database then DBCC CHECKALLOC has to be run separately.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

DBCC CHECKDB is a comprehensive command that performs database validation including checks done by DBCC CHECKALLOC (allocation structure validation), CHECKTABLE, and CHECKCATALOG. Running CHECKDB already includes allocation checks, so running CHECKALLOC separately is redundant. CHECKDB is the all-in-one integrity check command for production databases.

Keep practicing — related questions