🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.Materialized views cannot show current data at all
  2. B.It stores its result and only changes when it is refreshed
  3. C.The base table was dropped
  4. 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 →