Multiple choice technology databases

Which statements below are correct for TRUNCATE command

  1. Command is used to delete all the rows of the table.

  2. Command is used to delete complete table structure.

  3. Command free the space used by the table.

  4. Command deletes all the constraints,relations and previleges with other tables
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

TRUNCATE is a DDL command that removes all rows from a table efficiently without logging individual row deletions. It deallocates the space used by the table (though the exact behavior varies by DBMS). TRUNCATE does NOT delete the table structure itself - that would be DROP TABLE. It also does not delete constraints, relationships, or privileges - those remain intact.

Keep practicing — related questions