SQL Server & C# Interview Questions — Part 3: Triggers, Indexes, DataSets Explained

1. data integrity depends on
1. data sharing
2. accuracy
3.  redundency
4. 2&4                             ANS: accuracy
2. which is lightweight protocal?        ANS:soap
3. class is which based memory     ANS: Heap
4.  csharp code is                         ANS: managed
5. sn.exe generates what?            ANS: Strong Name
6. file and fileinfo classes doesn't offer the set of functionality
1. moving
2. creating
3. copying 
4. deleting                                  ANS: Creating
7. datareader field count return type        ANS:integer
8. type dataset and untype dataset difference?
• type dataset have schema information of database(primary key and FK info)
• untype does not have schema information
9. GOALS OF INTEROPERABILITY
• ANSWER
• net does not affect existing COM objects
• .Net and COM components interoperate with each other
• COM components can be upgraded into .NET components
10. if u build the application what file with extension generated                  ANS: .exe
11. null is a string ?                                   ANS: NO
12. which access specifiers not hide the variables in namespace
1. internal 
2. protected 
3. internal protected
4. public                                                                              ANS:public
13. which access modifier is specify for incomplete class  
1. abstract
2. virtual
3. override
4. sealed                                                               ANS: abstract
14. which keyword permits to overload abstract methods? ANS: Abstract override
15. which is not feature of c sharp                   ANS: c sharp is not a case sensitive
16. .The class which offers storage capability    Ans:ICollection 
17. sealed class                             ANS: We can’t further inherit the sealed class
18. how date types are available?   ANS:   1.Value  types  2. Reference  types   3. Pointer  types
19. which is responsible for loading data into dataset?                ANS: DataAdapter
20. .what is cLI?   ANS:  Common Language Infrastructure
21. .LINQ full form?    Ans : Language Integrated Query
22. OLEDB full form?          ANS  Object Linking and Embedding, Database,
23. what is the backbone of disconnected model?  ANS:Data adapter
24. .AJAX full form?   ANS : Asynchronous JavaScript and XML
25. .Full form of ccw? ANS :  COM Callable Wrapper
26.  net doesn’t not support which web standards?    Ans: other than this  HTTP,XML,SOAP,WSDL,UDDI. 
27. What will ICollection have?   Ans:IList and Idictionary

SQL SERVER

1. .we can minimize the selection process by using which clause?ANS: : where
2. DATABASE METADATA STORE IN WHICH PLACE ANS: : System catalog or System Table
3. EXTENT LENGTH  ANS: : 8 Contiguous pages(64KB)
4. which stores the pre defined query?  ANS: : System Stored Procedure  
5. sql server doesn't run which os? 
1. xp 
2. 98 
3. 95 
4. millineum                                    ANS: : 95
6. we can perform insert delete update operation on?
1. table
2. view 
3. trigger 
4. index                                 ANS:  table
7. which produces result and also non relational result
1. compute
2. cube
3. rollup
4. none                          ANS: : Compute
8.  a query which relay on output of inner query
1. correrelate subquery
2. nested subquery
3. inner querey 
4. none                       ANS:  Corelated subquery