Vidyalelo
MySQL · Q560

MySQL

Programming · MySQL · question 560

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
Answer
D.
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.