Why do you use an INSTEAD OF trigger?
A.
To perform clean up actions when ending a user session.
B.
To insert data into a view that normally does not accept inserts.
C.
To insert into an audit table when data is updated in a sensitive column.
D.
To modify data in which the DML statement has been issued against an inherently nonupdateable view.
Explanation:
An INSTEAD OF trigger is used to perform a DML activity on the underlying tables of a view that
is inherently non-updatable.
Incorrect Answers:
A: This could be performed by a System Event Trigger (BEFORE LOGOFF) not by an INSTEAD
OF Trigger.
B: You can’t insert data into a view, however, you can insert data into the underlying table that the
view is based on.
C: This would not require an INSTEAD of Trigger, rather you would specify BEFORE UPDATE OF
ColumnName ON TableName.