Home » MCQs » Oracle MCQs » Oracle Trigger MCQs

Which of the following is the limitation of using BEFORE INSERT/UPDATE/DELETE trigger?

14. Which of the following is the limitation of using BEFORE INSERT/UPDATE/DELETE trigger?

1. A view cannot have a BEFORE trigger.
2. The OLD values cannot be updated.
3. The NEW values are the only ones that can be updated.
4. All of the above

Answer: D) All of the above

Explanation:

The following are the limitations of using BEFORE INSERT/UPDATE/DELETE trigger -

1. A view cannot have an BEFORE trigger.
2. The OLD values cannot be updated.
3. The NEW values are the only ones that can be updated.