Jdbc Interview Questions And Answers

1. Are all the required JDBC drivers to establish connectivity to my database part of the JDK?
2. Are the code examples from the JDBC API Tutorial and Reference, Second Edition available online?
3. Are there any ODBC drivers that do not work with the JDBC-ODBC Bridge?
4. Can I get information about a ResultSet's associated Statement and Connection in a method without having or adding specific arguments for the Statement and Connection?
5. Can I set up a conection pool with multiple user IDs? The single ID we are forced to use causes probelems when debugging the DBMS.
6. Can I use JDBC to execute non-standard features that my DBMS provides?
7. Can I use the JDBC-ODBC bridge driver in an applet?




-- Useful EBooks --

How To Naturally Regrow Lost Hair




8. Can ResultSets be passed between methods of a class? Are there any special usage How can I convert a java array to a java.sql.Array?
9. Can the JDBC-ODBC Bridge be used with applets?
10. Can you scroll a result set returned from a stored procedure?...
11. Connecting to a database through the Proxy I want to connect to remote database using a program that is running in the local network behind the proxy. Is that possible?
12. Could we get sample code for retrieving more than one parameter from a
13. DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality. What can I do?
14. Detecting Duplicate Keys I have a program that inserts rows in a table ...
15. Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
16. Does the JDBC-ODBC Bridge support the new features in the JDBC 3.0 API?
17. Does the database server have to be running Java or have Java support in order for my remote JDBC client app to access the database?
18. How can I connect from an applet to a database on the server?
19. How can I connect to an Excel spreadsheet file using jdbc?
20. How can I connect to an Oracle database not on the web server from an untrusted applet?
21. How can I create a custom RowSetMetaData object from scratch?
22. How can I determine the isolation levels supported by my DBMS?
23. How can I determine where a given table is referenced via foreign keys?
24. How can I determine whether a Statement and its ResultSet will be closed on a
25. How can I get data from multiple ResultSets?
26. How can I get information about foreign keys used in a table?
27. How can I get or redirect the log used by DriverManager and JDBC drivers?
28. How can I insert images into a Mysql database?
29. How can I insert multiple rows into a database in a single transaction?
30. How can I instantiate and load a new CachedRowSet object from a non-JDBC source?
31. How can I investigate the parameters to send into and receive from a database stored procedure?
32. How can I investigate the physical structure of a database?
33. How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?
34. How can I make batch updates using JDBC?
35. How can I pool my database connections so I don't have to keep reconnecting to the database?
36. How can I retrieve a String or other object type without creating a new object each time?
37. How can I retrieve string data from a database in Unicode format?
38. How can I tell if my JDBC driver normalizes java.sql.Date and java.sql.Time objects?
39. How can I use the JDBC API to access a desktop database like Microsoft Access over the network?
40. How can I write to the log used by DriverManager and JDBC drivers?
41. How can resultset records be restricted to certain rows?
42. How do I check in my code whether a maximum limit of database connections have been reached?
43. How do I check what table types exist in a database?




-- Useful EBooks --

Weird Tricks to Lose Your Abdominal Fat




