Well, I cut and pasted the queries directly from the web page and it worked exactly as I expected.  Query 1 returned 1,2 and Query 2 returned 3...and I got...

The question was:

"Can you use an ORDER BY clause in this view definition?"

and the answer is NO!

if this were the view definition:

create view NorthViewasselect TOP 10 accountID,...

BS!

It is obvious from the wording of this question, the intent was to confuse, not teach.  The fact that 49.7% of the respondents answered 2GB should be proof of that.

And...

Why do you guys even bother with discussions over this.

1) author can't type

2) author gives WRONG answer

isn't worth my time...

Just be thankful this author's finger was on the keyboard and not "THE BUTTON"!

I got it WRONG for the same reason

What does it matter in the end if we don't send the French their email?

Please explain why this answer is correct when I get the following error when I run the code as provided:

Server: Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect...

Actually, MaxActiveReqForOneUserin parameter does not exist. So there is no correct answer as listed...

refer to the following article which explicitly states (in underlines) that "a recursive query is made up of 2 queries joined by a UNION ALL".

end of story!

Here! Here!  I won't whine, but I'll certainly gripe!  I'm continually amazed that so many alleged analytical people can come up with so many ambiguous questions.

and I GUESSED wrong

Looks like we have conflicting information:

http://support.microsoft.com/?kbid=897284

Trick question.  BOL says it captures "T-SQL"...

Your multiple choice question provides an answer which which includes the key word "T-SQL" and the correct answer which does not...implying that it is...

Another wonderfully crappy question...but if you stare at the screen and squint really hard, you can recover any database using that script!

If you stare at the screen and squint really hard, you can use the mirror for reporting.

A result set can take many forms...including a single value, in which case, an Object data type would be overkill.  The question does not provide enough information to give a...