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

TRUNCATE is a DDL command that deletes all rows from a table and bypasses the rollback segments (undo logs), making it faster and non-transactional. DELETE is DML and writes to rollback segments, whereas DROP removes the entire table structure, and CASCADE is a constraint modifier.

Keep practicing — related questions