Stored procedures have the advantage of ________.
A)greater security
B)decreased network traffic
C)SQL optimized by the DBMS compiler
D)code sharing
E)All of the above

Question

Quizplus · Accepted Answer

Stored procedures provide greater security by allowing access only through the procedure and not exposing the underlying tables or views. They also reduce network traffic by executing on the server rather than transmitting multiple SQL statements to the server. Stored procedures can be optimized by the DBMS compiler for better performance. They also allow for code sharing among applications, improving maintainability and reducing duplication of effort. Therefore, all of the above options are advantages of stored procedures.

Stored Procedures Have the Advantage of ________