Multiple choice technology programming languages

Which three statements/commands would cause a transaction to end?

  1. COMMIT

  2. SELECT

  3. CREATE

  4. ROLLBACK

  5. SAVEPOINT

Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

COMMIT and ROLLBACK explicitly end a transaction by saving or discarding changes. CREATE acts as an implicit commit - it ends the current transaction before creating the new object. SELECT and SAVEPOINT do not end transactions.