Due to the print book page limit, we cannot inlcude all good CheckPoint questions in the physical book. The CheckPoint on this Website may contain extra questions not printed in the book. The questions in some sections may have been reordered as a result. Nevertheless, it is easy to find the CheckPoint questions in the book on this Website. Please send suggestions and errata to Dr. Liang at y.daniel.liang@gmail.com. Indicate the book, edition, and question number in your email. Thanks!

Chapter 35 Check Point Questions

Section 35.3
▼35.3.1
What is batch processing in JDBC? What are the benefits of using batch processing?
▼35.3.2
How do you add an SQL statement to a batch? How do you execute a batch?
▼35.3.3
Can you execute a SELECT statement in a batch?
▼35.3.4
How do you know whether a JDBC driver supports batch updates?
Section 35.4
▼35.4.1
What is a scrollable result set? What is an updatable result set?
▼35.4.2
How do you create a scrollable and updatable ResultSet?
▼35.4.3
How do you know whether a JDBC driver supports a scrollable and updatable ResultSet?
Section 35.5
▼35.5.1
What are the advantages of RowSet?
▼35.5.2
What are JdbcRowSet and CachedRowSet? What are the differences between them?
▼35.5.3
How do you create a JdbcRowSet and a CachedRowSet?
▼35.5.4
Can you scroll and update a RowSet? What method must be invoked to write the changes in a CachedRowSet to the database?
▼35.5.5
Describe the handlers in RowSetListener.
Section 35.6
▼35.6.1
How do you store images into a database?
▼35.6.2
How do you retrieve images from a database?
▼35.6.3
Does Oracle support the SQL3 BLOB type and CLOB type? What about MySQL and Access?