Multiple choice technology databases

Which is not right for Truncate Statement

  1. Deletes rows from table

  2. Removes storage space

  3. Removes table structure

  4. All of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

TRUNCATE is a DDL command that quickly removes all rows from a table and deallocates the storage space, but it does NOT remove the table structure itself - that would be DROP TABLE. Unlike DROP TABLE which completely removes the table definition, TRUNCATE keeps the table schema intact with all columns and constraints. Options A and B are both correct descriptions of what TRUNCATE does, making C the only option that is 'not right.'

Keep practicing — related questions