ITPEC FE Morning April 2020 Question 27
ITPEC FE Morning April 2020 — Question 27 of 80
Database Trigger — a function that fires automatically on INSERT, UPDATE, or DELETE.
A trigger is a database object that automatically executes a predefined action when a specific data modification event occurs (INSERT, UPDATE, DELETE).
Why not others:
- (a) Cursor — iterates through query results row by row; must be explicitly opened and fetched
- (b) Stored procedure — a reusable SQL routine, but must be called manually
- (d) Update query — a standard SQL statement, not an automatic mechanism
Key rule: "Automatically executed on data change" = Trigger.
AI-generated — may contain errors
The original exam layout is preserved in the image so diagrams, formulas, tables, and code remain accurate.
This question comes from an official ITPEC past paper. ITPEC Practice is an independent study tool and is not affiliated with ITPEC. See the official FE past-paper collection or Report an issue.