JDBC_Objective_Exam_2

Which class or interface contains the transaction control methods setAutoCommit(),commit(), and rollback()?

• Statement

• Connection

• ResultSet

• none of the above

Which character is used to represent an input parameter in CallableStatement?

• %-Percentage symbol

• #-hash

• ?-Question Mark

• *-star

When the message “No Suitable Driver” occurs ?

• When the type 4 driver is used?

• When the driver is not registered by Class.forName() method

• When the JDBC database URL passed is not constructed properly

• When the user name, password and the database does not match

What does setAutoCommit(false) do?

• commits transaction after each query

• explicitly commits transaction

• does not commit transaction automatically after each query

• never commits transaction

For inserting data into database Which Interface is used in JDBC Program?

• Statement

• PreparedStatement

• CallableStatement

• ParameterisedStatement

Write the code for loading a Type-4 driver in JDBC program.

What are different Exceptions thrown in JDBC?

Write the statement for establishing data base Connection in JDBC.

Which jar file should be set in the classpath for loading jdbc driver?

• odbc.jar

• ojdbc14.jar

• ojdbc23.jar

• jdbco20.jar

Write a JDBC Program to retrieve the Student data from Student Table?