Bird
0
0

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

easy📝 Conceptual Q1 of 15
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:
  1. Step 1: Understand COMMIT

    The COMMIT command finalizes all changes made during the transaction.
  2. Step 2: Effect on database

    Once committed, changes become permanent and visible to other users.
  3. Final Answer:

    The changes are permanently saved to the database. -> Option A
  4. Quick Check:

    COMMIT saves changes permanently [OK]
Quick Trick: COMMIT makes changes permanent immediately [OK]
Common Mistakes:
  • Thinking COMMIT only marks changes temporarily
  • Assuming changes can be rolled back after COMMIT
  • Confusing COMMIT with ROLLBACK

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes