Multiple choice technology databases

Which of the following commands cause a transaction to end?

  1. DELETE

  2. ALTER

  3. INSERT

  4. UPDATE

  5. ROLLBACK
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

ROLLBACK ends a transaction by discarding all pending data changes made during the transaction. DML statements like INSERT, UPDATE, and DELETE start or continue a transaction, rather than ending it. ALTER is a DDL statement that implicitly commits, but ROLLBACK is the direct command explicitly designed to end a transaction by undoing changes.

Keep practicing — related questions