Which command is used to remove all records from a table while keeping the…

2026

Which command is used to remove all records from a table while keeping the table structure intact and cannot be rolled back in most default settings?

  1. A.

    DELETE

  2. B.

    DROP

  3. C.

    TRUNCATE

  4. D.

    REMOVE

Attempted by 566 students.

Show answer & explanation

Correct answer: C

The correct command is TRUNCATE. Unlike DELETE, which removes rows individually and can be rolled back (DML), TRUNCATE is a DDL command that removes all data instantly without logging individual row deletions. It preserves the table structure but typically cannot be rolled back in most default settings due to implicit commits.

Explore the full course: Up Lt Grade Assistant Teacher 2025