Microsoft Software Engineer interview questions

A colleague at MS referred me. I did a brief phone interview and then I spent an entire day at the Bravern office being interviewed by several people as well as having lunch. I thought I did well in all the interviews except for one interview about databases. The interviewer asked me several questions about database theory. I wasn't applying for a DBA job and wasn't aware that the "software developer" job would require extensive knowledge of database theory. At that point the interviewer seemed to assume that I didn't know anything about databases and instead we just talked about agile practices.

I submitted my resume in a campus career fair. In the career fair the person interviewed me told me that hardware position are very limited this year and encouraged me to apply for a low level programmer position. I received an email asking me to schedule a on campus interview after 2 days.