Microsoft Software Engineer interview questions

Campus interview for 30 min. Behaviour questions first: what's the most difficult project you did before? Describe it. Then technical questions: Given a linkedlist, how to decide whether there is a loop? If there is, break the loop and make the list like a line.

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.