Bird
0
0

Which statement about views is TRUE?

hard📝 Conceptual Q10 of 15
SQL - Views
Which statement about views is TRUE?
AViews cannot include WHERE clauses
BViews store data physically in the database
CViews always improve query performance
DViews can be updated only if they are based on a single table without aggregates
Step-by-Step Solution
Solution:

  1. Step 1: Analyze each statement about views

    Views store data physically in the database is false because views are virtual and do not store data physically. Views can be updated only if they are based on a single table without aggregates is true; updatable views must be simple, single-table, no aggregates. Views always improve query performance is false; views may not improve performance. Views cannot include WHERE clauses is false; views can include WHERE clauses.

  2. Step 2: Confirm the true statement

    Only Views can be updated only if they are based on a single table without aggregates correctly describes a true fact about views.

  3. Final Answer:

    Views can be updated only if they are based on a single table without aggregates -> Option D

  4. Quick Check:

    Updatable views = single table, no aggregates [OK]
Quick Trick: Only simple views without aggregates are updatable [OK]
Common Mistakes:
MISTAKES
  • Thinking views store data
  • Assuming all views improve performance
  • Believing views cannot filter data

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Aggregate Functions - SUM function - Quiz 6medium GROUP BY and HAVING - How GROUP BY changes query execution - Quiz 10hard GROUP BY and HAVING - GROUP BY with NULL values behavior - Quiz 7medium INNER JOIN - How the join engine matches rows - Quiz 14medium INNER JOIN - INNER JOIN with multiple conditions - Quiz 14medium LEFT and RIGHT JOIN - Why outer joins are needed - Quiz 10easy LEFT and RIGHT JOIN - Multiple LEFT JOINs in one query - Quiz 1easy Table Constraints - Foreign key ON UPDATE behavior - Quiz 4medium Table Constraints - FOREIGN KEY constraint - Quiz 7medium Table Relationships - Many-to-many with junction tables - Quiz 3easy