^ (bitwise exclusive or) took some time to find out the correct answer

good question thanks.

didn't see option with space there...

got me on null constrains

Really Good one.

I thought ';' is a typo and ignored that.

Agree. i thought that it's testing for identity column values. but still good question.

All is by default so II & III are same expressions

Learn about Null bit map thanks

Simple

Great Question it chew up my hour worth ups time. 😀

I thought identity_insert would allow duplicates but google said no....

You can't always trust information on internet 😀

Good Question I got lost in Union all.

Good one It's easy to get lost in this type of questions