JDBC Interview Questions

1. What is save point?
2. What’s the JDBC 3.0 API?
3. What is new in JDBC 2.0?
4. What is Connection Pooling?
5. What is JDBC Driver interface?
6. What is optimistic concurrency?
7. Explain about the main method?
8. What packages are used by JDBC?
9. How many JDBC drivers are there?
10. What does setFetchSize () really do?
11. How can you use Prepared Statement?
12. Prepared Statement or Batch Updates?
13. How can you create JDBC statements?
14. What Class for Name ( ) method will do?
15. What are the different types of Statements?
16. What causes the “No suitable driver” error?
17. How to call a Stored Procedure from JDBC?
18. What is the protocol is used in type4 driver?
19. How differ Servlet from its peer Technology?
20. What are the different types of JDBC drivers?
21. Which type of JDBC driver is the fastest one?
22. What are the two major components of JDBC?
23. How can you retrieve data from the Result Set?
24. How to move the cursor in scrollable result set?
25. Difference between local and global transaction?
26. How to Make Updates to Updatable Result Sets?
27. Explain in detail about JDBC and its general features?
28. What is thin driver and thick driver. Why it is called so?
29. Why isn’t the java.sql.Driver Manager Class being found?
30. What is the difference between JDBC 1.0 and JDBC 2.0?
31. What are the steps involved in establishing a connection?
32. Explain Basic Steps in writing a Java program using JDBC?
33. How do you determine the sensitivity of the Result Set object?
34. Explain what should be done when a SQL exception is raised?
35. What is the difference between client and server database cursors?
36. What does normalization mean for java.sql.Date and java.sql.Time?
37. What are the three statements in JDBC & differences between them?
38. Why do I have to reaccess the database for Array, Blob, and Clob data?
39. Why do I get Unsatisfied Link Error when I try to use my JDBC driver?
40. How does a custom Row Set Reader get called from a Cached Row Set?
41. What are the different classes through which JDBC represents statements?
42. Which is the preferred collection class to use for storing database result sets?
43. How can I get or redirect the log used by Driver Manager and JDBC drivers?
44. Which of the following allows non repeatable read in JDBC, connection class?
45. Is possible to open a connection to a database with exclusive mode with JDBC?
46. What is the query used to display all tables names in SQL Server (Query analyzer)?
47. How can I retrieve a String or other object type without creating a new object each time?
48. How can I use the JDBC API to access a desktop database like Microsoft Access over the network?
49. Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
50. State true or false can we retrieve a whole row of data at once, instead of calling an individual Result Set.get XXX method for each column?