You are a database developer for a database named Accounts at oodgrove Bank. A developer is creating a multi-tier application for the bank. Bank employees will use the application to manage customer accounts. The developer needs to retrieve customer names from the accounts database to populate a drop-down list box in the application. A user of the application will use the list box to locate a customer account. The database contains more than 50,000 customer accounts. Therefore, the developer wants to retrieve only 25 rows as the user scrolls through the list box. The most current list of customers must be available to the application at all times. You need to recommend a strategy for the developer to use when implementing the drop-down list box. What should you recommend?

41.

You are a database developer for a database named Accounts at oodgrove Bank.
A developer is creating a multi-tier application for the bank.
Bank employees will use the application to manage customer accounts. The developer needs to retrieve customer names from the accounts database to populate a drop-down list box in the application.
A user of the application will use the list box to locate a customer account. The database contains more than 50,000 customer accounts.
Therefore, the developer wants to retrieve only 25 rows as the user scrolls through the list box.
The most current list of customers must be available to the application at all times.
You need to recommend a strategy for the developer to use when implementing the drop-down list box.

What should you recommend?

Create a stored procedure to retrieve all of the data that is loaded into the list box.

Use an API server-side cursor to retrieve the data that is loaded into list box.

Retrieve all of the data at once by using a SELECT statement, and then load the data into the list box.

Use a Transact-SQL server-side cursor to retrieve the data that is loaded into the list box.

View Description

No description found.