Intermediate
Database Management Systems
Q52 / 100
What is a materialized view?
Correct! Well done.
Incorrect.
The correct answer is B) A view whose query result is physically stored and refreshed periodically, trading storage for faster read performance
B
Correct Answer
A view whose query result is physically stored and refreshed periodically, trading storage for faster read performance
Explanation
Materialized views store query results on disk. Unlike regular views (recomputed each access), they are precomputed. Used in data warehouses for aggregation queries. Require refresh strategies (on demand, periodic, on-change).
Progress
52/100