Assignment 2
1. What is JDBC? Explain the types of JDBC drivers?
2. Explain Thick and Thin driver. Comment on selection of driver. Write code
snippet for each type of JDBC connection.
3. Explain Statement Interface with appropriate example.
4. Explain Prepared Statement with example.
5. Explain Callable Statement with example.
6. Differentiate Statement, Prepared Statement and Callable Statement.
7. Explain JDBC Architecture.
8. Explain methods of ResultSet Interface.
9. Differentiate executeQuery(), executeUpdate() and execute() with
appropriate example.
10. Explain Resultset Type and Concurrency.
11. Explain ResultsetMetaData Interface with Example.
12. Explain DatabaseMetaData Interface with Example.
13. Explain Transaction Management in JDBC with appropriate example.
14. Explain Transaction Isolation Level in JDBC.
15. Explain Batch Processing in JDBC.