To write a trigger,you must specify the triggers object,the event that starts the trigger,and the code that executes when the trigger fires.

Question

Quizplus · Accepted Answer

This statement accurately describes the basic structure of a trigger. The trigger's object is the database object that the trigger is associated with, such as a table or view. The event that starts the trigger can be either a DML (Data Manipulation Language) action, such as an INSERT, UPDATE, or DELETE statement, or a DDL (Data Definition Language) action, such as a CREATE, ALTER, or DROP statement. The code that executes when the trigger fires can be any valid SQL statements, such as SELECT, INSERT, UPDATE, or DELETE statements, as well as some programming constructs, such as IF-THEN-ELSE statements or loops.

To Write a Trigger,you Must Specify the Triggers Object,the Event