What should you use?

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 DEFAULT constraint
B. a Data Definition Language (DDL) trigger
C. a CHECK constraint
D. a FOREIGN KEY constraint
E. a data manipulation language (DML) trigger

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.