• Hugo Kornelis (5/10/2012)


    I have to disagree with you, Tom.

    Sure, the wording could have been better. I'll immediately agree to that.

    But the question clearly asks: "When does a "SELECT *" statement not return a column as an individual column in the result set (...)" (emphasis mine). The answers only mention that specific columns "... will not be returned" without adding the "as individual column" qualification. When looking at the answers by themselves that could indeed be confusing - but in the context of the question, I think it is clear that this is intended. After all, the answers also don't repeat that this only applies to SELECT * queries. In general, it should not be necessary to repeat the entire question in each answer option.

    I guess I have to disagree with myself, too. I was looking at the wording of the answers, not the wording of the question, and the wording of the answers has to be understood in the context of the question and its wording. So the correct answer was indeed the right correct answer (although it was certainly not well worded). My excuse (not a good one) is that one can easily forget the question by the time one has read through all those answers and then read the comments as far as the message I was replying to (which of course repeated the two relevant answers, and not the question).

    Tom