JDBC-1

Which of the following encapsulates an SQL statement which is passed to the database to be parsed, compiled, planned and executed?

• DriverManager

• JDBC driver

• Statement

• Connection

Which of the following type of JDBC driver, is also called Type 3 JDBC driver?

• JDBC-ODBC Bridge plus ODBC driver

• JDBC-Net, pure Java driver

• JDBC-Net, pure Java driver

• JDBC-Net, pure Java driver

Which of the following is correct about JDBC?

• The JDBC API provides the abstraction and the JDBC drivers provide the implementation.

• The JDBC API provides the abstraction and the JDBC drivers provide the implementation.

• Both of the above.

• Both of the above.

Which of the following is not a component/class of JDBC API?

• ConnectionPool

• SQLException

• Statement

• ResultSet

Which of the following holds data retrieved from a database after you execute an SQL query using Statement objects?

• JDBC driver

• ResultSet

• Connection

• Statement

Which method is used to establish the connection with the specified url in a Driver Manager class?

• public static Connection getConnection(String url)

• public static void registerDriver(Driver driver)

• public static void deregisterDriver(Driver driver)

• None of the above

Which kind of driver converts JDBC calls into calls on the client API for Oracle, Sybase, Informix, IBM DB2, or other DBMS?

• JDBC-ODBC bridge plus ODBC driver

• JDBC-Net pure Java driver

• Native-API partly-Java driver

• Native-protocol pure Java driver

Which is used to call the stored procedures and functions?

• CallableStatement Interface

• PreparedStatement Interface

• Statement

• All the above

How many steps are used to connect any java application using JDBC?

• 6

• 4

• 9

• 3

Which JDBC drivers will run your program?

• The JDBC-ODBC bridge

• The JDBC driver test suite

• The JDBC driver manager

• None of the above