Ending a Transaction

QUESTION: Which three statements/commands would cause a transaction to end? (Choose three.)

A. COMMIT
B. SELECT
C. CREATE
D. ROLLBACK
E. SAVEPOINT

Answer: A,C,D

A transaction is a unit of work containing SQL statements. Transactions end when they are committed or rolled back, or when a DDL statement is issued.

COMMIT will make the changes in the transaction permanent.

ROLLBACK will undo the changes.

CREATE is correct because a DDL statement can start with that.