I never had any such oddball questions but known to have two in my repertoire myself:

"Starwars or Star Trek?" If the person is passionate about either it opens often a good feel conversation. If neither then it might open a conversation outside of technical competency that can show a lot about character on both sides of the table (if you sit across a table that is).

"How would you fill a coffee cup in T-SQL?" There is no straight right answer, more of a way of showing how the interviewee thinks and tackles a problem that is not as straightforward as an Inner Join.

Kind of expected answer in case you wonder yourself:

SELECT [Top 1] coffee INTO coffee.Cup FROM coffee.Machine

I heard endless variations on this and it seems to be a question that makes nearly all T-SQL developers think hard.