This answer is wrong. Just because SQL does not actually perform the backup, doesn't mean it won't store information about the RESTORE command. In that table, there's a...

There is only 1 correct answer, and that's the 2nd. The desc, asc answer will NOT list the employees as shown.

There has to be some error. The only answer that's correct is SP2, the explanation says SP2, but the result of choosing SP2 is that you are wrong?!!

The 1st and 3rd answers were both wrong for my birthday. The 2nd was the only correct option.

Based on the BOL explanation, none of these answers are actually correct as being not supported.

Does this mean that "the function doesn't exist" answer should also be credited as correct?

I think the answer is wrong.  @@applock_mode actually does NOT exist.  APPLOCK_MODE will get you what you're looking for.