JDBC Quiz

1) What are the major components of the JDBC?

• DriverManager, Driver, Connection, Statement, and ResultSet

• DriverManager, Driver, Connection, and Statement

• DriverManager, Statement, and ResultSet

• DriverManager, Connection, Statement, and ResultSet

Select the packages in which JDBC classes are defined?

• jdbc and javax.jdbc

• rdb and javax.rdb

• jdbc and java.jdbc.sql

• sql and javax.sql

4) What is the correct sequence to create a database connection?

i. Import JDBC packages.

ii. Open a connection to the database.

iii. Load and register the JDBC driver.

iv. Execute the statement object and return a query resultset.

v. Create a statement object to perform a query.

vi. Close the resultset and statement objects.

vii. Process the resultset.

viii. Close the connection.

• i, ii, iii, v, iv, vii, viii, vi

• i, iii, ii, v, iv, vii, vi, viii

• ii, i, iii, iv, viii, vii, v, vi

• i, iii, ii, iv, v, vi, vii, viii

Parameterized queries can be executed by?

• ParameterizedStatement

• PreparedStatement

• CallableStatement and Parameterized Statement

• All kinds of Statements

Which of the following is not a valid statement in JDBC?

• Statement

• PreparedStatement

• QueryStatement

• CallableStatement

Stored procedure can be called by using the ????..?

• CallableStatement

• Statement

• CalledStatement

• PreparedStatement

Which of the following driver is the fastest one?

• JDBC-ODBC Bridge Driver

• Native API Partly Java Driver

• Network Protocol Driver

• JDBC Net Pure Java Driver

What does setAutoCommit(false) do?

• commits transaction after each query

• explicitly commits transaction

• does not commit transaction automatically after each query

• never commits transaction

Which of the following is used to call stored procedure?

• Statement

• PreparedStatement

• CallableStatment

• CalledStatement

What must be the first characters of a database URL?

• db,

• db:

• jdbc,

• jdbc: