Microsoft Exam Questions

Which of the following statements regarding SQL Server 2012 objects is TRUE?

Which of the following statements regarding SQL Server 2012 objects is TRUE?

A.
A user-defined data type can accept an input variable and return a table of results but cannot
be used within a view.

B.
A scalar function can accept an input variable and return a table of results but cannot be used
within a view.

C.
A table-valued function can accept an input variable and return a table of results but cannot be
used within a view.

D.
A table-valued type can accept an input variable and return a table of results but cannot be
used within a view.

Explanation: