ALLInterview.com :: Home Page KalAajKal.com
 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                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Microsoft Related  >>  ADO.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions
 C Sharp interview questions  C Sharp Interview Questions
 ASP.NET interview questions  ASP.NET Interview Questions
 VB.NET interview questions  VB.NET Interview Questions
 COM+ interview questions  COM+ Interview Questions
 ADO.NET interview questions  ADO.NET Interview Questions
 IIS interview questions  IIS Interview Questions
 MTS interview questions  MTS Interview Questions
 Crystal Reports interview questions  Crystal Reports Interview Questions
 BizTalk interview questions  BizTalk Interview Questions
 Dot Net interview questions  Dot Net Interview Questions
 Exchange Server interview questions  Exchange Server Interview Questions
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions
Question
what is meant by connection pooling and event pumbling in 
ado.net
 Question Submitted By :: Sujjuoct28@yahoo.co.in
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what is meant by connection pooling and event pumbling in ado.net
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 ?    1 Yes 1 No
Gyany
 
  Re: what is meant by connection pooling and event pumbling in ado.net
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 ?    1 Yes 2 No
Prabhat Saxena(lmp)
 
 
 

 
 
 
Other ADO.NET Interview Questions
 
  Question Asked @ Answers
 
what is data access layer? Honeywell2
What is the provider and namespaces being used to access oracle database? Microsoft4
If a dataset contains 100 rows, how to fetch rows between 10 and 20 only ? Ksb10
How to get oledb connection?  3
How would u connect to database using .NET? TCS2
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception. Fulcrum-Logic2
What are the ADO.NET Controls?  3
How to Handle the exceptions in Sqlsrver2000 SQL-Star2
What is a dataset?  2
How to you declare connection strings and how to you make use of web.config ? MMTS2
What are the different row versions available?  2
If i am expecting a single result from sqlserverdatabase then what command should i follow ?sqlcommand.executereader (commandbehaviour.singleresult)or sqlcommand.executescalar()  4
How do you handle data concurrency in .NET ?  6
What is ADO .NET and what is difference between ADO and ADO.NET? Ksb5
Differences between dataset.clone and dataset.copy? Ksb1
Where do you store connection string ? Digital-GlobalSoft1
Which method do you invoke on the DataAdapter control to load your generated dataset with data? Veegyapan-Impacts3
Call a stored procedure from ado.net and pass parameter to it ? Keane-India-Ltd5
what is typed and untyped dataset  2
what is the syntax code for oldb to connect oracle IBM2
 
For more ADO.NET Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com