Multiple choice technology databases

Which command will delete all data from a table and will not write to the rollback segment?

  1. DROP

  2. DELETE

  3. REMOVE

  4. TRUNCATE
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

TRUNCATE is a DDL command that deallocates data pages without logging individual row deletions, so it doesn't write to rollback segments. DELETE is a DML operation that logs each deletion for rollback. DROP removes the entire table structure, not just its data.

Keep practicing — related questions