102k views
0 votes
SQL triggers are created using ________.

1) the SQL CREATE TRIGGER statement
2) the SQL ADD TRIGGER statement
3) the SQL TRIGGER statement
4) the SQL ADD CONSTRAINT TRIGGER statement
5) the SQL CONSTRAINT TRIGGER statement

User Steward
by
8.5k points

2 Answers

1 vote

Answer: 1 - CREATE TRIGGER trigger_name

ON table_name

Step-by-step explanation:

Using the create statements & are widely used to perform an action automatically in case of Insert,Update or delete

User Caty
by
7.8k points
3 votes

Final answer:

SQL triggers are created using the SQL CREATE TRIGGER statement and are a set of SQL commands executed automatically in response to specific events on a table.

Step-by-step explanation:

SQL triggers are created using the SQL CREATE TRIGGER statement. When a trigger is made, it is set to execute a batch of SQL code automatically in response to certain events on a table such as INSERT, UPDATE, or DELETE actions. To define a trigger, one would provide the name of the trigger, the triggering event, and the table on which the trigger should operate, along with the actual SQL commands that should be executed when the event occurs.

User CW Holeman II
by
7.8k points