[Solved] Why do we need transactions in a database?BEGIN TRANSACTION; UPDATE accounts SET balance = balance - 100 WHERE id = 1; UPDATE accounts SET balance = balance + 100 WHERE id = 2; COMMIT; | SQL

SQL - Transactions and Data Integrity

Why do we need transactions in a database?

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

ATo make sure all steps succeed or none do, keeping data correct

BTo speed up the database queries

CTo allow multiple users to read data at the same time

DTo permanently delete data from the database

Step-by-Step Solution

Solution:

Step 1: Understand the purpose of transactions
Transactions group multiple steps so they all succeed or all fail together, preventing partial updates.
Step 2: Analyze the example code
The example moves money between accounts; if one update fails, the transaction rolls back to keep balances correct.
Final Answer:
To make sure all steps succeed or none do, keeping data correct -> Option A
Quick Check:
Transactions ensure data integrity = A [OK]

Quick Trick: Transactions keep data safe by grouping steps [OK]

Common Mistakes:

Master "Transactions and Data Integrity" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Why do we need transactions in a database?