I copied and pasted the code into SQL Server 2014 and got this:

Msg 156, Level 15, State 1, Line 21

Incorrect syntax near the keyword 'OR'.

Msg 156, Level 15, State 1,...

I can't imagine what could pOssibly...

An interesting question, but slightly spoiled by the format of the answers (select three from five, where two pairs were mutually exclusive, meaning that the singleton must perforce be one...

I would have found this easier if there had actually been a question.

Stewart "Arturius" Campbell (1/14/2015)

---

That...

I copied the script from the site "as is".

2008 R2 SP1

Actually, it returns:

Msg 102, Level 15, State 1, Line 4

Incorrect syntax near ','.

TomThomson (11/24/2014)

---

It's one of those problems that we inevitablu have when writing specifications or requirements in natural languages, instead of using formal systems like Z or VDM; of course formal...

The question asked:

Which of the following will return only the Id of the most recent post for each Author?

The correct answer should have been "None of the above", since...

The update was incomplete as well. The requirement was to update two rows, so the SQL should have read

SET IDENTITY_INSERT dbo.Roles ON

UPDATE dbo.Roles

SET RoleID=-3

WHERE RoleID=-2;

UPDATE dbo.Roles

SET...

I don't often answer these questions, but of the few times I have, twice the answers have been wrong. Pretty poor proof-reading; wouldn't trust them with my database! 😀

I chose option 1 also.

A little bit too server-y, not enough SQL-y. But I got a point anyway.

TomThomson (10/15/2014)

---

As many have already pointed out, the "correct" answer is bunk. There will be a syntax error because "column" is a reserved word. So the only option...