[Solved] Find the problem in this transaction:BEGIN TRANSACTION; DELETE FROM users WHERE id = 5; UPDATE users SET name = 'John' WHERE id = 6; | SQL

SQL - Transactions and Data Integrity

Find the problem in this transaction:

BEGIN TRANSACTION;
DELETE FROM users WHERE id = 5;
UPDATE users SET name = 'John' WHERE id = 6;

AMissing COMMIT or ROLLBACK to end the transaction

BDELETE statement syntax is incorrect

CUPDATE statement cannot be inside a transaction

DBEGIN TRANSACTION is not supported in SQL

Step-by-Step Solution

Solution:

Step 1: Check transaction completeness
Every transaction must end with COMMIT or ROLLBACK to finalize changes.
Step 2: Identify missing statement
This transaction lacks COMMIT or ROLLBACK, so it remains open and uncommitted.
Final Answer:
Missing COMMIT or ROLLBACK to end the transaction -> Option A
Quick Check:
Transactions must end with COMMIT or ROLLBACK = B [OK]

Quick Trick: Always finish transactions with COMMIT or ROLLBACK [OK]

Common Mistakes:

Master "Transactions and Data Integrity" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Find the problem in this transaction: