If the values in an SQL view are not changeable through the view itself,you may still be able to update the view by using unique application logic.In this case,the specific logic is placed in ________.
A)a BEFORE trigger
B)an INSTEAD OF trigger
C)an AFTER trigger
D)Depending on the specific logic,either A or B can be used.

Question

Quizplus · Accepted Answer

An INSTEAD OF trigger can be used to allow updates to a view by providing custom logic to handle data modifications. Unlike a BEFORE trigger, an INSTEAD OF trigger can modify or manipulate the data before it is inserted, updated or deleted, making it the suitable choice in this case.

If the Values in an SQL View Are Not Changeable