JDBC IQ

1. How does JAVA interact with databases?
2. Can we interact with non-relational sources using JDBC?
3. Can you explain in depth the different sections in JDBC?
4. Can you explain in short how you go about using JDBC API in code?
5. How do you handle SQL exceptions?
6. If there is more than one exception in SQLException” class how to go about displaying
it?
7. Explain Type1, Type2, Type3 and Type4 drivers in JDBC?
8. What are the advantages and disadvantages of using JDBC-ODBC bridge driver?
9. What are the advantages and disadvantages of using Native-API/ Partially Java Driver?
10.What are the advantages and disadvantages of using Net-Protocol/ All-Java driver?
11. What are the advantages and disadvantages of using Native-protocol/ All-Java driver?
12. Define meta-data?
13. What is DatabaseMetaData?
14. Can you explain “ConnectionFactory” class?
15. I want to display tables of a database how do I do it?
16. Define “ResultSetMetaData”?
17. What is the difference between “ResultSet” and “RowSet”?
18. Can “ResultSet” objects be serialized?
19. Can you explain “ResultSet”, “RowSet”, “CachedRowset”, “JdbcRowset” and
“WebRowSet” relation ship?
20. what are the different types of resultset?
21. Explain the concept of “PreparedStatement “statement interface?
22. What’s the difference between “Statement” and “PreparedStatement”?
23. How can we call stored procedure using JDBC?
24. Can you explain “CallableStatement” interface in detail?
25. How do you get a resultset object from stored procedure?
26. How can we do batch updates using “CallableStatement” Interface?
27. Define transactions?
28. what is ACID in transaction?
29. what are the four essential properties of a transaction?
30. Explain concurrency and locking?
31. What are different types of locks?
32. What are the different types of levels of resource on which locks can be placed?
33. Define lock escalation?
34. What is Table level and Row level locking?
35. What are the problems that can occur if you do not implement locking properly?
36. What are different transaction levels?
37. Twist: - what are different types of locks?
38. What is difference between optimistic and pessimistic locking?
39. What are deadlocks?
40. How can we set transaction level through JDBC API?
41. Can you explain transaction control in JDBC?
42. What are Savepoints in a transaction?