[Solved] What is the result of this transaction sequence?BEGIN TRANSACTION; INSERT INTO orders (id, amount) VALUES (1, 50); ROLLBACK; SELECT * FROM orders WHERE id = 1; | SQL

SQL - Transactions and Data Integrity

What is the result of this transaction sequence?

BEGIN TRANSACTION;
INSERT INTO orders (id, amount) VALUES (1, 50);
ROLLBACK;
SELECT * FROM orders WHERE id = 1;

AOne row with id 1 and amount 50 is returned

BNo rows returned because the insert was rolled back

CSyntax error due to missing COMMIT

DEmpty table error occurs

Step-by-Step Solution

Solution:

Step 1: Understand ROLLBACK effect
ROLLBACK cancels all changes made in the transaction, undoing the insert.
Step 2: Check SELECT result after rollback
The inserted row does not exist after rollback, so SELECT returns no rows.
Final Answer:
No rows returned because the insert was rolled back -> Option B
Quick Check:
ROLLBACK cancels changes = A [OK]

Quick Trick: ROLLBACK undoes all changes in the transaction [OK]

Common Mistakes:

Master "Transactions and Data Integrity" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

What is the result of this transaction sequence?