JDBC Interview Questions

1) What Class.forName will do while loading drivers?

2) What are JDBC 3.0 new features?

3) What are the different JDBC drivers? Explain in brief?

4) Write the programming code for establishing JDBC Connection?

5) Write the programming code for 4th type driver?

6) What are the steps to connect to JDBC?

7) What are the different ResultSet types?

8) What do you mean by Batch Updates? Write the code for performing batch updates?

9) What do you understand by Multiple ResultSet? State with an example?

10) What is the difference between execute() ,executeUpdate() and executeQuery() ?

11) How to move the cursor in scrollable resultset? State with an example?

12) Write a code to update and delete a resultset programmatically?

13) What is JDBC Connection pool?

14) Why you need JDBC if ODBC is available?

15) Can we establish the connection with ODBC itself?

16) What is the necessity of JDBC in JDBC-ODBC bridge?

17) Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?

18) Is the JDBC-ODBC Bridge multi-threaded?

19) What are the different statements in JDBC?

20) Write the programming code to create dynamic tables?

21) In which interface the methods commit() and rollback() savepoint() defined?

22) What is ResultMetaData? State with an example?

23) What is Database MetaData? State with an example?

24) What are SQL warnings?

25) Write the programming code for executing stored procedure and trigger?