Multiple choice technology programming languages

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

  1. DROP

  2. TRUNCATE

  3. DELETE

  4. CASCADE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The TRUNCATE command is a DDL statement that removes all rows from a table immediately. Because it is DDL, it commits automatically and does not write individual row deletes to the rollback segment, making it faster than DELETE. DROP deletes the table structure entirely.

Keep practicing — related questions