What is the most likely result?

You create an XML Web service that retrieves data from a Microsoft SQL Server database. You instantiate a SqlConnection object named myConnection and set the Max Pool Size property of the connectionString to 50.

All 50 connections are now in use. However, a request for connection number 51 is received.

What is the most likely result?

You create an XML Web service that retrieves data from a Microsoft SQL Server database. You instantiate a SqlConnection object named myConnection and set the Max Pool Size property of the connectionString to 50.

All 50 connections are now in use. However, a request for connection number 51 is received.

What is the most likely result?

A.
An exception is immediately thrown.

B.
The current connection pool is expanded by 50 additional connections.

C.
A new connection pool is created that has the same maximum number of connections.

D.
The request is queued until a connection becomes available or until the timeout limit is reached.



Leave a Reply 0

Your email address will not be published. Required fields are marked *