Answer-first summary for fast verification
Answer: The view results change often.
The question asks when a standard view is preferable to a materialized view. Standard views are virtual and execute the underlying query each time they are accessed, making them suitable when the data changes frequently, as they always return current data. Materialized views store precomputed results and are refreshed periodically, making them inefficient for frequently changing data due to staleness and refresh overhead. Option D ('The view results change often') is correct because standard views ensure real-time data without refresh delays. The community discussion supports D with 67% consensus and upvoted comments confirming it. Options A, B, and C describe scenarios where the underlying query is slow, resource-intensive, or runs on large datasets; these are actually cases where materialized views are preferable, as they optimize performance by caching results, making them less suitable for standard views.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
When would creating and using a standard view be preferable to using a materialized view?
A
The underlying query of the view takes a lot of time to run.
B
The underlying query of the view is resource-intensive.
C
The underlying query of the view is run on large data sets.
D
The view results change often.