Q560
What is ghi in the following MySQL statement? CREATE TRIGGER abc (...) (...) ON def FOR EACH ROW ghi;
A.
trigger name
B.
table name
C.
trigger statement
AnswerD.
update statement
Answer: Option C
Solution
Answer: Option C
Solution:
This question is about understanding the parts of a MySQL 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.