Solution:Step 1: Understand the UPDATE and COMMITUPDATE increases prices by 10%, COMMIT saves these changes permanently.Step 2: Effect on SELECT querySELECT shows updated prices reflecting the 10% increase for books.Final Answer:Prices increased by 10% for all books -> Option DQuick Check:COMMIT sav

[Solved] Given the commands:BEGIN TRANSACTION;UPDATE products SET price = price * 1.1 WHERE category = 'Books';COMMIT;SELECT price FROM products WHERE category = 'Books';What will the SELECT query show? | SQL

SQL - Transactions and Data Integrity

Given the commands:

BEGIN TRANSACTION;
UPDATE products SET price = price * 1.1 WHERE category = 'Books';
COMMIT;
SELECT price FROM products WHERE category = 'Books';

What will the SELECT query show?

APrices decreased by 10% for books

BPrices unchanged for books

CAn error due to missing ROLLBACK

DPrices increased by 10% for all books

Step-by-Step Solution

Solution:

Step 1: Understand the UPDATE and COMMIT
UPDATE increases prices by 10%, COMMIT saves these changes permanently.
Step 2: Effect on SELECT query
SELECT shows updated prices reflecting the 10% increase for books.
Final Answer:
Prices increased by 10% for all books -> Option D
Quick Check:
COMMIT saves updated prices [OK]

Quick Trick: COMMIT saves updates made in transaction [OK]

Common Mistakes:

Assuming prices unchanged without commit
Thinking ROLLBACK needed to save
Confusing increase with decrease

Master "Transactions and Data Integrity" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Given the commands:

Step 1: Understand the UPDATE and COMMIT

Step 2: Effect on SELECT query

Final Answer:

Quick Check:

Want More Practice?