Multiple choice

All changes made by a transaction are undone by

  1. COMMIT

  2. DROP

  3. ROLLBACK

  4. SAVEPOINT
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

ROLLBACK is the SQL command that undoes all changes made during the current transaction, restoring the database to its state before the transaction began. COMMIT permanently saves changes, while DROP deletes database objects and SAVEPOINT marks intermediate points within a transaction.

Keep practicing — related questions