Database Fundamentals — Question 118

Which of the following commands are used to terminate a transaction? Each correct answer represents a complete solution. (Choose all that apply.)

Answer options

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

Correct answer: A, C, D

Explanation

The correct answers are A, C, and D because TRUNCATE is used to remove all records from a table without logging individual row deletions, ROLLBACK is used to undo changes made during a transaction, and COMMIT is used to save all changes made in the transaction. Option B, DELETE, is used to remove specific records but does not terminate a transaction by itself.