QUESTION: 9
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.
A. a FOREIGN KEY constraint
B. a data manipulation language (DML) trigger
C. a DEFAULT constraint
D. a CHECK constraint
E. a Data Definition Language (DDL) trigger
Answer: D
Explanation/Reference:
Verified
CHECK constraints enforce domain integrity by limiting the values that are accepted by one or more columns.
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.
A. a FOREIGN KEY constraint
B. a data manipulation language (DML) trigger
C. a DEFAULT constraint
D. a CHECK constraint
E. a Data Definition Language (DDL) trigger
Answer: D
Explanation/Reference:
Verified
CHECK constraints enforce domain integrity by limiting the values that are accepted by one or more columns.
Microsoft 70-646 Dumps Pdf & Download Free Dumps
