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

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

TRUNCATE removes all rows from a table without generating rollback data. It's a DDL operation that's faster than DELETE (which is DML and writes to rollback). DROP removes the entire table structure.

Keep practicing — related questions