[Solved] In a system with auto-commit OFF, you run:UPDATE accounts SET balance = balance + 50 WHERE id = 2;INSERT INTO logs (event) VALUES ('Deposit');Then the connection... What happens to these changes? | SQL

SQL - Transactions and Data Integrity

In a system with auto-commit OFF, you run:

UPDATE accounts SET balance = balance + 50 WHERE id = 2;
INSERT INTO logs (event) VALUES ('Deposit');

Then the connection drops before COMMIT. What happens to these changes?

AAll changes are lost due to no COMMIT

BChanges are saved automatically

COnly UPDATE is saved

DOnly INSERT is saved

Step-by-Step Solution

Solution:

Step 1: Understand auto-commit OFF and connection drop
Without COMMIT, changes remain uncommitted.
Step 2: Effect of connection drop on uncommitted changes
Connection drop causes rollback of uncommitted changes.
Final Answer:
All changes are lost due to no COMMIT -> Option A
Quick Check:
Uncommitted changes lost on connection drop [OK]

Quick Trick: Connection drop without COMMIT loses uncommitted changes [OK]

Common Mistakes:

Master "Transactions and Data Integrity" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

In a system with auto-commit OFF, you run: