Multiple choice technology databases

A database TRIGGER is made up of ... Choose all that apply

  1. TRIGGER SPECIFICATION

  2. TRIGGER EVENT

  3. TRIGGER TYPE

  4. TRIGGER BODY

  5. TRIGGER RESTRICTION

  6. TRIGGER ACTION
Reveal answer Fill a bubble to check yourself
B,C,E,F Correct answer
Explanation

A database trigger consists of TRIGGER EVENT (INSERT/UPDATE/DELETE), TRIGGER TYPE (BEFORE/AFTER/INSTEAD OF, statement/row level), TRIGGER RESTRICTION (WHEN condition), and TRIGGER ACTION (the PL/SQL block executed). TRIGGER SPECIFICATION and TRIGGER BODY are not standard terminology components.

Keep practicing — related questions