Implementing Triggers Quiz

5 questions • Pass: 70% • +25 pts

Quiz covering Server-Side Programming

Implementing Triggers Quiz

5 questions | Pass: 70% | Earn 25 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 1

    Which of the following best describes the primary purpose of a database trigger?

  2. 2

    In a SQL trigger, what is the purpose of the 'OLD' and 'NEW' pseudo-records?

  3. 3

    What is a common risk associated with using 'AFTER' triggers for data validation?

  4. 4

    When designing a trigger, what is the 'mutating table' error?

  5. 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?