[Solved] You run these commands with auto-commit OFF:UPDATE products SET price = price * 0.9 WHERE category = 'Books';COMMIT;ROLLBACK;What is the state of the prices after these commands? | SQL

SQL - Transactions and Data Integrity

You run these commands with auto-commit OFF:

UPDATE products SET price = price * 0.9 WHERE category = 'Books';
COMMIT;
ROLLBACK;

What is the state of the prices after these commands?

APrices are updated with 10% discount

BPrices remain unchanged

CSyntax error due to ROLLBACK after COMMIT

DPartial update applied

Step-by-Step Solution

Solution:

Step 1: Understand effect of UPDATE and COMMIT
UPDATE changes prices, COMMIT saves these changes permanently.
Step 2: Analyze ROLLBACK after COMMIT
ROLLBACK after COMMIT has no effect because changes are already saved.
Final Answer:
Prices are updated with 10% discount -> Option A
Quick Check:
COMMIT saves changes; ROLLBACK after does nothing [OK]

Quick Trick: COMMIT saves changes; 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

You run these commands with auto-commit OFF: