How do you temporarily disable a trigger called my_trigger?
A)DROP TRIGGER my_trigger
B)DISABLE TRIGGER my_trigger
C)ALTER TRIGGER my_trigger DISABLE
D)ALTER my_trigger DISABLE

Question

Quizplus · Accepted Answer

The correct syntax to temporarily disable a trigger is ALTER TRIGGER [trigger_name] DISABLE. Therefore, choice C is the correct syntax to use to disable a trigger called my_trigger.

Note: Option A (DROP TRIGGER) would permanently remove the trigger from the database, option B (DISABLE TRIGGER) does not exist in SQL, and option D (ALTER my_trigger DISABLE) is not a valid syntax for disabling a trigger.

How Do You Temporarily Disable a Trigger Called My_trigger