2012 Latest JDBC Interview Question

 

1.       What are the classes you used in JDBC ?

2.       ACID properties

3.       What is the purpose of setAutoCommit().

4.       What are batch updates and how you will write it?

5.       What are the steps for connecting to the database using JDBC.

6.       What is Connection Pooling? How do you implement Connection Pooling?

7.       What Class.forName() method will do.?

8.      What happens if I close the connection twice?

9.       What are the standard isolation levels defined by JDBC? (TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE)

10.   How do I receive a ResultSet from a stored procedure?

11.    Types of Drivers

Differences

1.       Statement, PreparedStatement, Callable Statement

2.       execute, executeQuery, executeUpdate

3.       Resultset and Rowset

4.       JDBC 2.0 and JDBC 2.1

5.       Why cannot java.util.Date match with java.sql.Date?