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 removes all rows from a table without generating rollback data, making it faster than DELETE. DELETE is a DML command that writes to rollback segments for potential recovery. DROP removes the entire table structure, not just data. CASCADE is a constraint option, not a data removal command.

Keep practicing — related questions