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?

You executed a query to retrieve 40 products from the database and obtained a scrollable ResultSet named 'scrollrs'. You started scrolling the ResultSet as follows: scrollrs.next(); scrollrs.absolute(-10); scrollrs.relative(-6); At which row number is the cursor currently located?

ResultSet objects follow index patterns of:

What should the syntax be to establish a connection with a Database?

Which method will you use to execute INSERT, UPDATE and DELETE SQL statements?

You want to start a transaction for bank account processing. Which method will you execute on the Connection object to begin it?

The default mode when a connection is created is auto-commit mode.

A transaction is closed when close() is called on the Connection object.

JDBC is an API to access relational databases, spreadsheets, and flat files.

To close existing database connections, you should call

JDBC API uses which drivers to connect to the database?