Vendor JDBC Driver Implementations | 1Z0-809 Exam | Oracle Certification

Vendor JDBC Driver Implementations

Question

For which three objects must a vendor provide implementations in its JDBC driver? (Choose three.)

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D. E. F. G.

CDE.

Database vendors support JDBC through the JDBC driver interface or through the ODBC connection.

Each driver must provide implementations of java.sql.Connection, java.sql.Statement, java.sql.PreparedStatement, java.sql.CallableStatement, and java.sql.Re sultSet.

They must also implement the java.sql.Driver interface for use by the generic java.sql.DriverManager interface.

When a vendor provides a JDBC (Java Database Connectivity) driver, there are several objects that must be implemented in the driver to provide database access functionality. Here are the three objects that a vendor must provide implementations for:

  1. Connection - This object represents a connection to a database. It is used to create Statement and PreparedStatement objects, as well as to control transactions and manage connections.

  2. Statement - This object is used to execute SQL statements and return the results. There are two types of Statement objects: simple and prepared.

  3. ResultSet - This object represents a set of results returned by an executed SQL statement. It allows you to retrieve and manipulate the data returned by the query.

It is important to note that while the other objects listed (Time, Date, SQLException, and DriverManager) are important in the JDBC API, they are not required to be implemented by the vendor. The DriverManager, for example, is a class provided by the Java standard library, not the JDBC driver itself.