Michael Poppers (11/3/2010)
Yes, he might have been better off listing the possible choice asSELECT CONVERT(char, SERVERPROPERTY('collation','MyDatabaseName'))and perhaps that was his intention :-).
Agreed. I work in a training organization and consider myself a quiz expert. Writing many quiz applications and writing the actual quizzes too. I can say with 100% certainty that it was a bad distractor because anyone that knows how to use the convert command would know that you don't put the Database name as the second parameter. You can then remove that possible answer as one that you should select.
It could have been offered as
SELECT SERVERPROPERTY('collation','MyDatabaseName') and just leave off the Convert portion.