[Solved] Identify the error in this SQL transaction code:BEGIN TRANSACTION UPDATE products SET stock = stock - 1 WHERE id = 10 COMMIT; | SQL

SQL - Transactions and Data Integrity

Identify the error in this SQL transaction code:

BEGIN TRANSACTION
UPDATE products SET stock = stock - 1 WHERE id = 10
COMMIT;

ABEGIN TRANSACTION cannot be used with UPDATE

BCOMMIT must come before UPDATE

CMissing semicolons after statements

DNo error, code is correct

Step-by-Step Solution

Solution:

Step 1: Check SQL statement syntax
Each SQL statement should end with a semicolon to separate commands.
Step 2: Identify missing semicolons
Both BEGIN TRANSACTION and UPDATE lack semicolons, causing syntax errors.
Final Answer:
Missing semicolons after statements -> Option C
Quick Check:
SQL statements need semicolons to separate [OK]

Quick Trick: Always end SQL statements with semicolons [OK]

Common Mistakes:

Master "Transactions and Data Integrity" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in this SQL transaction code: