Multiple choice technology databases

Which statement is used to delete all rows in a table without having the action logged?

  1. drop

  2. Delete

  3. truncate

  4. None of the Above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Truncate is a DDL statement that quickly deletes all rows in a table without logging individual row deletions. Delete is a DML statement that logs every row deletion in the transaction log, while drop completely deletes the table structure from the database.

Keep practicing — related questions