Question

A developer wants to automatically write a record into an audit table every time a row is updated in the Orders table, without changing any of the application code that performs the updates. Which database object should be used to achieve this?

Accepted Answer

A trigger defined on the Orders table

Answer

A view that combines Orders and the audit table

Answer

An index on the Orders table

Answer

A stored procedure called by the application