Skills101
← All practice quizzes

Quiz: Views, Triggers and Procedures

5 questions · new set on every retakeNo time limitPass: 60%+10 XP on first pass

When to keep logic in the database. Views that hide columns and update safely, triggers that keep an audit log and stock in sync, and stored procedures and functions — with what each is good and bad at.

Log in to take the quiz

Free account · see your score, answers and explanations, earn XP

  1. Question 1

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

  2. Question 2

    How can you let a team see product prices but not costs?

  3. Question 3

    A materialized view shows yesterday's numbers. Why?

  4. Question 4

    Inside an UPDATE trigger, what do OLD and NEW refer to?

  5. Question 5

    Which trigger timing can stop an invalid row from being inserted?

🎯 Today’s placement challenge — 10 questions, no login. Can you score 10/10?Take today’s challenge →