Frequently asked JDBC interview questions

Frequently asked JDBC interview questions?

This list consists of important JDBC interview questions. These questions are repeatedly asked in many java and jdbc interviews. If you are person likely to take J2EE interview or jdbc interview it must be very useful to you.

1) What is JDBC?

2) What are four types of drivers available in JDBC and explain them in detail?

3) What is Statement?

4) What is prepared statement?

5) What is the difference between Statement and prepared statement?

6) What is Connection and How do you create connection in your program?

7) What is DataSource?

8) Have you used DataSource in your project? How do you create a data source?

9) What is connection pooling?

10) What is ResultSet?

11) Can you name few Exception classes in the JDBC package?

12) Which types of driver have you used in your project?

13) What is type of driver is faster?

14) Do we have do close the connection and how do you do that?

15) What is ResultSet meta data?

16) What is Database meta data?
17) Have you ever used stored procedure in your project together with JDBC? How do you call a stored your using JDBC?

18) What is Callable Statement? What is the use of a Callable Statement?

19) What is RowSet? Have you used RowSet?

20) What is the difference between JDBC 1.1 and JDBC 2?

21) What is latest available JDBC version?