You are creating a table named Orders.
You need to ensure that every time a new row is added to the Orders table, a table that is
used for auditing is updated.
What should you use?
More than one answer choice may achieve the goal. Select the BEST answer.
A.
A Data Definition Language (DDL) trigger
B.
A DEFAULT constraint
C.
A CHECK constraint
D.
A FOREIGN KEY constraint
E.
A data manipulation language (DML) trigger
Explanation:
http://www.techrepublic.com/blog/programming-and-development/comparing-sqlserverconstraints-and-dmltriggers/402
http://msdn.microsoft.com/en-us/library/ms178110.aspx