1. He asked me to write an SQL query, “Given a table with duplicate rows, remove duplicate rows from table”. I was not able to solve this question.
2. He asked me to write an SQL query, “Given employee table with manager id, find manger id who manages highest number of employee”. I was able to solve using ‘group by’ and ‘count’.
3. What is normalisation and clustered index vs non-clustered index?
4. Asked me to write a multi-threaded program, “Create two thread, perform some operation on shared variable, avoiding race condition”, similar to producer-consumer problem. I was able to write code, but it did not working, maximam time was taken by this problem. At the end interviewer said to leave it because time was over.