Scribd
Upload
9 views

100 Interview Questions On SQL Language

This document lists 100 interview questions about SQL language concepts and functions. It covers topics like SQL statements, joins, aggregation, functions, data definition and manipulation, stored procedures, indexes and more.

Uploaded by

lekhak2024
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views

100 Interview Questions On SQL Language

This document lists 100 interview questions about SQL language concepts and functions. It covers topics like SQL statements, joins, aggregation, functions, data definition and manipulation, stored procedures, indexes and more.

Uploaded by

lekhak2024
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

Intern Crowd LLP

100 interview questions on Sql language

1. What is the purpose of the SELECT statement?


2. What is a JOIN in SQL?
3. What is the difference between a WHERE clause and a HAVING
clause?
4. What are the different types of JOINs available in SQL?
5. How do you delete a record from a table in SQL?
6. How do you update a record in a table in SQL?
7. What is the difference between a primary key and a foreign key?
8. What is the difference between a UNION and a UNION ALL?
9. What is the difference between a LEFT JOIN and a RIGHT JOIN?
10. What is the difference between a clustered and a non-clustered
index?
11. What is the purpose of the GROUP BY clause in SQL?
12. How do you insert data into a table in SQL?
13. What is the purpose of the ORDER BY clause in SQL?
14. How do you create a view in SQL?
15. What is a stored procedure in SQL?
16. What is the purpose of the DISTINCT keyword in SQL?
17. What is the purpose of the WITH clause in SQL?
18. How do you create a trigger in SQL?
19. How do you create a user-defined function in SQL?
20. What is the purpose of the INNER JOIN clause in SQL?
21. What is the purpose of the LIKE operator in SQL?
22. What is the purpose of the COUNT function in SQL?
23. What is the purpose of the TOP clause in SQL?
24. How do you create a table in SQL?

www.interncrowd.in
Intern Crowd LLP
100 interview questions on Sql language

25. What is the purpose of the BETWEEN operator in SQL?


26. What is the purpose of the IS NULL operator in SQL?
27. What is the purpose of the AND operator in SQL?
28. What is the purpose of the OR operator in SQL?
29. What is the purpose of the NOT operator in SQL?
30. What is the purpose of the UNIQUE keyword in SQL?
31. What is the purpose of the DDL (Data Definition Language) in SQL?
32. What is the purpose of the DML (Data Manipulation Language) in
SQL?
33. What is the purpose of the DELETE statement in SQL?
34. What is the purpose of the UPDATE statement in SQL?
35. What is the purpose of the INSERT statement in SQL?
36. What is the purpose of the CREATE statement in SQL?
37. What is the purpose of the ALTER statement in SQL?
38. What is the purpose of the DROP statement in SQL?
39. What is the purpose of the TRUNCATE statement in SQL?
40. What is the purpose of the GRANT statement in SQL?
41. How do you create a user in SQL?
42. How do you grant privileges to a user in SQL?
43. How do you revoke privileges from a user in SQL?
44. What is a subquery in SQL?
45. What is the purpose of the EXISTS operator in SQL?
46. What is the purpose of the IN operator in SQL?
47. What is the purpose of the NOT IN operator in SQL?
48. What is the purpose of the ANY and ALL operators in SQL?
49. What is the purpose of the CONTAINS operator in SQL?
50. What is the purpose of the LIKE operator in SQL?

www.interncrowd.in
Intern Crowd LLP
100 interview questions on Sql language

51. What is the purpose of the MIN and MAX aggregate functions in
SQL?
52. What is the purpose of the AVG aggregate function in SQL?
53. What are the benefits of using stored procedures in SQL?
54. How do you compile a stored procedure in SQL?
55. What is the purpose of the CASE statement in SQL?
56. What is the purpose of the COALESCE function in SQL?
57. What is the purpose of the CAST function in SQL?
58. What is the purpose of the DATEADD function in SQL?
59. What is the purpose of the DATEDIFF function in SQL?
60. What is the purpose of the DATENAME function in SQL?
61. What is the purpose of the DATEPART function in SQL?
62. What is the purpose of the ISNULL function in SQL?
63. What is the purpose of the LEN function in SQL?
64. What is the purpose of the SUBSTRING function in SQL?
65. What is the purpose of the ROUND function in SQL?
66. What is the purpose of the FORMAT function in SQL?
67. What is the purpose of the SELECT INTO statement in SQL?
68. What is the purpose of the CREATE INDEX statement in SQL?
69. What is the purpose of the DROP INDEX statement in SQL?
70. What is the purpose of the CREATE TABLE statement in SQL?
71. What is the purpose of the DROP TABLE statement in SQL?
72. What is the purpose of the CREATE VIEW statement in SQL?
73. What is the purpose of the DROP VIEW statement in SQL?
74. What is the purpose of the CREATE TRIGGER statement in SQL?
75. What is the purpose of the DROP TRIGGER statement in SQL?

www.interncrowd.in
Intern Crowd LLP
100 interview questions on Sql language

76. What is the purpose of the CREATE PROCEDURE statement in


SQL?
77. What is the purpose of the DROP PROCEDURE statement in SQL?
78. What is the purpose of the ROLLBACK statement in SQL?
79. What is the purpose of the COMMIT statement in SQL?
80. What is the purpose of the SAVEPOINT statement in SQL?
81. What is the purpose of the SELECT TOP statement in SQL?
82. What is the purpose of the WITH RECURSIVE statement in SQL?
83. What is the purpose of the DECODE function in SQL?
84. What is the purpose of the CONCAT function in SQL?
85. What is the purpose of the TRIM function in SQL?
86. What is the purpose of the LOWER and UPPER functions in SQL?
87. What is the purpose of the RANK function in SQL?
88. What is the purpose of the NTILE function in SQL?
89. What is the purpose of the MD5 function in SQL?
90. What is the purpose of the ROW_NUMBER function in SQL?
91. What is the purpose of the ROWNUM pseudo-column in SQL?
92. What is the purpose of the FIRST and LAST functions in SQL?
93. What is the purpose of the HASHBYTES function in SQL?
94. What is the purpose of the ROUNDDOWN and ROUNDUP functions
in SQL?
95. What is the purpose of the ISNUMERIC function in SQL?
96. What is the purpose of the ISDATE function in SQL?
97. What is the purpose of the ISNULLABLE function in SQL?
98. What is the purpose of the COLLATE clause in SQL?
99. What is the purpose of the NVL function in SQL?
100. What is the purpose of the NVL2 function in SQL?

www.interncrowd.in

You might also like