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;
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.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion