Microsoft
70-459 · Question #25
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…
The correct answer is E. a data manipulation language (DML) trigger. constraints-and-dmltriggers/402
Implement programming objects
Question
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.
Options
- Aa DEFAULT constraint
- Ba Data Definition Language (DDL) trigger
- Ca CHECK constraint
- Da FOREIGN KEY constraint
- Ea data manipulation language (DML) trigger
How the community answered
(41 responses)- A2% (1)
- B5% (2)
- C7% (3)
- D15% (6)
- E71% (29)
Explanation
constraints-and-dmltriggers/402
Topics
#DML trigger#auditing#audit table#INSERT
Community Discussion
No community discussion yet for this question.