Solution:Step 1: Analyze the view definitionThe view uses SUM(sales_amount) and GROUP BY product_id.Step 2: Understand updatability rulesViews with aggregate functions and GROUP BY are not updatable because the underlying rows cannot be uniquely identified for updates.Final Answer:Because it uses an

[Solved] Consider the view:CREATE VIEW v_revenue AS SELECT product_id, SUM(sales_amount) AS total_sales FROM sales GROUP BY product_id;Why is this view not updatable? | SQL

SQL - Views

Consider the view:

CREATE VIEW v_revenue AS SELECT product_id, SUM(sales_amount) AS total_sales FROM sales GROUP BY product_id;

Why is this view not updatable?

ABecause it includes a WHERE clause

BBecause it selects from multiple tables

CBecause it uses an aggregate function and GROUP BY clause

DBecause it uses a subquery in the SELECT list

Step-by-Step Solution

Solution:

Step 1: Analyze the view definition
The view uses SUM(sales_amount) and GROUP BY product_id.
Step 2: Understand updatability rules
Views with aggregate functions and GROUP BY are not updatable because the underlying rows cannot be uniquely identified for updates.
Final Answer:
Because it uses an aggregate function and GROUP BY clause -> Option C
Quick Check:
Aggregates and GROUP BY block updates [OK]

Quick Trick: Aggregates and GROUP BY make views non-updatable [OK]

Common Mistakes:

MISTAKES

Assuming WHERE clause blocks updates
Confusing multiple tables with aggregates
Thinking subqueries always block updates

Master "Views" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Consider the view:

Step 1: Analyze the view definition

Step 2: Understand updatability rules

Final Answer:

Quick Check:

Want More Practice?