sql Interview Questions
| Provide your E-Mail ID below to receive FRESHERS JOBS & Walkins information in your mail id. |
1. What is RDBMS? [Answer]
2. What are the properties of the Relational tables? [Answer]
3. What is Normalization? [Answer]
4. What is Denormalization? [Answer]
5. What are different normalization forms? [Answer]
6. What is Stored Procedure? [Answer]
7. What is Trigger? [Answer]
8. What is View? [Answer]
9. What is Index? [Answer]
10. What is a Linked Server? [Answer]
11. What is Cursor? [Answer]
12. What is Collation? [Answer]
13. What is Difference between Function and Stored Procedure? [Answer]
14. What is subquery? Explain properties of subquery? [Answer]
15. What are different Types of Join? [Answer]
16. What are primary keys and foreign keys? [Answer]
17. What is User Defined Functions? What kind of User‐Defined Functions can be created? [Answer]
18. What is Identity? [Answer]
19. What is DataWarehousing? [Answer]
20. Which TCP/IP port does SQL Server run on? How can it be changed? [Answer]
21. What are the difference between clustered and a nonclustered index? [Answer]
22. What are the different index configurations a table can have? [Answer]
23. What's the difference between a primary key and a unique key? [Answer]
24. What is difference between DELETE & TRUNCATE commands? [Answer]
25. When is the use of UPDATE_STATISTICS command? [Answer]
26. What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? [Answer]
27. What are the properties and different Types of SubQueries? [Answer]
28. What is SQL Profiler? [Answer]
29. What are the authentication modes in SQL Server? How can it be changed? [Answer]
30. Which command using Query Analyzer will give you the version of SQL server and operating system? [Answer]
31. What is SQL Server Agent? [Answer]
32. Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible? [Answer]
33. What is Log Shipping? [Answer]
34. Name 3 ways to get an accurate count of the number of records in a table? [Answer]
35. What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF? [Answer]
36. What is the difference between a Local and a Global temporary table? [Answer]
37. What is the STUFF function and how does it differ from the REPLACE function? [Answer]
38. What is PRIMARY KEY? [Answer]
39. What is UNIQUE KEY constraint? [Answer]
40. What is FOREIGN KEY? [Answer]
41. What is CHECK Constraint? [Answer]
42. What is NOT NULL Constraint? [Answer]
43. How to get @@ERROR and @@ROWCOUNT at the same time? [Answer]
44. What is a Scheduled Jobs or What is a Scheduled Tasks? [Answer]
45. What are the advantages of using Stored Procedures? [Answer]
46. What is a table called, if it has neither Cluster nor Non‐cluster Index? What is it used for? [Answer]
47. Can SQL Servers linked to other servers like Oracle? [Answer]
48. What is BCP? When does it used? [Answer]
49. What command do we use to rename a db, a table and a column? [Answer]
50. What are sp_configure commands and set commands? [Answer]
51. How to implement onetoone, onetomany and manytomany relationships while designing tables? [Answer]
52. What is an execution plan? When would you use it? How would you view the execution plan? [Answer]