[Solved] Identify the error in the following transaction code:BEGIN TRANSACTION; SAVEPOINT sp1; INSERT INTO orders VALUES (101, 'Book'); ROLLBACK TO sp2; COMMIT; | SQL

SQL - Transactions and Data Integrity

Identify the error in the following transaction code:

BEGIN TRANSACTION;
SAVEPOINT sp1;
INSERT INTO orders VALUES (101, 'Book');
ROLLBACK TO sp2;
COMMIT;

AROLLBACK TO references a non-existent savepoint

BMissing COMMIT before SAVEPOINT

CSAVEPOINT must come after INSERT

DROLLBACK TO cannot be used inside transactions

Step-by-Step Solution

Solution:

Step 1: Check savepoint names
Only sp1 is created, but rollback tries to use sp2 which does not exist.
Step 2: Validate transaction flow
Rollback to a non-existent savepoint causes an error; other statements are valid.
Final Answer:
ROLLBACK TO references a non-existent savepoint -> Option A
Quick Check:
Rollback must use existing savepoint name [OK]

Quick Trick: Rollback must refer to an existing savepoint [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 the following transaction code: