SanDroid (11/3/2010)
Nice question.I learned something, there were no errors or typos with the answer, and the reference data supported the documentation.
The only negative comment I have is that this code:
SELECT CONVERT(char, SERVERPROPERTY('collation'),'MyDatabaseName')
Returned an error.
It's okay that it returned an error because that wasn't the correct answer. The author of the question probably included that as a distractor in an attempt to get some people to select that answer.