SQL Basic Interview Questions
  1. What is RDBMS?
  2. What is SQL?
  3. What is a Database?
  4. What are tables and Fields?
  5. What do you mean by data manipulation language - DML?
  6. What is a primary key?
  7. What is a unique key?
  8. What is a foreign key?
  9. What is a join?
  10. What are the types of join and explain each?
  11. What is normalization?
  12. What is Denormalization?
  13. What are all the different normalizations?
  14. What is a View?
  15. What is an Index?
  16. What are all the different types of indexes?
  17. What is a Cursor?
  18. What is a relationship and what are they?
  19. What is a query?
  20. What is subquery?
  21. What are the types of subquery?
  22. What is a stored procedure?
  23. What is a trigger?
  24. What is the difference between DELETE and TRUNCATE commands?
  25. What are local and global variables and their differences?
  26. What is a constraint?
  27. What is data Integrity?
  28. What is SQL comments?
  29. What is Auto Increment?
  30. What is Datawarehouse?
SQL Intermediate Interview Questions
  1. What is the difference between SQL and PL/SQL?
  2. What is the difference between SQL and MySQL?
  3. What is the difference between Cluster and Non-Cluster Index?
  4. What is Self-Join?
  5. What is Cross-Join?
  6. What is user defined functions?
  7. What are all types of user defined functions?
  8. What is collation?
  9. What are all different types of collation sensitivity?
  10. Advantages and Disadvantages of Stored Procedure.
  11. What is Online Transaction Processing (OLTP)?
  12. What is CLAUSE?
  13. What is recursive stored procedure?
  14. What is Union, minus and Interact commands?
  15. Which TCP/IP port does SQL Server run?
  16. What is an ALIAS command?
  17. What is the difference between TRUNCATE and DROP statements?
  18. What are aggregate and scalar functions?
  19. Which operator is used in query for pattern matching?
  20. How to select unique records from a table?
  21. List and explain each of the ACID properties that collectively guarantee that database transactions are processed reliably.
  22. What is the main difference between ‘BETWEEN’ and ‘IN’ condition operators?
  23. Why are SQL functions used?
  24. List the ways in which Dynamic SQL can be executed?
  25. List some case manipulation functions in SQL.
  26. What is a Non-correlated subquery?
SQL Advanced Interview Questions
  1. What is a SYSTEM Privilege?
  2. What are Object Privileges?
  3. What does the BCP command do?
  4. Does the data stored in the stored procedure increase access time or execution time? Explain
  5. Can a Stored Procedure contain a return value?
  6. Can a View be active if the Base table is dropped?
  7. What is the difference between the RANK() and DENSE_RANK() functions? Provide an example.
  8. What is the difference between char and varchar2?
  9. What is CTE?
  10. Does View contain Data?
  11. Define a temp table.
  12. What is Referential Integrity?
  13. What do you mean by query optimization?
  14. What is Database Black Box Testing?
  15. What do we need to check in Database Testing?
  16. What are Nested Triggers?
  17. What is SQL Sandbox in SQL Server?
  18. What is SQL Injection?
  19. What is returned by the cursor attribute SQL%NOTFOUND?
  20. What do you understand by explicit cursors?
  21. What is Deadlocking?
  22. How can you say that Database testing is different from that of GUI testing?
  23. How to prevent SQL Injection Attacks?