You have a third-party application that inserts data directly into a table.
You add two new columns to the table. These columns cannot accept NULL values and cannot use default constraints.
You need to ensure that the new columns do not break the third-party application.
What should you do?
A.
Create a DDL trigger.
B.
Create a stored procedure.
C.
Create an AFTER INSERT trigger.
D.
Create an INSTEAD OF INSERT trigger.