for RuBoard

These quiz questions are designed to test your knowledge of the material covered in this chapter. The answers to the quiz questions can be found in Appendix A, "Answers to Quizzes."



When is a connection pool entry established?

  1. When you open a connection to the database

  2. When you fill a DataSet

  3. When you close a connection to the database

  4. When you read the rows from the DataSet


True or false: Connection pooling is automatically turned off for .NET.


What must you do every time in coding to make sure that you and others can take advantage of the connection pool in subsequent processing?

  1. Store it in cache

  2. Record the time it was used in a local variable

  3. Close the connection to the database

  4. Open a new connection to a different database


What must match exactly for the application to draw on an already established connection pool entry?

  1. The entire connection string

  2. The database portion of the connection string

  3. The DataSet name

  4. The minimum pool size


What performance object can you use to monitor usage of connection pooling?

  1. MSSQL$NetSDK:Buffers

  2. .NET CLR Security ”performance object

  3. ADO.NET ”performance object

  4. .NET CLR Data ”performance object


Part I: Modify the 17conpool.vb code to request a minimum pool size of 20 and a maximum pool size of 200 for both connection strings. Monitor the behavior of these changes using Performance Monitor.

Part II: The 17conpool.vb code uses the .NET SQL Server data provider. Recode this program to use the OLE DB data provider instead.

for RuBoard

Sams Teach Yourself ADO. NET in 24 Hours
Sams Teach Yourself ADO.NET in 24 Hours
ISBN: 0672323834
EAN: 2147483647
Year: 2002
Pages: 237 © 2008-2017.
If you may any questions please contact us: