JDBC Interview Questions

1. How differ servlet from its peer Technology?
2. what is savepoint?
3. Where to use which driver in JAVA?
4. What is metadata?
5. if 4 different drivers are loaded, & created 4 different statements calling diffener tables from same database,
how driver is recognized for each statement?
6. how many statements can be created with one connection?
7. which is the best driver among the 4 jdbc drivers?how can we load that driver?
8. why do we use prepared statement when already statement is present?
9. how can store images in a data base?
10. How to get the resultset of stroedProcedure?
11. Difference between Type-2 and Type-3 driver?
12. "select * from user" .what are the steps to take for execution of query in JDBC?
13. What is the purpose of setAutoCommit( )?
14. What is a transaction?
15. What is stored procedure. How do you create stored procedure
16. What is the difference between Resultset and Rowset
17. What is the difference between JDBC 1.0 and JDBC 2.0
18. What is Connection Pooling?
19. What are the three statements in JDBC & differences between them?
20. What is JDBC Driver interface?