Bookmark this page
Difficulty Level: AllBeginnerIntermediateExpert
Ques 1. What are the steps involved in establishing a JDBC connection?
Ques 2. How can you load the drivers?
Ques 3. What will Class.forName do while loading drivers?
Ques 4. How can you make the connection?
Ques 5. How can you create JDBC statements and what are they?
Ques 6. How can you retrieve data from the ResultSet?
Ques 7. What are the different types of Statements?
Ques 8. How can you use PreparedStatement?
Ques 9. What does setAutoCommit do?
Ques 10. How do you call a stored procedure from JDBC?
Ques 11. How do I retrieve warnings?
Ques 12. How can you move the cursor in scrollable result sets?
Ques 13. What’s the difference between TYPE_SCROLL_INSENSITIVE , and TYPE_SCROLL_SENSITIVE?
Ques 14. How to Make Updates to Updatable Result Sets?
Ques 15. What is JDBC Driver?
Ques 16. What is Connection pooling?
Ques 17. What are the different JDB drivers available?
Ques 18. What are the different JDB drivers available?
Ques 19. What is the fastest type of JDBC driver?
Ques 20. Is the JDBC-ODBC Bridge multi-threaded?
Ques 21. What is the advantage of denormalization?
Ques 22. How do you handle your own transaction?
Ques 23. What is JDBC? Describe the steps needed to execute a SQL query using JDBC.
Ques 24. How many different types of JDBC drivers are present? Discuss them.
Ques 25. What are the different driver types available in JDBC?
Ques 26. Is JDBC-ODBC bridge multi-threaded?
Ques 27. Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?