Multiple choice technology databases

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

TRUNCATE removes all rows from a table and does so as a DDL operation that does not generate individual row delete logs, meaning it does not write to the rollback segment. DROP removes the table definition, and DELETE logs each row, while CASCADE is not a standalone command for this purpose.

Keep practicing — related questions