3 questions

1) Which one of the following is NOT a SQL Server page type?
Index, Table, Data, Text /Image, Global Allocation MAP,
2) Which one of the following is a characteristic of a Keyset-Driven Cursor?
Order is Dynamic. , Values are Dynamic., Membership is Dynamic., Keyset is built in memory, Usage of the tempdb database is reduced.
3) Which one of the following situations benefits LEAST from parallel execution?
1) Extensive aggregation in a large corporate billing application
2) Large groups of small transactions in an OLTP application
3) Multiple joins in a decision support system
4)Large sorts in a data warehouse reporting application
5)Small groups of large queries in an OLAP application
What do you think the answers are?
David G.
|||1) Which one of the following is NOT a SQL Server page type?
Global Allocation MAP
2) Which one of the following is a characteristic of a Keyset-Driven Cursor?
Values are Dynamic
3) Which one of the following situations benefits LEAST from parallel
execution?
Large groups of small transactions in an OLTP application
-- Original Message --
From: "David Gugick" <davidg-nospam@.imceda.com>
Newsgroups: microsoft.public.sqlserver.clients
Sent: Tuesday, March 01, 2005 6:11 PM
Subject: Re: 3 questions

> What do you think the answers are?
> --
> David G.
>
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:OatMxPrHFHA.3500@.TK2MSFTNGP14.phx.gbl...
> What do you think the answers are?
> --
> David G.
>
|||John wrote:
> 1) Which one of the following is NOT a SQL Server page type?
> Global Allocation MAP
I think the answer to this one is a table (see Pages and Extents in BOL)

> 2) Which one of the following is a characteristic of a Keyset-Driven
> Cursor?
> Values are Dynamic
I agree with you on this one.

> 3) Which one of the following situations benefits LEAST from parallel
> execution?
> Large groups of small transactions in an OLTP application
I agree with you on this one as well.
David Gugick
Imceda Software
www.imceda.com
sql