← Quiz: Views, Triggers and Procedures: all 10 questions
Quiz: Views, Triggers and Procedures · Question 3 of 10
A materialized view shows yesterday's numbers. Why?
A materialized view shows yesterday's numbers. Why?
- A.Materialized views cannot show current data at all
- B.It stores its result and only changes when it is refreshed
- C.The base table was dropped
- D.It has a trigger that delays updates
Answer & explanation
Correct answer: It stores its result and only changes when it is refreshed
Refresh it (for example nightly) to bring it up to date.
Can you get the rest right without peeking?
Take the timed Quiz: Views, Triggers and Procedures quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →