Questions about stored Procedures, Nested Stored Procedures, Dynamic Sql, Row level Aggregations, Count of male or female as new column along with existing columns, Recursive CTE, Difference between Temp DB and Table Variables, Experience working with different SQL objects, Difference between Joins, Nested queries, subqueries, Co-related Sub queries, DML operations using Rank Functions in CTE, T-SQL, Triggers, Instead of Triggers, Transactions using SP's, Isolation levels, Dead Block handling, security, SQL profiler and Execution Plans, Indexes, Performance Tuning techniques using indexes, Views, user defined Functions.