Which of the following actions should you take?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com makes use of SQL Server 2012 in their environment.
Subsequent to creating a database, you are preparing to generate two stored procedures that will
read data from the database. The stored procedures will be named ABCSPA and ABCSPB.
ABCSPA should allow for a table to be returned and ABCSPB should be configured to yield a
scalar value.
You want to make sure that the prerequisites are suitably met.
Which of the following actions should you take? (Choose all that apply.)

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com. ABC.com makes use of SQL Server 2012 in their environment.
Subsequent to creating a database, you are preparing to generate two stored procedures that will
read data from the database. The stored procedures will be named ABCSPA and ABCSPB.
ABCSPA should allow for a table to be returned and ABCSPB should be configured to yield a
scalar value.
You want to make sure that the prerequisites are suitably met.
Which of the following actions should you take? (Choose all that apply.)

A.
You should consider configuring the use of a SELECT statement for ABCSPA.

B.
You should consider configuring the use of a SELECT statement for ABCSPB.

C.
You should consider configuring the use of an output parameter for ABCSPA.

D.
You should consider configuring the use of an output parameter for ABCSPB.

Explanation:



Leave a Reply 1

Your email address will not be published. Required fields are marked *