A trigger is

1. AA statement that enables the DBMS to start
2. BA statement executed by the user when debugging an application program
3. CA condition the system tests for the validity of the database user
4. DA statement that is executed automatically by the system as a side effect of a modification to the database

Pick an option to check yourself, or open the answer below.

Show answer & explanation

Correct answer: D. A statement that is executed automatically by the system as a side effect of a modification to the database

Explanation

A trigger is executed automatically by the DBMS when a specified modification (insert, update, delete) happens.