JDBC Interview Questions

JDBC

JDBC

  • What is JDBC?
  • What’s the JDBC 3.0 API?
  • Does the JDBC-ODBC Bridge support the new features in the JDBC 3.0 API?
  • Can the JDBC-ODBC Bridge be used with applets?
  • How do I start debugging problems related to the JDBC API?
  • What is new in JDBC 2.0?
  • How to move the cursor in scrollable resultset ?
  • How to update a resultset programmatically?
  • How can I use the JDBC API to access a desktop database like Microsoft Access over the network?
  • Are there any ODBC drivers that do not work with the JDBC-ODBC Bridge?
  • What causes the “No suitable driver” error?
  • Why isn’t the java.sql.DriverManager class being found?
  • How to insert and delete a row programmatically? (new feature in JDBC 2.0)
  • What are the two major components of JDBC?
  • What is JDBC Driver interface?
  • How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?
  • What are the common tasks of JDBC?
  • Why does the ODBC driver manager return ‘Data source name not found and no default driver specified Vendor: 0’
  • How to use JDBC to connect Microsoft Access?
  • What are four types of JDBC driver?
  • Which type of JDBC driver is the fastest one?
  • Are all the required JDBC drivers to establish connectivity to my database part of the JDK?
  • Is the JDBC-ODBC Bridge multi-threaded?
  • Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
  • What is the query used to display all tables names in SQL Server (Query analyzer)?
  • Why can’t I invoke the ResultSet methods afterLast and beforeFirst when the method next works?
  • How can I retrieve a String or other object type without creating a new object each time?
  • How many types of JDBC Drivers are present and what are they?
  • What is the fastest type of JDBC driver?
  • There is a method getColumnCount in the JDBC API. Is there a similar method to find the number of rows in a result set?
  • I would like to download the JDBC-ODBC Bridge for the Java 2 SDK, Standard Edition (formerly JDK 1.2). I’m a beginner with the JDBC API, and I would like to start with the Bridge. How do I do it?
  • If I use the JDBC API, do I have to use ODBC underneath?
  • Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
  • What is the best way to generate a universally unique object ID? Do I need to use an external resource like a file or database, or can I do it all in memory?
  • What happens when I close a Connection application obtained from a connection Pool? How does a connection pool maintain the Connections that I had closed through the application?
  • How do I insert a .jpg into a mySQL data base?
  • How can I know when I reach the last record in a table, since JDBC doesn’t provide an EOF method?
  • Where can I find info, frameworks and example source for writing a JDBC driver?
  • How can I create a custom RowSetMetaData object from scratch?
  • How does a custom RowSetReader get called from a CachedRowSet?