[Solved] What is wrong with this transaction?BEGIN TRANSACTION;UPDATE employees SET salary = salary + 1000;ROLLBACK;COMMIT; | SQL

SQL - Transactions and Data Integrity

What is wrong with this transaction?

BEGIN TRANSACTION;
UPDATE employees SET salary = salary + 1000;
ROLLBACK;
COMMIT;

AMissing SAVEPOINT before ROLLBACK

BROLLBACK should be after COMMIT

CCannot update without WHERE clause

DCOMMIT after ROLLBACK commits no changes

Step-by-Step Solution

Solution:

Step 1: Understand ROLLBACK effect
ROLLBACK cancels all changes made in the transaction.
Step 2: Effect of COMMIT after ROLLBACK
COMMIT after ROLLBACK commits no changes because transaction is empty.
Final Answer:
COMMIT after ROLLBACK commits no changes -> Option D
Quick Check:
ROLLBACK clears changes before COMMIT [OK]

Quick Trick: ROLLBACK clears changes; COMMIT after saves nothing [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 wrong with this transaction?