Workshop

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."

Quiz

1:	When is a connection pool entry established? When you open a connection to the database When you fill a DataSet When you close a connection to the database When you read the rows from the DataSet
2:	True or false: Connection pooling is automatically turned off for .NET.
3:	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? Store it in cache Record the time it was used in a local variable Close the connection to the database Open a new connection to a different database
4:	What must match exactly for the application to draw on an already established connection pool entry? The entire connection string The database portion of the connection string The DataSet name The minimum pool size
5:	What performance object can you use to monitor usage of connection pooling? MSSQL$NetSDK:Buffers .NET CLR Security ”performance object ADO.NET ”performance object .NET CLR Data ”performance object

Exercise

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