Note: this question is part of a series of questions that use the same or similar 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 the series. Information and details provided in a question apply only to that question.

You are developing and application to track customer sales.

You need to return the sum of orders that have been finalized, g

iven a specified order identifier. This value will be used in other Transact-SQL statements.

You need to create a database object.

What should you create?

A. extended procedure

B. CLR procedure

C. user-defined procedure

D. DML trigger

E. scalar-valued

function

F. table-valued function

Explanation:

User-defined scalar functions return a single data value of the type defined in the RETURNS clause.

References: https://technet.microsoft.com/en-us/library/ms177499(v=sql.105).aspx