You create Web-based client applications. You are writing a code segment that queries the following data from a database:
Customer information
Order information
The code segment does not query the database directly. The code segment calls a stored procedure from the database to perform queries. The stored procedure returns information about a customer based on
the customer ID parameter that the code segment provides. The stored procedure accepts the customer ID as an input parameter and includes only one query. The stored procedure returns the result set to the code segment by using output parameters. You need to evaluate whether the stored procedure is designed for best performance and uses the minimum amount of code. What should you conclude?
A.
A client-side cursor is required to capture a result set. The current design increases unnecessary coding and complexity.
B.
A server-side cursor is required to return a result set. The current design increases unnecessary coding and complexity.
C.
The use of output parameters to return a result set is not necessary.
D.
Two stored procedures are required to return the necessary information.