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 by deallocating the data pages, bypassing the rollback/undo segments for speed. Delete is a DML command that logs each row deletion, and Drop removes the entire table structure, not just the data.

Keep practicing — related questions