[Solved] Which condition must be true for a SQL view to be updatable? — Ans: The view must be based on a single table without aggregate functions | SQL

SQL - Views

Which condition must be true for a SQL view to be updatable?

AThe view must include GROUP BY clauses

BThe view must be based on a single table without aggregate functions

CThe view must use UNION to combine multiple tables

DThe view must contain DISTINCT keyword

Step-by-Step Solution

Solution:

Step 1: Understand updatable view basics
An updatable view allows changes to be made through it, which requires it to be based on a single table without aggregates or grouping.
Step 2: Analyze each option
Options A, C, and D include grouping, combining tables, or distinct filtering, which prevent updates through the view.
Final Answer:
The view must be based on a single table without aggregate functions -> Option B
Quick Check:
Updatable view condition = single table, no aggregates [OK]

Quick Trick: Updatable views come from one table without grouping or aggregates [OK]

Common Mistakes:

MISTAKES

Master "Views" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Which condition must be true for a SQL view to be updatable?