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.
This is really awesome, sql wise. Thank you for the link.
(actually the correct people are wrong and some selected wrong people are actually right)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.