Microsoft
70-459 · Question #4
70-459 Question #4: Real Exam Question with Answer & Explanation
The correct answer is E. a CHECK constraint. constraints-and-dmltriggers/402
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
Explanation
constraints-and-dmltriggers/402
Community Discussion
No community discussion yet for this question.