Exit 70-459 Transition Your MCITP: Database Administrator 2008 or MCITP: Database Developer 2008 to MCSE: Data Platform
Question 3 of 5
0% complete
Q3 Single choice

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