The question was simple.

So the answers had not to be that clear that everyone directly could know the right answer.

Probably the question had to be :

Which answer is the most...

Good blog, Hugo.

NULL is fascinating !

I agree Raghavendra. The datasheet is limited about the information what it really does.

Another good explanation you can find in the link

http://www.dbi-services.com/index.php/blog/entry/sql-server-2016-ctp2-stretch-database-feature-part-1

Have fun !

It must not be to simple.

Anyway Karthik , you got it, so it was clear enough !

More answers are right (like rmbchaber said)

The discussion however is fascinating.

Is NULL=NULL true ?

That's the question.

Most things in life can be reduced to one single question.

Yeah Carlo, I noticed also that all options were wrong !

I had to be TRACEON !

Good choose of answers.

I don't get the clue. Is it so easy ?

I never did a create + insert with a catch.

But that works. If you build it in dynamic SQL it can be worthfull.

Thanks.

I thought it was a joke.

But after reading the explanation I noticed the WTH instead of WITH

Oeps , just lucky that I was right

Ahh, 2 out of 3. Isn't that worth a point ?

I was looking for the fly in the ointment, but couldn't find one.

It looked a bit strange, but it all works normally.

Thanks for the question and the explanation of Nakul and Hugo.

I have learned again something.

That's quite a lot. I didn't know it.