| Other JDBC Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| i have 1000 records in resultset, how to get first 100
records from resultset, because resultset fetch all 1000
records at a time? | HSBC | 7 |
| How to find the column count in resultset? | Wipro | 1 |
| How to get the data from a table into a buffer? | | 1 |
| What does Class.forName return? | IBM | 5 |
| Which Driver is preferable for using JDBC API in Applets? | | 1 |
| what is call level interface? | | 1 |
| In JDBC, All the API?s are interfaces? Where is the actual
implementation? | HCL | 2 |
| How is database middleware used to access legacy databases? | | 1 |
| r u used any design patterns in your project? | Wipro | 3 |
| What type of driver called is pure Java driver? | Vertex | 3 |
| Is there any limitation for no of statments executed with
in batchupdate? | HSBC | 1 |
| How many types of JDBC drivers are there and what are they? | | 1 |
| Explain the sequence of steps to connect to the database? | Wipro | 2 |
| How can you tune SQL statements? | Wipro | 1 |
| how to retrieve sql exceptions | Bosch | 1 |
| what is rowset? | Marlabs | 2 |
| Statement, PrepareStatement and Callable all these are
interfaces. Thought it is a interface how come we are
creating objects and calling methods("preparestatement()")
in it. In which class this method is defined.
Please let me know. Thanks in advance.
example:
PreparedStatement pre = con.prepareStatement(
"UPDATE COFFEES SET SALES = ? WHERE COF_NAME LIKE ?");
| | 2 |
| Difference between Generic Servlet and HTTP Servlet? | | 5 |
| what does the method Class.forName returns? | Siemens | 4 |
| How the information about db(database) can be retrieved? | | 3 |
| |
| For more JDBC Interview Questions Click Here |