🎙 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 1 of 10

Does a normal (non-materialized) view store data?

Does a normal (non-materialized) view store data?

  1. A.Yes, a copy of all base table rows
  2. B.No, it stores only the query, which runs each time the view is read
  3. C.Yes, but only the first 100 rows
  4. D.Only if it has an index
Answer & explanation

Correct answer: No, it stores only the query, which runs each time the view is read

A view is a saved SELECT; a materialized view is the one that stores results.

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 →