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 ?