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

The TRUNCATE command is a DDL statement that removes all data from a table without logging individual row deletions in the transaction rollback segments, making it faster and non-rollbackable. DELETE is a DML statement that writes to rollback segments.

Keep practicing — related questions