Which of the following is the process of reusing existing active connections instead of creating new
connections when a user makes a request to the database?
A.
Connection object
B.
Connection pooling
C.
Database connection
D.
LinqDataSource
Explanation:
Connection pooling is the process of reusing existing active connections instead of creating new
connections when a user makes a request to the database. The connection manager is responsible
for maintaining a pool of available connections. When the connection manager receives a request
for a new connection, it checks the pool for the available connections. If a connection is available, it
is returned, otherwise a new connection is created and returned, provided that the maximum pool
size has not been reached.
Answer C is incorrect. Database connection is a capability in computer science that permits client
software to converse with database server software. A connection is necessary to send commands
and receive answers.
Answer A is incorrect. The Connection object is used to create an open connection to the data
source. It is used to send queries and data to the data source and the information from the data
source to an Application. Each connection object is designed to effectively connect to its specific
data source. It does not store, update or fetch the data from the database.Answer D is incorrect. The LinqDataSource class is used to allow the use of LINQ in ASP.NET Web
pages by using the markup text to fetch and modify the data from a data object. It uses LINQ to SQL
to automatically generate the data commands. The data object can be either an in-memory data
collection or an object that displays data from a database. A user can fetch or alter the data without
writing SQL commands for each operation.