How will you create a new instance of a JDBC driver explicitly?

You want to execute a CallableStatement named 'cs'. It is expected to return multiples results. Which of the following methods will you choose?

Which 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:

Which in not required by the getConnection() method to create a connecton object?

{fn length('Friday')} will return

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.