Microsoft
70-459 · Question #4
You are creating a table named Orders. You need to ensure that every time a new row is added to the Orders table, a user-defined function is called to validate the row before the row is added to the…
The correct answer is E. a CHECK constraint. 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 user-defined function is called to validate the row before the row is added to the table. What should you use? More than one answer choice may achieve the goal. Select the BEST answer.
Options
- Aa Data Definition Language (DDL) trigger
- Ba data manipulation language (DML) trigger
- Ca DEFAULT constraint
- Da FOREIGN KEY constraint
- Ea CHECK constraint
How the community answered
(33 responses)- A6% (2)
- B3% (1)
- C12% (4)
- D3% (1)
- E76% (25)
Explanation
constraints-and-dmltriggers/402
Topics
#CHECK constraint#DML trigger#row validation#INSERT
Community Discussion
No community discussion yet for this question.