You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com makes use of SQL Server 2012 in their environment.
You have created a new table in an existing database. You want to make sure that a table, which
is used for auditing, is updated whenever a row is added to the table.
Which of the following actions should you take?
A.
You should consider making use of a UNIQUE constraint.
B.
You should consider making use of a PRIMARY KEY constraint.
C.
You should consider making use of an Index.
D.
You should consider making use of a DML trigger.
Explanation:
http://technet.microsoft.com/en-us/library/ms191524(v=sql.105).aspx