Implementing Triggers Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Server-Side Programming

What you'll be asked

  1. Which of the following best describes the primary purpose of a database trigger?
  2. In a SQL trigger, what is the purpose of the 'OLD' and 'NEW' pseudo-records?
  3. What is a common risk associated with using 'AFTER' triggers for data validation?
  4. When designing a trigger, what is the 'mutating table' error?
  5. Consider a scenario where you need to maintain an audit log of all changes to a 'Salaries' table. Which trigger type is most appropriate?

Answers and explanations come after you submit.