[Solved] Given the SQL commands:BEGIN TRANSACTION;DELETE FROM customers WHERE id = 3;ROLLBACK;SELECT * FROM customers WHERE id = 3;What will the SELECT query return? | SQL

SQL - Transactions and Data Integrity

Given the SQL commands:

BEGIN TRANSACTION;
DELETE FROM customers WHERE id = 3;
ROLLBACK;
SELECT * FROM customers WHERE id = 3;

What will the SELECT query return?

AThe row with id = 3 will still be present.

BNo rows will be returned because the delete was committed.

CAn error will occur because of the rollback.

DThe row will be partially deleted.

Step-by-Step Solution

Solution:

Step 1: Analyze DELETE and ROLLBACK
The DELETE removes the row but ROLLBACK cancels this change.
Step 2: Effect on SELECT
Since the deletion was rolled back, the row remains in the table.
Final Answer:
The row with id = 3 will still be present. -> Option A
Quick Check:
ROLLBACK restores deleted rows [OK]

Quick Trick: ROLLBACK undoes deletes before commit [OK]

Common Mistakes:

Master "Transactions and Data Integrity" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given the SQL commands: