Saved Bookmarks
This section includes 7 InterviewSolutions, each offering curated multiple-choice questions to sharpen your Current Affairs knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What does JDBC do? |
| Answer» | |
| 2. |
When do we use execute method in Java JDBC? |
| Answer» | |
| 3. |
Explain the two tier and three tier architecture of JDBC. |
| Answer» | |
| 4. |
What are the different types of Statements? How we can you use PreparedStatement. |
| Answer» | |
| 5. |
How can we retrieve data from the ResultSet? |
| Answer» | |
| 6. |
How are JDBC Statements used? |
| Answer» | |
| 7. |
Differentiate between TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE. |
| Answer» | |
| 8. |
What are the utilities of the CallableStatement? |
| Answer» | |
| 9. |
Explain how to Make Updates to the Updatable ResultSets. |
| Answer» | |
| 10. |
Name the types of JDBC drivers. |
| Answer» | |
| 11. |
Expalin the method of calling a stored procedure from JDBC. |
| Answer» | |
| 12. |
How do I find whether a parameter exists in the request object? |
| Answer» | |
| 13. |
What are the factors that the JDBC driver performance depends upon? |
| Answer» | |
| 14. |
How can you make a connection? |
| Answer» | |
| 15. |
What Class.forName does, while loading the drivers? |
| Answer» | |
| 16. |
How do we load the drivers? |
| Answer» | |
| 17. |
How can we move the cursor in a scrollable result set? |
| Answer» | |
| 18. |
What is SQLWarning and discuss the procedure of retrieving warnings? |
| Answer» | |
| 19. |
How do we call a stored procedure from JDBC? |
| Answer» | |
| 20. |
What is the function of setAutoCommit? |
| Answer» | |
| 21. |
Differentiate between a Statement and a PreparedStatement. |
| Answer» | |
| 22. |
Define PreparedStatement. |
| Answer» | |
| 23. |
What is a Statement? |
| Answer» | |
| 24. |
What is represented by the connection object? |
| Answer» | |
| 25. |
What does the JDBC Driver interface do? |
| Answer» | |
| 26. |
How a database driver can be loaded with JDBC 4.0 / Java 6? |
| Answer» | |
| 27. |
Describe how the JDBC application works. |
| Answer» | |
| 28. |
Explain the life cycle of JDBC. |
| Answer» | |
| 29. |
Briefly tell about the JDBC Architecture. |
| Answer» | |
| 30. |
How do Java applications access the database using JDBC? |
| Answer» | |
| 31. |
Name the new features added in JDBC 4.0. |
| Answer» | |
| 32. |
Discuss the significances of JDBC. |
| Answer» | |
| 33. |
How do I insert an image file (or other raw data) into a database? |
| Answer» | |
| 34. |
How can you load the drivers? |
| Answer» | |
| 35. |
What are DML and DDL? |
| Answer» | |
| 36. |
I have the choice of manipulating database data using a byte[] or a java.sql.Blob. Which has best performance? |
| Answer» | |
| 37. |
Explain basic steps in writing a Java program using JDBC. |
| Answer» | |
| 38. |
What is the benefit of having JdbcRowSet implementation? Why do we need a JdbcRowSet like wrapper around ResultSet? |
| Answer» | |
| 39. |
How can I manage special characters when I execute an INSERT query? |
| Answer» | |
| 40. |
What are the differences between setMaxRows(int) and SetFetchSize(int)? |
| Answer» | |
| 41. |
Is it possible to connect to multiple databases simultaneously? Using single statement can one update or extract data from multiple databases? |
| Answer» | |
| 42. |
What are types of JDBC drivers? |
| Answer» | |
| 43. |
What restrictions are placed on method overriding? |
| Answer» | |
| 44. |
Why Prepared Statements are faster? |
| Answer» | |
| 45. |
What does setAutoCommit do? |
| Answer» | |
| 46. |
What causes No suitable driver error? |
| Answer» | |
| 47. |
What are the types of statements in JDBC? |
| Answer» | |
| 48. |
Write a code to create a trigger to call a stored procedure |
| Answer» | |
| 49. |
How transient variable is different from volatile variable? |
| Answer» | |
| 50. |
What is a prefix function.write down a code to compute prefix function. |
| Answer» | |