44. How do I check what table-like database objects (table, view, temporary table,
45. How do I create a database connection?
46. How do I create a java.sql.Date object?
47. How do I create a java.sql.Time object?
48. How do I create an updatable ResultSet?
49. How do I disallow NULL values in a table?
50. How do I display and parse a date?
51. How do I execute stored procedures?
52. How do I extract SQL table column type information?
53. How do I extract a BLOB from a database?
54. How do I extract the SQL statements required to move all tables and views from an existing database to another database?
55. How do I find all database stored procedures in a database?
56. How do I get runtime information about the JDBC Driver?
57. How do I implement a RowSetReader? I want to populate a CachedRowSet myself and the documents specify that a RowSetReader should be used. The single method accepts a RowSetInternal caller and returns void. What can I do in the readData method?
58. How do I insert a .jpg into a mySQL data base?
59. How do I insert an image file (or other raw data) into a database?
60. How do I receive a ResultSet from a stored procedure?
61. How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getX.X.X method for each column?
62. How do I set properties for a JDBC driver and where are the properties stored?
63. How do I start debugging problems related to the JDBC API?
64. How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?
65. How do you handle your own transaction ?
66. How does a custom RowSetReader get called from a CachedRowSet?
67. How does one get column names for rows returned in a ResultSet?
68. How does the Java Database Connectivity (JDBC) work?
69. How many types of JDBC Drivers are present and what are they?
70. How to insert and delete a row programmatically? (new feature in JDBC 2.0)
71. How to move the cursor in scrollable resultsets?(new feature in JDBC 2.0)
72. How to update a resultset programmatically? (new feature in JDBC 2.0)
73. I have an application that queries a database and retreives the results into a
74. I need to have result set on a page where the user can sort on the column headers. Any ideas?
75. 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?
76. If I use the JDBC API, do I have to use ODBC underneath?
77. Is is possible to open a connection to a database with exclusive mode with JDBC?
78. Is the JDBC-ODBC Bridge multi-threaded?
79. Is there a practical limit for the number of SQL statements that can be added to an instance of a Statement object
80. JTable ...
81. Many connections from an Oracle8i pooled connection returns statement closed. I am using import oracle.jdbc.pool.* with thin driver. If I test with many simultaneous connections, I get an SQLException that the statement is closed. How can I overwrite blob data in an Oracle database? ...
82. Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
83. The java.sql package contains mostly interfaces. When and how are these
84. There is a method getColumnCount in the JDBC API. Is there a similar method to find the number of rows in a result set?
85. Update fails without blank padding. Alhough a particular row is present in the database for a given key, executeUpdate() shows 0 rows updated and, in fact, the table is not updated. If I pad the Key with spaces for the column length (eg if the key column is 20 characters long, and key is msgID, length 6, I pad it with 14 spaces), the update then works!!! Is there any solution to this problem without padding?What isolation level is used by the DBMS when inserting, updating and
86. Whan 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?
87. What JDBC objects generate SQLWarnings?
88. What are four types of JDBC driver?
89. What are stored procedures?
90. What are the common tasks of JDBC?
91. What are the components of the JDBC URL for Oracle's "thin" driver and how do I use them?
92. What are the considerations for deciding on transaction boundaries?
93. What are the different JDB drivers available?
94. What are the standard isolation levels defined by JDBC?
95. What are the steps required to execute a query in JDBC?
96. What are the two major components of JDBC?
97. What causes the "No suitable driver" error?
98. What does Class.forName return?
99. What does it mean to "materialize" data?
100. What does normalization mean for java.sql.Date and java.sql.Time?
101. What does setFetchSize() really do?
102. What driver should I use for scalable Oracle JDBC applications?
103. What is Connection pooling?
104. What is Connection?
105. What is DML?
106. What is DriverManager ?
107. What is JDBC Driver ?
108. What is JDBC Driver interface?
109. What is JDBC?
110. What is JDO?
111. What is Metadata and why should I use it?
112. What is a JDBC 2.0 DataSource?
113. What is a ResultSet ?
114. What is an SQL Locator?
115. What is cold backup, hot backup, warm backup recovery?
116. What is new in JDBC 2.0?
117. What is optimistic concurrency?
118. What is pessimistic concurrency?
119. What is the JDBC syntax for using a date literal or variable in a standard Statement?
120. What is the JDBC syntax for using a literal or variable in a standard Statement?
121. What is the advantage of denormalization?
122. What is the advantage of using a PreparedStatement?
123. What is the best way to generate a universally unique object ID? Do I need to
124. What is the difference between client and server database cursors?
125. What is the difference between setMaxRows(int) and SetFetchSize(int)? Can either reduce processing time?
126. What is the fastest type of JDBC driver?
127. What is the most efficient method of replicating data betwen databases using JDBC?
128. What is the query used to display all tables names in SQL Server (Query analyzer)?
129. What is the significance of DataBaseMetaData.tableIndexStatistics? How to
130. What scalar functions can I expect to be supported by JDBC?
131. What types of DataSource objects are specified in the Optional Package?
132. What's the JDBC 3.0 API?
133. What's the best way, in terms of performance, to do multiple insert/update statements, a PreparedStatement or Batch Updates?
134. What's the fastest way to normalize a Time object?
135. When I intersperse table creation or other DDL statements with DML statements ....
136. When an SQL select statement doesn't return any rows, is an SQLException thrown?
137. Where can I find info, frameworks and example source for writing a JDBC driver?
138. Which Java and java.sql data types map to my specific database types?
139. Which is the preferred collection class to use for storing database result sets?
140. Which type of JDBC driver is the fastest one?
141. Why can't I invoke the ResultSet methods afterLast and beforeFirst when the method next works?
142. Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?
143. Why do I have to reaccess the database for Array, Blob, and Clob data?
144. 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?
145. Why doesn't JDBC accept URLs instead of a URL string?
146. Why isn't the java.sql.DriverManager class being found?
147. Why should I consider optimistic versus pessimistic approaches to database
148. alias) are present in a particular database?