esasy
1. What is RDBMS?
esasy
2. What is a primary key?
esasy
3. What are the Different Types of Constraints?
esasy
4. What is the difference between WHERE and HAVING clauses in SQL Server?
esasy
5. What’s the difference between TRUNCATE and DELETE?
esasy
6. What’s the difference between DROP and DELETE?
esasy
7. What is the difference between the 'in' clause and the 'between' clause in SQL?
esasy
8. What is the difference between a primary key and a unique key?
esasy
9. What is a "TRIGGER" in SQL?
esasy
10. What is Normalization?
esasy
11. What is denormalization?
medium
12. lock What is view in SQL and why it is used?
medium
13. lock What are the different ways to replace NULL values in SQL Server?
medium
14. lock What is the difference between clustered and non-clustered index in SQL?
medium
15. lock What is the SQL CASE statement used for? Explain with an example?
medium
16. lock What is ACID property in a database?
medium
17. lock How to avoid duplicate records in a query?
medium
18. lock How to find a duplicate record?
medium
19. lock What is the difference between NULL value, Zero, and Blank space?
medium
20. lock How to Test for NULL Values?
medium
21. lock What is a DEFAULT constraint?
medium
22. lock How can you create an empty table from an existing table?
medium
23. lock What is the usage of SQL functions?
medium
24. lock Why we use HAVING keyword with GROUPBY function instead of WHERE keyword?
medium
25. lock What are the different DCL commands in SQL?
medium
26. lock What is CHECK Constraint?
medium
27. lock When should we create an index?
medium
28. lock What are database constraints?
medium
29. lock What is the difference between union and join?
medium
30. lock What is Auto Increment field?
medium
31. lock Explain about aggregate functions in SQL.
medium
32. lock What is the use of NVL function?
medium
33. lock What are scalar functions in SQL?
medium
34. lock How can you fetch common records from two tables?
hard
35. lock What are the type of locks?
hard
36. lock What are the different types of a subquery?
hard
37. lock How do you optimize your SQL query?
hard
38. lock Write an SQL query to get the third maximum salary of an employee?
hard
39. lock You have a table with three columns: Amount1, Amount2, and Amount3. In a single row only one of these three columns will have a value and the other two will be null. Write a SQL query to retrieve the values from these columns.
hard
40. lock What is difference between Clustered Index and Non-Cluster Index?
hard
41. lock Write a query to create an empty table from an existing table?
hard
42. lock What is the use of Execution plan in SQL?
hard
43. lock Write SQL Query to find employees that have same name and email.
hard
44. lock How can you insert NULL values in a column while inserting the data?