Multiple choice technology databases

Which command is used to Check integrity of a table or indexed view?

  1. DBCC CHECKIDENT

  2. DBCC CHECKTABLE

  3. DBCC CHECKALLOC

  4. DBCC CHECKINTEG
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

DBCC CHECKTABLE checks the integrity of a table or indexed view, verifying page linking, structural integrity, and performing internal consistency checks. CHECKIDENT checks identity values, CHECKALLOC verifies allocation structures, and CHECKINTEG isn't a valid DBCC command.

Keep practicing — related questions