[Solved] Consider this SQL code:BEGIN TRANSACTION; UPDATE accounts SET balance = balance - 100 WHERE id = 1;... COMMIT;What is the effect of this transaction? | SQL

SQL - Transactions and Data Integrity

Consider this SQL code:

BEGIN TRANSACTION;
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;
COMMIT;

What is the effect of this transaction?

AThe transaction will cause an error

BOnly the first update is saved

CBoth updates happen together or not at all

DUpdates happen immediately without grouping

Step-by-Step Solution

Solution:

Step 1: Analyze the transaction block
The two updates are inside a transaction started by BEGIN TRANSACTION; and ended by COMMIT;.
Step 2: Understand transaction behavior
Both updates will be saved together if no errors occur; if an error happens, none will be saved.
Final Answer:
Both updates happen together or not at all -> Option C
Quick Check:
Transaction = all or nothing [OK]

Quick Trick: Transactions group changes to save or cancel together [OK]

Common Mistakes:

Master "Transactions and Data Integrity" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Consider this SQL code: