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 quickly removes all rows by resetting the table without logging individual row deletions to the rollback segment. DELETE is DML that logs each deletion, DROP removes the entire table structure, and CASCADE is a constraint option for related deletions.

Keep practicing — related questions