11. What is Object Pool?
Ans: Object pool is a container of object that holds a list of other object that are ready to be used.
Ans: Object pool is a container of object that holds a list of other object that are ready to be used.
12. Describe Object Pooling and Connection Pooling:
Ans: In object Pooling, you can control the number of connection. In connection pooling you can control the maximum number of connection.
When using connection pooling, if there is nothing in pool, connection is created automatically. In another way, when using object pooling, at first pool decide the creation of object.
13. Difference between Read Only and Const?
Ans: Read Only can be modified by the class it is contained. But const cannot be modified. It needs to be instantiated at the time of compilation.
14. Difference between Dataset. Clone and Dataset. Copy?
Ans: Clone- copies the structure of the dataset including all datatable, relation and constraint. Does not copy any data.
Copy- copy both the structure and data for this datatable.
15. Different types of connection object used in ADO.NET?
Ans: 1.SqlConnection object
2.Oracle connection object.
3. OLEDB connection object.
16. Difference between Data Reader and Data Adapter ?
Ans: 1. Data Reader is much faster than Data Adapter.
2. If we use data reader, we have to open and close connection explicitly. But in data adapter connection is automatically open and close.
17. What are different stages of ASP.NET page Life Cycle?
Ans: 1. Page_Init event
2. Page_Loadevent
3. Page_Prerender.
4. Page_Render
5. Page_Unlode
18. Difference between Server. Transfer and Server. Execute?
Ans: Server. Transfer-> Transfer the server control to the requested page given in the parameter .
Server. Execute->Execute the requested page from the current page with no change in the address bar.
Server. Execute->Execute the requested page from the current page with no change in the address bar.
19. What is the use of connection object?
Ans: They are used to connect a data to the command object.
a. An OLEDB connection object is used with an OLE- DB Provider
b. A SQLConnection object user tabular data service(tds) with MS SQL Server.
20. What is ADO.NET?
Ans: ADO.NET is an object oriented framework that allows you to interact with database systems. We usually interact with database system through SQL queries or store procedure.
| Previous | Next |
:: Click the links below for similar type Questions and answers ::
Posted in: 
0 comments:
Post a Comment