DBA > Job Interview Questions > DERBY Java Database FAQs

SQL and JDBC ResultSet/Cursor Mechanisms

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

SQL and JDBC ResultSet/Cursor Mechanisms

A cursor provides you with the ability to step through and process the rows in a ResultSet one by one. A java.sql.ResultSet object constitutes a cursor. You do not need to use a language construct, such as SQL-92's DECLARE CURSOR, to work with cursors in a Java application. In Derby, any SELECT statement generates a cursor.

(Continued on next question...)

Other Job Interview Questions