Which type of trigger is commonly used to update views?
A)BEFORE triggers
B)AFTER triggers
C)SELECT triggers
D)INSTEAD OF triggers

Question

Quizplus · Accepted Answer

INSTEAD OF triggers are commonly used to update views as they allow the trigger to execute instead of the original operation on the view. This allows for greater control over the logic and can be used to update columns in more than one underlying table. BEFORE triggers execute before the original operation and can be used to modify the data being inserted or updated. AFTER triggers execute after the original operation and can be used to perform additional actions, such as auditing or logging. SELECT triggers do not exist in SQL, so they are not a valid option.

Which Type of Trigger Is Commonly Used to Update Views