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