Database Fundamentals — Question 52

One reason to create a stored procedure is to:

Answer options

• A. Improve performance.
• B. Minimize storage space.
• C. Bypass case sensitivity requirements.
• D. Give the user control of the query logic.

Correct answer: A

Explanation

The correct answer is A, as stored procedures are designed to optimize performance by allowing for precompiled execution plans and reduced network traffic. Options B and C are incorrect because stored procedures do not typically reduce storage space or bypass case sensitivity. Option D, while relating to control, does not specifically address the primary purpose of performance improvement.