1. What is DBMS & RDBMS ?
2. What is E-R/Entity Relationship Diagram ?
3. What is ACID ? Explain in Brief ?
4. What are the CODES rules explain ?
5. What is Relationship and what are the kind of Relationship ?
6. What is Normalization . What are the Kinds of Normalization ?
7. What is Metadata ?
8. What are Differences between DDL, DML and DCL ?
9. What is join and what are the kinds of Joins in SQL Server ?
10. What are the basic modeling of Database ? Conceptual, Logical and Physical
11. What is Views ? how to create ?
12. What is Integrity and Constraints ?
13. What is Entity , Referential and Domain Integrity ?
14. What is Differences between Primary Key and Unique Key ?
15. What is Foreign Key ?
16. What is Trigger ? what are the kinds of Trigger ?
17. What is DDL and DML Trigger ?
18. What are types of DML Trigger ? After, Instead Of .
19. What is Cursor ?
20. What is the Structure or flow of a cursor ? How to implement cursor ?
21. What is Identity ? How to create Identity in Existing Table ?
22. How to check and change Identity speed ?
23. What is Composite Key ?
24. What is Sparse Column ?
25. What are differences between TRUNCATE and DELETE ?
26. How to find missing Identity of a table ?
27. How to Insert missing identity into existing table ?
28. What is check constraints ? How to implement it on a table ?
29. What is the Basic flow of Query processing in SQL Server ?
30. How does SQL Process any given query from GUI ?
31. What are differences between Temp Table and Table Variable ?
32. What is Local and Global Variable ?
33. How to handle ERROR in SQL Server ? TRY-Catch..
34. What is Function and what are the kind of Functions ?
35. What are system function and UDF ?
36. What is SCALAR Function ?
37. What is Table Valued Function ?
38. What is Stored Procedure ?
39. What are difference between Stored Procedure and Function ?
40. What are difference between CHAR,VARCHAR, nchar and nvarchar and TEXT ?
41. What is VARCHAR (MAX) ?
42. What is @@ROWCOUNT ?
43. What is Union and Union All ?
44. What is PIVOT and how to create Pivot in SQL Server ? Give Syntax .
45. What is LINQ ?
46. What is Checkpoint ?
47. What are aggregate functions ?
48. If SPs are encrypted than can we see its text ?
49. What is MARS ?
50. How to recompile Stored Procedure ?
51. What is Transaction ? What are the Kinds of Transactions ?
52. How to check length of TEXT Field ?
53. What Data Type allow to store more than 2 GB ?
54. What are the precautions of Cursor usage ?
55. What is Dynamic Query ? How to implement ?
56. What is Difference between STUFF and Replace ?
57. What is SP_Excute_SQL ?
58. Whatis Cross Apply ?
59. Whatis Ranking Function ?
60. What is the Usage of OUTPUT Clouse ?
61. How to get top 3 records without use of TOP Clouse ?
62. Whatis Set No Count On ?
63. What are differences between where and Having ?
64. What is sub query ?
65. What is Correlated Sub query ? how to implement it ?
66. What is CTE ? How to implement it ?