I know the test developer couldn't have made a mistake
Do I sense some sarcasm there? ;-)
Anyway, if you selected both #1 and #2, then you should have gotten the point. If you chose one of them at random, you shouldn't - since the question (now!
) specifically asks what can
be the output, and asks you to "select all that apply".
Read the preceeding discussion for more information about the original phrasing of the question and why this was changed.
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis