Microsoft Exam Questions

You need to create a database object that meets the fol…

Note: This question is part of a series of questions that use the same answer choices. An answer choice may
be correct for more than one question in the series. Each question is independent of the other questions in this
series. Information and details provided in a question apply only to that question.
You are developing an application to track customer sales. You create tables to support the application. You
need to create a database object that meets the following data entry requirements:

What should you create?

A.
extended procedure

B.
CLR procedure

C.
user-defined procedure

D.
DML trigger

E.
DDL trigger

F.
scalar-valued function

G.
table-valued function

Explanation:
https://msdn.microsoft.com/en-us/library/ms345075.aspx