Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
You are implementing an ASP.NET Web application that connects to a Microsoft SQL Server database using the following connection string:
server=.;database=NorthWind;Integrated Security=SSPI;Min Pool Size=10;Max Pool Size=100
Users authenticate to the Web application using their Microsoft Windows credentials. You must determine how many connection pools the application will create to ensure that connection resource usage is optimized.
How many connection pools will the application create?
on 8/30/2012 | Category:
ADO.NET Interview questions
| Views: 1120 |
Select from following answers:
1 per user
Each connection pool is associated with a distinct connection string. When a new connection is opened, if the connection string is not an exact match to an existing pool, a new pool is created. Connections are pooled per process, per application domain, per connection string, and, when using integrated security, per Windows identity. In this case, the connections are configured to use integrated security. Each user has a discrete Windows identity resulting in the creation of a connection that is pooled separately. There is one connection per connection pool.
Show Correct Answer
MeasureUp.Com | |
< Previous :
What is Forms Authentication Ticket?
Next > :
You are implementing an application that must use ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
You are implementing an application that must use a trusted connection ...
You need to use the Create Database Wizard to create a database to use ...
You implement an EDM. You plan to use the Create Database Wizard to ge ...
You implement an Entity Data Model and then run the Create Database Wi ...
You implement an Entity Data Model. You plan to use the Create Databas ...
You create an Entity Data Model. You need to generate the Data Definit ...
You are implementing an Entity Data Model that will use existing POCO ...
You are implementing an Entity Framework application to access a SQL S ...
Latest Interview Questions
Setting Meta tag through page directive in ASP.NET 4.0...
Explain about refactoring of web.config in ASP.NET 4.0 ?
Explain about shrinking session state in ASP.NET 4.0 ?
In what way do you expand the size of allowable URL size in ASP.NET 4. ...
Explain about Extensible output caching in ASP.NET 4.0 ?
Explain about Response.RedirectPermanent() method in ASP.NET 4.0 ?
Explain the features of ASP.NET 4.0 ?
How can XSS attacks be prevented in ASP.NET 4.0 ?