?
The statement used to create a trigger is . . . . . . . .
Answer & Solution
Correct Answer:
Option
A
The statement used to create a trigger in MySQL is CREATE TRIGGER.
This statement is followed by the trigger name, the trigger timing (BEFORE, AFTER), the event (INSERT, UPDATE, DELETE), and the trigger action (the SQL code to execute when the trigger is activated).
Option B, CREATE TRIGGERS, is incorrect because the correct syntax in MySQL is CREATE TRIGGER (singular form), not CREATE TRIGGERS (plural form).
Option C, PRODUCE TRIGGER, is incorrect because there is no such statement as PRODUCE TRIGGER in MySQL.
Option D, PRODUCE TRIGGERS, is incorrect because there is no such statement as PRODUCE TRIGGERS in MySQL.
This statement is followed by the trigger name, the trigger timing (BEFORE, AFTER), the event (INSERT, UPDATE, DELETE), and the trigger action (the SQL code to execute when the trigger is activated).
Option B, CREATE TRIGGERS, is incorrect because the correct syntax in MySQL is CREATE TRIGGER (singular form), not CREATE TRIGGERS (plural form).
Option C, PRODUCE TRIGGER, is incorrect because there is no such statement as PRODUCE TRIGGER in MySQL.
Option D, PRODUCE TRIGGERS, is incorrect because there is no such statement as PRODUCE TRIGGERS in MySQL.
Join the Discussion
Login to post a comment or share your explanation.
Login