Multiple choice technology databases

What does the TRUNCATE statement do?

  1. Removes the table

  2. Removes all rows from a table

  3. shortens the table to 10 rows

  4. Removes all columns from a table

  5. Removes foreign keys from a table
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

TRUNCATE removes all rows from a table quickly by deallocating data pages, unlike DELETE which logs individual row deletions. It does NOT remove the table structure (DROP does that), nor does it limit rows or remove columns/foreign keys. The table structure remains intact.

Keep practicing — related questions