• I know the test developer couldn't have made a mistake

    Hi Reginald,

    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/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/