Home > Java Programming > Quizzes > JDBC Fundamentals Test
JDBC Fundamentals Test
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 35% Most missed: “True or False?”
JDBC Fundamentals Test
Time left 00:00
25 Questions

1. If you are going to use Static SQL statements at runtime - the best JDBC interface to use is:
2. At the end of the JDBC program - it is explicity required to close al the connections to the database? True or False
3. In the syntax {ts 'yyyy-mm-dd hh:mm:ss'} - ts stands for
4. The Class.forname() method is used to:
5. The _______ of a ResultSet object determines what level of update functionality is supported.
6. If the ResultSet type is TYPE_FORWARD_ONLY - it implies:
7. Which of the following parameters is used by the Preparedstatement object?
8. JDBC API uses which drivers to connect to the database?
9. The most common exception you'll deal with JDBC:
10. True or False? SQLWarning objects are a subclass of SQLException.
11. A ______ RowSet object makes a connection to a data source only to read or write data based on a ResultSet object.
12. _______ driver type(s) are for use over communication networks.
13. A ______ is not contained in an SQLException.
14. True or False? JDBC will work with many different database management systems.
15. The _______ method adds SQL commands to the list associated with a Statement object.
16. In order to accept input parameters at runtime - use the following JDBC interface:
17. A _______ is used to access the data in a ResultSet.
18. In the command jdbc:derby:testdb;create=true - testdb stands for
19. {fn length('Friday')} will return
20. True or False? MySQL and Java DB support the ARRAY SQL data type.
21. _____ will create a RowSet object.
22. Which of the following is not an overloaded DriverManager.getConnection () method?
23. True or False? If executing a Statement object many times - a PreparedStement object will reduce execution time.
24. Transaction_read_committed (one example of transaction isolation level) does not alow:
25. If a database operation fails - JDBC raises an: