Question: You would like to have a record added to a TableB every time a record is modified in TableA. What technique should you look at implementing?

1. You should create a DML trigger on the server.
2. You should create a DDL trigger on the database.
3. You should create a DML trigger on TableA.
4. You should create a DML trigger on TableB.

Answer: The correct answer of the above question is Option C:You should create a DML trigger on TableA.