SQL Intermediate Interview Questions
  1. What is normalization in SQL?
  2. What are the different forms of normalization?
  3. How would you add a constraint to a table?
  4. What is an Index in SQL?
  5. What are the different types of Indexes in SQL?
  6. What is a subquery in SQL?
  7. What is the difference between a subquery and a join?
  8. What is a view in SQL?
  9. How would you create a view in SQL?
  10. How would you modify a view in SQL?
  11. What is the difference between UNION and UNION ALL in SQL?
  12. How would you modify a trigger in SQL?
  13. What is a stored procedure in SQL?
  14. What is the difference between a stored procedure and a view in SQL?
  15. How would you create a scalar function in SQL?
  16. How would you create a table-valued function in SQL?
  17. What is the difference between a subquery and a correlated subquery in SQL?
  18. How would you write a correlated subquery in SQL?
  19. What is a full outer join in SQL?
  20. What is a left outer join in SQL?
  21. What is a clustered index in SQL?
  22. How is a clustered index different from a non-clustered index in SQL?
  23. What is a non-clustered index in SQL?
  24. How would you create a non-clustered index in SQL?
  25. What is a composite index in SQL?
  26. How would you create a composite index in SQL?
  27. What is a full-text search in SQL?
  28. How would you perform a full-text search in SQL?
  29. What is a trigger in SQL?
  30. How would you create a user-defined function in SQL?
  31. How is a scalar function different from a table-valued function in SQL?
  32. How would you use a table-valued function in SQL?
  33. How would you use a common table expression in SQL?
  34. How would you use a correlated subquery in SQL?
  35. How would you use a self-join in SQL?
  36. What is a recursive CTE in SQL?
  37. How would you use a recursive CTE in SQL?
  38. What is a materialized view in SQL?
SQL Interview Questions For Experienced
  1. How would you create a stored procedure in SQL?
  2. How would you create a trigger in SQL?
  3. How would you implement a transaction in SQL?
  4. What is the difference between a clustered and a non-clustered index?
  5. What is a cursor in SQL?
  6. How would you use a cursor in SQL?
  7. What is a Common Table Expression (CTE) in SQL?
  8. How would you create a CTE in SQL?
  9. How would you use a recursive CTE in SQL?
  10. What is a window function in SQL?
  11. How would you use a window function in SQL?
  12. How would you create a materialized view in SQL?
  13. What is a pivot table in SQL?
  14. How would you create a pivot table in SQL?
  15. What is a common table expression in SQL?
  16. What is the difference between a stored procedure and a function in SQL?
  17. How would you create a function in SQL?
  18. What is a temp table in SQL?
  19. How would you create a temp table in SQL?
  20. How would you refresh a materialized view in SQL?
  21. What is a clustered index in SQL?
  22. How would you create a clustered index in SQL?
  23. What is a non-clustered index in SQL?
  24. How would you create a non-clustered index in SQL?
  25. What is the difference between a cursor and a temporary table in SQL?
  26. How would you use a cursor in SQL to update data?
  27. How would you create a partitioned table in SQL?
  28. How would you create a partition function in SQL?
  29. How would you create a partition scheme in SQL?
  30. How would you change the collation of a database in SQL?
  31. How would you write a correlated subquery in SQL?
  32. How would you create a pivot table in SQL?
  33. What is a self join in SQL?
  34. What is a composite key in SQL?
  35. What is a database schema in SQL?
  36. How would you create a database schema in SQL?