[Solved] After executing COMMIT in a transaction, what is the state of the changes made? — Ans: The changes are permanently saved to the database. | SQL

SQL - Transactions and Data Integrity

After executing COMMIT in a transaction, what is the state of the changes made?

AThe changes are permanently saved to the database.

BThe changes are discarded and not saved.

CThe changes remain temporary until the session ends.

DThe changes are saved only if the session is closed properly.

Step-by-Step Solution

Solution:

Step 1: Understand COMMIT
The COMMIT command finalizes all changes made during the transaction.
Step 2: Effect on database
Once committed, changes become permanent and visible to other users.
Final Answer:
The changes are permanently saved to the database. -> Option A
Quick Check:
COMMIT saves changes permanently [OK]

Quick Trick: COMMIT makes changes permanent immediately [OK]

Common Mistakes:

Master "Transactions and Data Integrity" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

After executing COMMIT in a transaction, what is the state of the changes made?