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.
E)Depending on the specific logic,any of A,B,or C can be used.

Question

Quizplus · Accepted Answer

An INSTEAD OF trigger allows for the view to be updated using unique application logic. It is specifically designed for modifying data in a view. A BEFORE trigger only executes before an insert or update operation, and an AFTER trigger only executes after an insert or update operation, so they may not be the best choice for updating a view. The answer is not E because a choice between A or B depends on the specific logic needed for updating the view, and it is not specified in the question.

If the Values in an SQL View Are Not Changeable