Which of the following is TRUE with regards to user-defined functions?

You work as a database developer at ABC.com. The ABC.com network consists of a single
domain named ABC.com.
ABC.com has an existing SQL Server 2012 database that has multiple tables. You have received

instructions to create a user-defined function.
Which of the following is TRUE with regards to user-defined functions? (Choose all that apply.)

A.
They can be used to perform actions that modify the database state.

B.
They cannot return multiple result sets.

C.
They can make use of dynamic SQL or temp tables.

D.
They cannot call a stored procedure.

Explanation: