| simon hearn 2003-11-23, 10:25 pm |
| Hi, im working my way through some 070-229 (design) test
king questions and I've come across this one which doesn't
seem to make sense, i was wondering if someone could tell
me if i'm being dumb or if the question/answer is wrong:
------------------
You are a database developer for a database named accounts
at Woodgrove 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 retirieve
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 will you
recommend?
A. Create a stored procedure to retrieve all of the data
that is loaded into the list box.
B. Use an API server-side cursor to retrieve the data that
is loaded into the list box.
c. Retrieve all of the data at once by using a SELECT
statement, and then load the data into the list box.
D. Use a Transact-SQL server-side cursor to retrieve the
data that is loaded into the list box.
Answer: B (apparently)
Explanation: (apparently) Using an API server side cursor,
the result set is located at the client, not at the
server. This method is the most efficient way to retrieve
rows from the cursor.
----------------
Cursors aren't my strong point but surely "Use a Client
Cursor" should be one of the options as according to my
book both types of cursors in the options are stored on
the server. I may be wrong though.
Any help would be most appreciated.
Simon.
|