Which of the following options enables the client to read and write data and create Structured
Query Language objects in the database?
A.
Connection pooling
B.
Connection object
C.
Transaction object
D.
Database connection
Explanation:
A database connection enables the client to read and write data and create Structured Query
Language objects in the database. 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. Connections are a key theory in data-centric programming.
Some DBMS engines need considerable time to connect to connection pooling to improve
performance. No command can be performed against a database without an “open and available”
connection to it.Answer A is incorrect. 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 connectionmanager 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 connectionsAnswer 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 databaseAnswer C 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.