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