One reason to create a stored procedure is to:
A.
Improve performance.
B.
Minimize storage space.
C.
Bypass case sensitivity requirements.
D.
Give the user control of the query logic.
Get 50% Discount on All Your Purchases
at PrepAway.com - Latest Exam Questions
This is ONE TIME OFFER
50%
A & D
1
0
The benefits of using stored procedures in SQL Server rather than application code stored locally on client computers include:
They allow modular programming.
They allow faster execution.
They can reduce network traffic.
They can be used as a security mechanism.
So: A.
5
0