[Solved] Examine this transaction:BEGIN TRANSACTION; UPDATE orders SET status = 'shipped' WHERE id = 5; COMMIT; ROLLBACK;What is the issue here? | SQL

SQL - Transactions and Data Integrity

Examine this transaction:

BEGIN TRANSACTION;
UPDATE orders SET status = 'shipped' WHERE id = 5;
COMMIT;
ROLLBACK;

What is the issue here?

ACOMMIT should come after ROLLBACK

BROLLBACK after COMMIT has no effect and is redundant

CBEGIN TRANSACTION is missing a semicolon

DUPDATE statement syntax is incorrect

Step-by-Step Solution

Solution:

Step 1: Analyze transaction flow
Transaction starts, updates data, then commits changes.
Step 2: Understand ROLLBACK usage
ROLLBACK undoes uncommitted changes; after COMMIT, it has no effect.
Final Answer:
ROLLBACK after COMMIT has no effect and is redundant -> Option B
Quick Check:
ROLLBACK cannot undo committed transactions [OK]

Quick Trick: ROLLBACK after COMMIT does nothing [OK]

Common Mistakes:

Master "Transactions and Data Integrity" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Examine this transaction: