Home » MCQs » Oracle MCQs » Oracle Trigger MCQs

What is the syntax of DISABLE Trigger?

20. What is the syntax of DISABLE Trigger?

1. ALTER TRIGGER trigger_name DISBALE;
2. ALTER TRIGGER trigger_name ALTER;
3. DISABLE TRIGGER trigger_name DISABLE;
4. DISBALE TRIGGER trigger_name ALTER;

Answer: A) ALTER TRIGGER trigger_name DISBALE;

Explanation:

Syntax of DISABLE trigger is ALTER TRIGGER trigger_name DISABLE.