Which of the following are benefits of using table-valued parameters?

You work as a senior developer at ABC.com. The ABC.com network consists of a single domain
named ABC.com.
You are running a training exercise for junior developers. You are currently discussing the benefits

of using table-valued parameters.
Which of the following are benefits of using table-valued parameters?

A.
It acquires locks for the initial population of data from a client.

B.
It prevents you from including complex business logic in a single routine.

C.
It reduces round trips to the server.

D.
It prevents the client form specifying sort order and unique keys.

E.
It can have a table structure of different cardinality.

Explanation: