Examveda
Examveda

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous