PrepAway - Latest Free Exam Questions & Answers

What are options that suitably describe the advantages of making use of stored procedures in SQL Server?

You are employed as a developer at ABC.com. ABC.com makes use of SQL Server databases in
their environment.
You are currently running a training exercise for potential developers. You are in the process of
discussing stored procedures.
What are options that suitably describe the advantages of making use of stored procedures in
SQL Server? (Choose all that apply.)

PrepAway - Latest Free Exam Questions & Answers

A.
Stored procedures can improve the security of your application.

B.
Stored procedures prevent modular programming.

C.
Stored procedures are created once, and can be called any number of times in your program.

D.
Stored procedures are stored locally on client computers.

2 Comments on “What are options that suitably describe the advantages of making use of stored procedures in SQL Server?


Leave a Reply