[Solved] Given auto-commit is OFF, what is the output after these commands?INSERT INTO products (id, name) VALUES (1, 'Pen');ROLLBACK;SELECT COUNT(*) FROM products;Assuming products table was empty before. | SQL

SQL - Transactions and Data Integrity

Given auto-commit is OFF, what is the output after these commands?

INSERT INTO products (id, name) VALUES (1, 'Pen');
ROLLBACK;
SELECT COUNT(*) FROM products;

Assuming products table was empty before.

ANULL

B1

C0

DError

Step-by-Step Solution

Solution:

Step 1: Understand effect of ROLLBACK with auto-commit OFF
Since auto-commit is OFF, the INSERT is not saved until COMMIT. ROLLBACK undoes the insert.
Step 2: Check final count in products table
Because the insert was rolled back, the table remains empty, so COUNT(*) returns 0.
Final Answer:
0 -> Option C
Quick Check:
ROLLBACK undoes changes with auto-commit OFF [OK]

Quick Trick: ROLLBACK cancels uncommitted changes when auto-commit is OFF [OK]

Common Mistakes:

Master "Transactions and Data Integrity" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given auto-commit is OFF, what is the output after these commands?