The answer is B. I have taken the test twice, and seen
the question twice. Test King is correct
>-----Original Message-----
>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.
>.
>

Report this post to a moderator