Hugo Kornelis (5/23/2014)
I was surprised to see so many people claim that this is an easy question, since there is a very glaring error - there is only one error.
But after reading the discussion I understand that the question was changed. Not for the better, though.
Local temporary tables are not visible to all sessions, only to the current session. Global temporary tables are visible to all sessions.
I'm glad I'm not the only one who found the question was difficult since I could only find 1 correct answer and there was supposed to be 2.