Which of the following is not true for a ResultSet?

Your project leader has asked you to improve the performance of JDBC connectivity by reusing objects in your Servlet's code. Which 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?

In order to accept input parameters at runtime, use the following JDBC interface:

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