[Solved] Consider this sequence with auto-commit OFF:INSERT INTO users (id, name) VALUES (1, 'Alice');ROLLBACK;SELECT * FROM users WHERE id = 1;What will the SELECT query return? | SQL

SQL - Transactions and Data Integrity

Consider this sequence with auto-commit OFF:

INSERT INTO users (id, name) VALUES (1, 'Alice');
ROLLBACK;
SELECT * FROM users WHERE id = 1;

What will the SELECT query return?

AA row with id=1 and name='Alice'

BNo rows

CSyntax error

DAll rows in users table

Step-by-Step Solution

Solution:

Step 1: Analyze the INSERT and ROLLBACK with auto-commit OFF
With auto-commit OFF, the INSERT is not saved until COMMIT. ROLLBACK undoes the INSERT.
Step 2: Determine SELECT result after rollback
Since the INSERT was undone, the SELECT finds no row with id=1.
Final Answer:
No rows -> Option B
Quick Check:
ROLLBACK undoes changes, so SELECT returns no rows [OK]

Quick Trick: ROLLBACK undoes uncommitted changes, so no new rows appear [OK]

Common Mistakes:

Master "Transactions and Data Integrity" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Consider this sequence with auto-commit OFF: