JDBC 2.1 Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 29% • Most missed: “You have obtained a scrollable ResultSet named 'srs' by executing a query. Which…”
JDBC 2.1 Test
Time left 00:00
25 Questions

1. SQLWarning object deals with database access warnings. It is a subclass of:
2. Which JDBC driver is considered best in terms of performance and efficiency?
3. Which of the following is not true for a ResultSet?
4. ResultSet objects follow index patterns of:
5. Transactions have a property called atomicity - which means:
6. Please select all the correct options. JDBC Driver Manager is:
7. Which type of statement object will you use to execute a stored procedure?
8. Java Database Connectivity (JDBC) is a:
9. Your project leader has asked you to improve the performance of JDBC connectivity by reusing objects in your Servlet's code. Which of the following is an appropriate solution?
10. SQLException has a method - which provides the feature of chaining or encapsulation of additional Exception objects. Identify the method from the following:
11. How do you register a JDBC driver?
12. Which of the following methods eliminates the need to call wasNull() method to handle null database fields?
13. JDBC is based on:
14. You have obtained a scrollable ResultSet named 'srs' by executing a query. Which of the following methods will you use to verify the position of the cursor?
15. Which of the following JDBC methods is used for retrieving large text strings?
16. How will you create a new instance of a JDBC driver explicitly?
17. boolean resultvar=stmt.execute(sql);
18. You need to use a third party driver for establishing a connection with the database. The subprotocol is "webx" and the DSN is "webdsn". What is the syntax of the URL?
19. Name the interface you will use to retrieve the underlying structure of the query result:
20. You have obtained a ResultSet object named 'rs' after executing the following query: SELECT * FROM CUSTOMER - Which loop can you use to return all the records in the ResultSet?
21. You want to execute a CallableStatement named 'cs'. It is expected to return multiples results. Which of the following methods will you choose?
22. Which of the following JDBC methods is used for retrieving large binary objects?
23. A process allows you to group multiple SQL statements. Commit or Rollback can be performed on the group together. This process is known as:
24. You have to handle an erroneous situation in a transaction. Which method comes handy in this case?
25. You are developing a shopping cart for your client. Where would you like to put your business logic?

⚡ Recently practiced quizzes in this topic
Live quiz activity
Maven Quiz JSP 2.0 Test Java Test v3 Eclipse Quiz J2ME Test
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.