Microsoft Software Development Test Engineer interview questions

Had 3 interviews back to back in 2 hours C# - - value type and reference types in C# - what is static class? - Memory allocation of static class - what is inheritance - Abstract classes and methods - Derived and Base Class - Attributes in C#? - Overriding - extension functions - strong types - SQL - - what is Indexing? - Types of Index - How to use specific index based on given scenario - There are 2 columns in a table, parent and child, find out child who are also parents. - There are 2 columns in a table, state and poulation, find state that has lowest population. - Employee table - ID,Name,DeptID Dept table - ID,Name Find out number of employees per department?