engineering computer science MCQ #750

Which of the following is a benefit of using stored procedures?

engineering computer science MCQ #750

  1. Question 1

    Q1. Which of the following is a benefit of using stored procedures?

    • A) Improved security
    • B) Improved performance
    • C) Simplified maintenance
    • D) All of the above

    Answer: All of the above

    Explanation: Stored procedures can improve security by limiting direct access to tables, improve performance by reducing the amount of SQL code sent over the network, and simplify maintenance by encapsulating complex logic.