Multiple choice

What is/are the advantage(s) of using stored procedure in SQL?

  1. Stored procedure reduces network traffic.

  2. Stored procedures provide security to the database.

  3. Stored procedure provides maintainability to the application.

  4. Stored procedures are limited to T/SQL only and produce somewhat complexity.

  5. (1), (2) and (3) all are true.
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

Yes, all of these are the advantages of stored procedure.

Keep practicing — related questions