[Solved] Which statement about views in PostgreSQL is TRUE? — Ans: Views do not store data physically and always reflect current underlying table... | PostgreSQL

PostgreSQL - Views and Materialized Views

Which statement about views in PostgreSQL is TRUE?

AViews do not store data physically and always reflect current underlying table data.

BViews store data physically and need manual updates to reflect changes.

CViews can be indexed directly to improve performance.

DViews cannot be used in JOIN operations.

Step-by-Step Solution

Solution:

Step 1: Recall view behavior
Views are virtual tables that do not store data physically but show current data from underlying tables.
Step 2: Evaluate each option
Views do not store data physically and always reflect current underlying table data. correctly states this. Options A, B, and C are false because views can be used in JOINs, do not store data physically, and cannot be indexed directly.
Final Answer:
Views do not store data physically and always reflect current underlying table data. -> Option A
Quick Check:
Views are virtual and reflect live data [OK]

Quick Trick: Views show live data, no physical storage [OK]

Common Mistakes:

Master "Views and Materialized Views" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which statement about views in PostgreSQL is TRUE?