Home » MCQs » Oracle MCQs » Oracle Trigger MCQs

What is the syntax of ENABLE Trigger?

22. What is the syntax of ENABLE Trigger?

1. ALTER TRIGGER trigger_name ENABLE;
2. ALTER TRIGGER trigger_name ALTER;
3. ENABLE TRIGGER trigger_name ENABLE;
4. ENABLE TRIGGER trigger_name ALTER;

Answer: A) ALTER TRIGGER trigger_name ENABLE;

Explanation:

Syntax of DISABLE trigger is ALTER TRIGGER trigger_name ENABLE.