You need to ensure that every time a new row is added t…

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.

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 data manipulation language (DML) trigger

B.
A DEFAULT constraint

C.
A Data Definition Language (DDL) trigger

D.
A CHECK constraint

E.
A FOREIGN KEY constraint

Explanation:
http://www.techrepublic.com/blog/programming-and-development/comparing-sql- serverconstraints-anddmltriggers/402
http://msdn.microsoft.com/en-us/library/ms178110.aspx



Leave a Reply 0

Your email address will not be published. Required fields are marked *