Which of the following is a cache of database connections maintained by a database so that the
connections can be reused when the database receives future requests for data?
A.
Database connection
B.
Connection object
C.
Connection pool
D.
Transaction object
Explanation:
A connection pool is a cache of database connections maintained by a database so that the
connections can be reused when the database receives future requests for data. A connection pool
is used to enhance the performance of executing commands on the database. It is used to open and
maintain a database connection for each user. In a connection pool, when a connection is created, it
is placed in the pool and it is used again so that a new connection does not need to be established. If
all the connections are being used, a new connection is made and is added to the pool. Connection
pool also cuts down the amount of time a user must wait to establish a connection to the database.
Answer B 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. A transaction object is used for allowing multiple SQL statements to be
processed as a group. Each transaction object represents the DTC transaction. The transaction object
exists for the life of the transaction. It should be released when the transaction completes. It is used
to begin, commit, or roll back a transaction.
Answer A 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.