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. CASCADE

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

The TRUNCATE command is a DDL operation that quickly deletes all rows from a table without logging individual row deletions in the rollback segment, unlike DELETE which writes to rollback.

Keep practicing — related questions