SQLRNNR (5/23/2014)
I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.Temp tables can be partitioned. With three correct answers and the question requesting a pick 2, it makes it hard to decided which 2 of 3 to pick.
Here is a rundown of the three options that are correct.
Wow. I'm surprised. I can't imagine what I would use it for, but it seems eminently reasonable for the feature to be available even tough until now I believed it wasn't.
Tom