Microsoft Software Development Engineer In Test (SDET) interview questions

I got call from some consultancy and scheduled interview on Weenend. Naturally for everybody MICROSOFT is the dream company so for me aswell. Sometimes i felt even if entering into the MICROSOFT campus is suffucient. With that feelings, went to Hyderabad campus and really it is very big and somany buildings. Once i entered into the campus, security check completed then they arranged a car to go to building 2. Once entered into building 2, HR came and brought us into a room and told to wait for some time. After that called for first round. A lady done the first round for me and basic questions asked. Tell me about ur self Explain the OOPS concepts asked SQL Query: there are two tables books(bname,title,author,bid) and author(aname,bid,btitle) and asked to write a query that count of books writen by authors Questions about testing: Unit testing, regression testing, component testing And tools used for Unit tesitng (NUnit, NCover, FXcop) Explain the testing life cycle. What is SLA guidelines that following for different priority of the issues I have qualified the first round and called for second round. Here asked somany general questions related to testing and how to test those? And also questions to test the logic. Write a program for how to remove a partical string in a given sentence ( i thought this is C and tried to written in C but after sometime interviewer asked to written in c# and i have written in c# aswell) asked program for fibonacci series Then asked c# concepts ( collections, generics, serialisation, threading) what is the use of serialization? ( actually i havent prepared for the interview, i forgot the correct answer and told something which is not correct) Given a program by using arrayList and asked whether this will compile successfully or not? and then how to improve. then asked some stupid questions without any clarity. Even queried for many times i am not clear about the questions: how u test that a given line is straight or not? i have answered, by using the x axis value in all the pixels we can say and also if all y axis values are equal. But not sure what if the line is striaght in someother direction How do u get the exact performance when we playing with a dies, if we throw it up and it get backs to our hand like that in a program. This is the question, where we spend somuch time and at any point i was not clear about the question but not sure what is the intension of the interviewer. Finally after second round i was not selected. Actucally just i put my resume in sites and immediately i got call from MICROSOFT. So my suggestion is if we prepared well definitely we can win in the interview. All we have to do is proper preparation and in net we can find asmuch as info for this interview.