?
What is ghi in the following MySQL statement?
What is ghi in the following MySQL statement?
CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;
CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;
Answer & Solution
Correct Answer:
Option
C
This question is about understanding the parts of a MySQL trigger statement.
Let's break down the given statement:
Here's what each part means:
* CREATE TRIGGER abc: This part creates a trigger named "abc". * (...) (...): These represent the trigger conditions (when the trigger should be activated) and the trigger actions (what should happen when the trigger is activated). * ON def: This specifies the table ("def") on which the trigger is applied. * FOR EACH ROW: This indicates that the trigger should be executed for each row affected by the event that triggered it. * ghi: This is the part we're trying to identify. It represents the trigger statement that will be executed when the trigger is activated.
Therefore, the correct answer is Option C: trigger statement.
Let's break down the given statement:
CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;
Here's what each part means:
* CREATE TRIGGER abc: This part creates a trigger named "abc". * (...) (...): These represent the trigger conditions (when the trigger should be activated) and the trigger actions (what should happen when the trigger is activated). * ON def: This specifies the table ("def") on which the trigger is applied. * FOR EACH ROW: This indicates that the trigger should be executed for each row affected by the event that triggered it. * ghi: This is the part we're trying to identify. It represents the trigger statement that will be executed when the trigger is activated.
Therefore, the correct answer is Option C: trigger statement.
Join the Discussion
Login to post a comment or share your explanation.
Login