[Solved] Examine this transaction:BEGIN TRANSACTION;UPDATE inventory SET quantity = quantity - 5 WHERE product_id = 20;COMMIT;ROLLBACK;What is the issue with this sequence? | SQL

SQL - Transactions and Data Integrity

Examine this transaction:

BEGIN TRANSACTION;
UPDATE inventory SET quantity = quantity - 5 WHERE product_id = 20;
COMMIT;
ROLLBACK;

What is the issue with this sequence?

AROLLBACK should be before COMMIT to save changes.

BROLLBACK has no effect after COMMIT has been executed.

CCOMMIT cannot be used after UPDATE statements.

DBEGIN TRANSACTION is missing a SAVEPOINT.

Step-by-Step Solution

Solution:

Step 1: Understand COMMIT effect
COMMIT finalizes changes permanently.
Step 2: Role of ROLLBACK after COMMIT
ROLLBACK cannot undo changes after commit.
Final Answer:
ROLLBACK has no effect after COMMIT has been executed. -> Option B
Quick Check:
ROLLBACK ineffective post-COMMIT [OK]

Quick Trick: ROLLBACK cannot undo committed changes [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: