The statement used to create a trigger is . . . . . . . .
A. CREATE TRIGGER
B. CREATE TRIGGERS
C. PRODUCE TRIGGER
D. PRODUCE TRIGGERS
Answer: Option A
Solution(By Examveda Team)
The statement used to create a trigger in MySQL is CREATE TRIGGER.This statement is followed by the trigger name, the trigger timing (BEFORE, AFTER), the event (INSERT, UPDATE, DELETE), and the trigger action (the SQL code to execute when the trigger is activated).
Option B, CREATE TRIGGERS, is incorrect because the correct syntax in MySQL is CREATE TRIGGER (singular form), not CREATE TRIGGERS (plural form).
Option C, PRODUCE TRIGGER, is incorrect because there is no such statement as PRODUCE TRIGGER in MySQL.
Option D, PRODUCE TRIGGERS, is incorrect because there is no such statement as PRODUCE TRIGGERS in MySQL.
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