What is the purpose of the DriverManager class in JDBC?Question 2Answera.Establishing a connection to the databaseb.Executing SQL queriesc.Retrieving data from the databased.Closing database connections

The DriverManager class in JDBC (Java Database Connectivity) serves several key purposes:

a. Establishing a connection to the database: DriverManager is a class in java.sql package that controls a set of JDBC drivers. When we first load a driver, it registers itself with the DriverManager. When opening a database, DriverManager will connect to this database by choosing an appropriate driver from the set of registered JDBC drivers.

b. Executing SQL queries: DriverManager does not directly execute SQL queries. It is responsible for managing the JDBC drivers and establishing connections. The execution of SQL queries is typically handled by Statement objects, which can be created via the Connection object that DriverManager helps establish.

c. Retrieving data from the database: Similar to executing SQL queries, DriverManager does not directly retrieve data from the database. Once a connection is established, we can create Statement, PreparedStatement, and CallableStatement objects, which can be used to execute SQL queries and retrieve data.

d. Closing database connections: DriverManager does not close database connections. It is the responsibility of the user to close the Connection object when finished. This can be done by calling the close() method on the Connection object.

The DriverManager class in JDBC serves several purposes:

a. Establishing a connection to the database: DriverManager is a class in java.sql package that manages a list of database drivers. It is used to establish a connection between the Java program and the database.

b. Executing SQL queries: DriverManager does not directly execute SQL queries. It provides a connection using which Statement and PreparedStatement interfaces can be created to execute SQL queries.

c. Retrieving data from the database: DriverManager itself does not retrieve data from the database. It provides a connection using which Statement, PreparedStatement, and ResultSet can be created to fetch data from the database.

d. Closing database connections: DriverManager does not close database connections. It is the responsibility of the user to close the connection once the interaction with the database is finished. This can be done by calling the close() method of the Connection interface.