← Quiz: Subqueries and Views: all 10 questions
Quiz: Subqueries and Views · Question 4 of 10
What does a (non-materialized) view store?
What does a (non-materialized) view store?
- A.A copy of the data
- B.Only the query; data is read from the base tables when used
- C.Indexes only
- D.Nothing — views are temporary
Answer & explanation
Correct answer: Only the query; data is read from the base tables when used
A view is a stored query. Materialized views store results.
Can you get the rest right without peeking?
Take the timed Quiz: Subqueries and Views quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →