Deloitte Manager interview questions

I had an initial interview with the experienced recruiter and a call with a Director. All were very professional.

I had about 3 telephone interviews & 1 in person ( 4 people interviewed me) Telephone - What are cursors, triggers - Asked me to write a small algorihtm for printing few #'s div by 3. - Few other questions about .Net/ sql server etc.. In Person I met with 4 people 2 of them were technical. - SQL Server ( this is where I think I screwed up) What are indexes? Clustered and non clustered? What are cursors? What are diff bween Inner join & outer join? Write a query between two tables to show Sum of amount based on a certain field indicator on one of the column. amt > 1 Mil $ ( I didn't have enough time to write the query and the next guy barged in. So they dinged me on this one). .Net - Framework? - Execute reader vs exec non query - execscalar? - Clustering of IIS servers. Few other basic .net questions.