🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← All topics

Quiz: Views, Triggers and Procedures: questions with answers

10 questions, each with the answer and a short explanation.

Take the timed quiz + get a certificate →
  1. Q1. Does a normal (non-materialized) view store data?
  2. Q2. How can you let a team see product prices but not costs?
  3. Q3. A materialized view shows yesterday's numbers. Why?
  4. Q4. Inside an UPDATE trigger, what do OLD and NEW refer to?
  5. Q5. Which trigger timing can stop an invalid row from being inserted?
  6. Q6. An UPDATE statement changes 500 rows. How many times does a FOR EACH ROW trigger fire?
  7. Q7. What is the key difference between a stored function and a stored procedure?
  8. Q8. Which view is usually updatable?
  9. Q9. Stock must never go below zero. What is the simplest safe rule?
  10. Q10. What is a common argument AGAINST putting a lot of business logic in triggers?