Return to site

SQL interview questions

· freebies,mooc,workplace
  1. State the differences between HAVING and WHERE clauses.
  2. What is SQL?
  3. Explain the different types of SQL commands.
  4. What is a default constraint?
  5. What is a unique constraint?
  6. How would you find the second highest salary from the below table?
  7. What is a Primary Key?
  8. What is a Foreign Key?
  9. What is an Index?
  10. Explain the types of Indexes.
  11. State the differences between Clustered and Non-clustered indexes.
  12. State the differences between SQL and PL/SQL.
  13. What do you understand by a Character Manipulation function?
  14. What is AUTO_INCREMENT?
  15. What is the difference between DELETE and TRUNCATE commands?
  16. What is COALESCE function?
  17. What do you understand by Normalization and Denormalization?
  18. What is wrong with the below-given SQL query?
  19. What do you know about the stuff() function?
  20. What are Views? Give an example.
  21. What is a stored procedure? Give an example
  22. What do you know about Joins? Define different types of Joins.
  23. Explain Inner Join.
  24. State the differences between Views and Tables.
  25. What do you understand by a Temporary Table?