So let me get this straight... because I knew how the function worked, I am wrong.
Had I not known how it worked, I would have had a pretty decent chance of being right.
Very curious question that rewards ignorance whilst penalising knowledge.
I might submit one along similar lines:
Q: If I issue a SELECT TOP 5 * FROM CUSTOMER query where the CUSTOMER table has more than 10 rows, how many rows will be returned?
a) (incorrect) I know it will be 5
b) (correct) I'm guessing 5 but that's probably wrong
c) (incorrect) 37
d) (incorrect) error
What do you think? Is this the way forward?