Multiple choice technology platforms and products

Why we are using instead of trigger in Oracle Forms?

  1. To insert in a view.

  2. To insert in a view which is created with more than one table.

  3. To insert into read only view.

  4. None.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

INSTEAD OF triggers in Oracle are specifically used to perform DML operations on views that involve multiple base tables, which normally wouldn't be directly updateable. Option A is incomplete. Option C is incorrect because read-only views cannot be modified even with triggers. Option D is incorrect - INSTEAD OF triggers have a specific purpose.

Keep practicing — related questions