SQL Interview Questions

In this article, we will see the most popular SQL interview questions.

SQL Interview Questions

Let’s see the most popular top 100 SQL Interview Questions

SQL Interview Questions 1-50

1. What is RDBMS?
2. What are the different TCL commands in SQL?
3. What are the different DML commands in SQL?
4. What is a View?
5. What are the different types of SQL commands?
6. What are the different DDL commands in SQL?
7. What is Synchronized Subquery?
8. What is a Join?
9. What is a Database?
10. Can a table contain multiple PRIMARY KEY’s?
11. What is a Subquery?
12. What is a Record in a Database?
13. What is a column in a Table?
14. What is a Table in a Database?
15. What is the difference between Rename and Alias?
16. What is a Data warehouse?
17. What are SQL constraints?
18. What is the difference between UNIQUE and PRIMARY KEY constraints?
19. What is SQL NOT NULL constraint?
20. What is a Field in a Database?
21. What is the temp table?
22. What is a Unique constraint?
23. What is SQL?
24. What is a FOREIGN KEY?
25. What is DBMS?
26. What is Denormalization?
27. What is the largest value that can be stored in a BYTE data field?
28. What is a DEFAULT constraint?
29. What is a relationship and what are they?
30. List the ACID properties and explain them?
31. What are the different DCL commands in SQL?
32. What are the types of DBMS?
33. What is the difference between Delete, Truncate and Drop command?
34. What are Operators available in SQL?
35. What is an Index?
36. What is the difference between Union and Union All command?
37. What is a query?
38. Define the SELECT INTO statement.
39. What are the popular Database Management Systems in the IT Industry?
40. What are all the different Normalization?
41. What are the types of subquery?
42. What is the difference between Having and Where clause?
43. What are all the different types of indexes?
44. What is a Trigger?
45. What are user-defined functions?
46. Which TCP/IP port does SQL Server run?
47. What is the difference between the Cluster and Non-Cluster Index?
48. What is CLAUSE in SQL?
49. What is Auto Increment in SQL?
50. What are string functions in SQL?

SQL Interview Questions 51-100

1. What is a Composite PRIMARY KEY?
2. What is the difference between Local Variables and Global Variables?
3. What is the difference between Delete and Truncate?
4. What is a NULL value?
5. What is Self-Join?
6. What are all types of user-defined functions?
7. What is Data Integrity?
8. What is the difference between an inner and outer join?
9. How to Test for NULL Values?
10. How to avoid duplicate records in a query?
11. What is the difference between GUI Testing and Database Testing?
12. What are the different types of joins?
13. What is a Stored procedure?
14. What are the constraints available in SQL?
15. What is a CHECK constraint?
16. Can a table contain multiple FOREIGN KEY’s?
17. What is Collation?
18. What is Normalization?
19. What is the difference between NULL value, Zero, and Blank space?
20. What are the possible values that can be stored in a BOOLEAN data field?
21. Explain SQL Data Types?
22. How to display the current date in SQL?
23. What are the aggregate functions in SQL?
24. What will be the result of the query below?
25. How to get each name only once from an employee table?
26. How to select all the odd number of records from a table?
27. How to rename a Table?
28. Write SQL SELECT query that returns the FirstName and LastName from Employee_Details table.
29. How to select all the even number of records from a table?
30. Write an SQL Query to find a list of Employee_Name start with ‘E’ from the below table
31. What is the SQL CASE statement?
32. Can you display the result from the below table TestTable based on the criteria M,m as M and F, f as F and Null as N and g, k, I as U
33. How do you update F as M and M as F from the below table TestTable?
34. What is the difference between NVL function, IFNULL function, and ISNULL function?
35. How to get unique records from a table?
36. What is Database Testing?
37. What is Cross-Join?
38. What will be the result of the query below?
39. Write an SQL Query to select all records from the table?
40. How to add a column ‘Salary’ to a table Employee_Details?
41. How to add new Employee details in an Employee_Details table with the following details
42. How to change the value of the field ‘Salary’ as 7500 for an Employee_Name ‘John’ in a table Employee_Details?
43. What is the command used to fetch the first 5 characters of a string?
44. How To Get List of All Tables From A DataBase?
45. Define the SQL Delete statement.
46. What are all different types of collation sensitivity?
47. Write an SQL Query to find an Employee_Name whose Salary is equal or greater than 5000 from the below table
48. Write the command to remove all Players named Sachin from the Players table.
49. How to fetch values from TestTable1 that are not in TestTable2 without using NOT keyword?
50. What is the order of SQL SELECT?
51. What is a Primary Key?

I hope, we have covered almost all the most common SQL interview questions in the above list.

Related Posts:

• Tell Me About Yourself
• What Are Your Strengths
• What Are Your Weaknesses
• Most Important Interview Questions
• Selenium Interview Questions
• Manual Testing Interview Questions
• Software QA Interview Questions
• Java Interview Questions
• SQL Interview Questions
• API Interview Questions

If you have any more questions, feel free to ask via comments. If you find this post useful, do share it with your friends on Social Networking.