InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What is difference between JDBC, JNDI and Hibernate? |
| Answer» | |
| 2. |
How to Connect to an Excel Spreadsheet using JDBC in Java? |
| Answer» | |
| 3. |
What is Metadata and why should you use it? |
| Answer» | |
| 4. |
Which isolation level prevents dirty read in JDBC, connection class? |
| Answer» | |
| 5. |
What is a "dirty read"? |
| Answer» | |
| 6. |
What are different types of RowSet objects? |
| Answer» | |
| 7. |
What is a RowSet? |
| Answer» | |
| 8. |
What are the differences between setMaxRows(int) and SetFetchSize(int)? |
| Answer» | |
| 9. |
What we set the attribute Concurrency in ResultSet? |
| Answer» | |
| 10. |
When you say Class.forName() loads the driver class, does it mean it imports the driver class using import statement? |
| Answer» | |
| 11. |
What does the Class.forName("MyClass") do? |
| Answer» | |
| 12. |
Suppose the SELECT returns 1000 rows, then how to retrieve the first 100 rows, then go back and retrieve the next 100 rows? |
| Answer» | |
| 13. |
Out of String or a java.sql.Clob, which has best performance when used to manipulate data from database? |
| Answer» | |
| 14. |
Out of byte[] or a java.sql.Blob, which has best performance when used to manipulate data from database? |
| Answer» | |
| 15. |
How do you implement connection pooling? |
| Answer» | |
| 16. |
What is Connection Pooling? |
| Answer» | |
| 17. |
Resultset is an interface, how does it support rs.Next()? |
| Answer» | |
| 18. |
What is the use of blob, clob datatypes in JDBC? |
| Answer» | |
| 19. |
Why do you have to close database connections in Java? |
| Answer» | |
| 20. |
What is the difference between execute, executeQuery, executeUpdate? |
| Answer» | |
| 21. |
When will you get the message "No Suitable Driver"? |
| Answer» | |
| 22. |
How will you insert multiple rows into a database in a single transaction? |
| Answer» | |
| 23. |
What is a transaction? |
| Answer» | |
| 24. |
What is JDBC SQL escape syntax? |
| Answer» | |
| 25. |
What is a Stored Procedure and how do you call it in JDBC? |
| Answer» | |
| 26. |
What are the steps followed to create a batch process? |
| Answer» | |
| 27. |
Why would you use a batch process? |
| Answer» | |
| 28. |
What are SQL warnings? |
| Answer» | |
| 29. |
What is SavePoint? Give an example. |
| Answer» | |
| 30. |
Why will you set auto commit mode to false? |
| Answer» | |
| 31. |
What does setAutoCommit do? |
| Answer» | |
| 32. |
How do you handle SQL NULL values in Java? |
| Answer» | |
| 33. |
What causes "No suitable driver" error? |
| Answer» | |
| 34. |
How does JDBC handle the data types of Java and database? |
| Answer» | |
| 35. |
How do you update a result set? |
| Answer» | |
| 36. |
How can you view a result set? |
| Answer» | |
| 37. |
How cursor works in scrollable result set? |
| Answer» | |
| 38. |
Is there a practical limit for the number of SQL statements that can be added to an instance of a Statement object? |
| Answer» | |
| 39. |
How can I determine whether a Statement and its ResultSet will be closed on a commit or rollback? |
| Answer» | |
| 40. |
How do you create a connection object? |
| Answer» | |
| 41. |
In real time project which driver did you use? |
| Answer» | |
| 42. |
What do you mean by fastest type of JDBC driver? |
| Answer» | |
| 43. |
What are the benefits of JDBC 4.0? |
| Answer» | |
| 44. |
How do you register a driver?There are 2 approaches for registering the Driver |
| Answer» | |
| 45. |
What is difference between statement and prepared statement? |
| Answer» | |
| 46. |
What are the different types of JDBC Statements? |
| Answer» | |
| 47. |
What is the design pattern followed by JDBC? |
| Answer» | |
| 48. |
What are the standard isolation levels defined by JDBC? |
| Answer» | |
| 49. |
Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection? |
| Answer» | |
| 50. |
Which type of JDBC driver is the fastest one? |
| Answer» | |