Examveda

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

D. update statement

Answer: Option C

Solution (By Examveda Team)

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous