Great question. 2) and 4) should give a warning about the nonexistent table, but will run nevertheless.

I don't understand why 5% of the answers don't include the first option. I...

Pretty sure it's called 'covering index' or less commonly 'cover index', but not 'covered index'. The index is not the one being covered.

Moral of today's question. Be careful when using indeterministic functions inside nullif...

Great article. However, personallly I wouldn't use column numbers in the order by clause. It's a bit of a bad habit in my opinion and can cause issues later on...

Thanks. This is very useful information. Just on your company's overstrict policy on forums. Forum discussions are an essential tool for DBAs, heck, IT staff in general. It's a necessity....

None of the answers is correct. Choose is a 2012 function, so it doesn't work in 2008 R2, which is the *assumed* SQL version here. Nowhere in the question do...

Stolen from Microsoft Exam questions.

nuh.. uh.. the 'correct' answer is wrong. This will produce a syntax error due to the misspelt column name in the subquery.