Home » MCQs » Oracle MCQs » Oracle Trigger MCQs

Which of the following is an optional parameter in Oracle BEFORE INSERT/UPDATE/DELETE trigger statement?

8. Which of the following is an optional parameter in Oracle BEFORE INSERT/UPDATE/DELETE trigger statement?

1. Trigger_name
2. Table_name
3. OR REPLACE
4. None

Answer: C) OR REPLACE

Explanation:

OR REPLACE is an optional parameter in Oracle BEFORE INSERT/UPDATE/DELETE trigger statement.