Salary queries CTE vs Table variable Vs Temp table Manager hierarchy Where vs Having How to remove duplicate records - Different ways? Indexing - Can we add primary constraint and cluster index on different columns? Index seek, table scan, key lookup, row look up, Views - can we Update, types, Indexed view, materialized view Department-wise highest salaries - Queries How will you design car showroom maintenance DB? Image datatypes Window functions Second round - Indexes Projects you worked on which procedures you have worked on, and what logic have you written? Temp tables, CTE, table variable Cursor Views Integer pattern Functions and stored procedures Nested stored procedure Query optimization How it works Why cursors should not be used. Cursor ka workaround Wild cards and ways of implementation without using like operator. Filter vowels from string, count of vowel. The composite index, Index seek and scan, SQL injection Linked server
