Multiple choice technology databases

Q10

  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 are specifically designed for complex views that join multiple tables, where direct DML is not allowed. The trigger intercepts the INSERT and translates it to operations on the underlying base tables. Option B correctly identifies this use case. Options A and C don't explain why INSTEAD OF is needed specifically.

Keep practicing — related questions