JDBC

Which of the following tasks are associated with JDBC library?

• Making a connection to a database.

• Creating SQL or MySQL statements.

• Executing SQL or MySQL queries in the database.

• All of these

Expand JDBC

_____________ interface handles the communications with the database server

• DriverManager

• Driver

• Statement

• None of these

___________ interface with all methods for contacting a database.

• ResultSet

• Statement

• Connection

• Driver

The third step involved in JDBC application is ____________

• Execute Query

• Establish Connection

• importing packages

• Register the Driver

In Type 2 Driver, JDBC API calls are converted into native _____________ API calls, which are unique to the database

• C/C++

• Java

• JavaScript

• Visual Programming

Type 4 Driver is also called as ___________

_____________ driver talks with server-side middleware which then talks to the database

• Type 1

• Type 2

• Type 3

• Type 4

_____________ should be imported to use SQL statements

The most common approach to register a driver is to use Java's ___________method.