A view is created as CREATE VIEW v AS SELECT id, name FROM users;. Later, the users table drops the name column. What happens when you query the view?

medium📝 Debug Q7 of 15

PostgreSQL - Views and Materialized Views

A view is created as CREATE VIEW v AS SELECT id, name FROM users;. Later, the users table drops the name column. What happens when you query the view?

AThe view continues to return old data including the dropped column

BThe view automatically updates to exclude the dropped column

CThe view returns NULL for the dropped column

DQuerying the view causes an error because the column no longer exists

Step-by-Step Solution

Solution:

Step 1: Understand view dependency on base tables
Views depend on the columns existing in the underlying tables at query time.
Step 2: Effect of dropping a column used by the view
If a column used by the view is dropped, querying the view causes an error due to missing column.
Final Answer:
Querying the view causes an error because the column no longer exists -> Option D
Quick Check:
Dropped column breaks view query = A [OK]

Quick Trick: Dropping columns used in views breaks those views [OK]

Common Mistakes:

Assuming views auto-update columns
Expecting NULL instead of error
Thinking views cache old data

Master "Views and Materialized Views" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

A view is created as CREATE VIEW v AS SELECT id, name FROM users;. Later, the users table drops the name column. What happens when you query the view?

Step 1: Understand view dependency on base tables

Step 2: Effect of dropping a column used by the view

Final Answer:

Quick Check:

Want More Practice?