Database Fundamentals — Question 108

Which of the following commands cannot be rolled back? Each correct answer represents a complete solution. (Choose two.)

Answer options

• A. DELETE
• B. TRUNCATE
• C. UPDATE
• D. COMMIT

Correct answer: B, D

Explanation

The TRUNCATE command cannot be rolled back because it removes all rows from a table without logging individual row deletions. Similarly, the COMMIT command finalizes all transactions, making it impossible to revert any changes made after it. In contrast, DELETE and UPDATE can be rolled back if they are part of a transaction that hasn't been committed.