If you want an analytical question, this was the one I had to answer when I interviewed for a contracting position. Actually this was the problem they had and they asked me how I solved it. I gave them the answer and they liked it so they hired me.

The company changed from main frame system to a new CRM system using Oracle. Everyday the mainframe system would generate a whole bunch of text files and loaded into SQL Server tables. The SQL Server tables was used by the web development group. They had the DTS packages to load the text files into SQL Sever tables. Now the company wanted to know how I would load the SQL Server tables using Oracle. The company was implementing the CRM system at the same time. So no one would clearly give the answer to me which table I should use. The company wanted me how I would find out which Oracle tables to use, basically I had to understand the data from the text files and how it matched up with the Oracle tables. I had to create the DTS packages to load the SQL Server tables from Oracle. I had to write up the test plan too so the testers knew how to test the system.

Basically you give the candidates a real life problem and ask them how they can solve it.

The second one was I had to build a data warehouse. I would get data from different outside sources. Each one would give me a text delimited file but with different length and data. Would it be possible to build a dynamic system to read different text files and load into the SQL Server tables? I actually did.