ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Microsoft Related >> ADO.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions (615)
 C Sharp interview questions  C Sharp Interview Questions (722)
 ASP.NET interview questions  ASP.NET Interview Questions (1444)
 VB.NET interview questions  VB.NET Interview Questions (151)
 COM+ interview questions  COM+ Interview Questions (41)
 ADO.NET interview questions  ADO.NET Interview Questions (199)
 IIS interview questions  IIS Interview Questions (86)
 MTS interview questions  MTS Interview Questions (5)
 Crystal Reports interview questions  Crystal Reports Interview Questions (62)
 BizTalk interview questions  BizTalk Interview Questions (33)
 Dot Net interview questions  Dot Net Interview Questions (861)
 Exchange Server interview questions  Exchange Server Interview Questions (103)
 SharePoint interview questions  SharePoint Interview Questions (25)
 WCF interview questions  WCF Interview Questions (8)
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions (193)
Question
what is meant by connection pooling and event pumbling in 
ado.net
 Question Submitted By :: ADO.NET
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
Connection Pooling:-
Connection pooling reduces the number of times that new
connections need to be opened. The pooler maintains
ownership of the physical connection. It manages
connections by keeping alive a set of active connections
for each given connection configuration. Whenever a user
calls Open on a connection, the pooler looks to see if
there is an available connection in the pool. If a pooled
connection is available, it returns it to the caller
instead of opening a new connection. When the application
calls Close on the connection, the pooler returns it to the
pooled set of active connections instead of actually
closing it. Once the connection is returned to the pool, it
is ready to be reused on the next Open call.
 
Is This Answer Correct ?    10 Yes 2 No
Gyany
 
Answer
# 2
connection pool is set of active connections object,so that
someone else can make use of it without waiting of creating
the new connection.The number of connections allowed to a
particular database may be limited due to server capacity
or database licensing restrictions.
 
Is This Answer Correct ?    4 Yes 4 No
Prabhat Saxena(lmp)
 
 
 
Answer
# 3
when a connection opened first time the connection pooling
is created , and is based on the exact match connection
string given to the connection object.
It works only the connection string is same.otherwise it
will open a new connection. Hence connection pooling
maintains all these coneections to made the retreive of
data effectively and fastly.
 
Is This Answer Correct ?    0 Yes 2 No
Sandyni
 

 
 
 
Other ADO.NET Interview Questions
 
  Question Asked @ Answers
 
Difference between OLEDB Provider and SqlClient ?   2
Difference between DataReader and DataAdapter / DataSet and DataAdapter? TCS 3
What does ADO.NET consists of ? TCS 7
What is sequence of code in retrieving data from database ? Accenture 3
How to retrieve the third table value from the data set? Network-Solutions 2
Differentiate between Dataset and Recordset.   2
I want to ask u that if i add radio button in ado.net form,and how radion button data insert in SQL2005 Database...   6
Why DataReader is Forward Only? NIIT 16
ADO.NET is Disconnected Architecture. DataReader is connected Architecture, but DataReader is a part of ADO.NET. How is it possible? Zensar 3
WHAT IS DIFF B/W VIEWS AND STORED PROCEDURE   2
Diff b/w DataReader,Dataset and Data table? HCL 5
If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle means not to a particular database depends on condition we have to connect to appropriate database in this scenario if we without changing code Ho wdo you handle this situation? Honeywell 4
 
For more ADO.NET Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com