DBA > Job Interview Questions > DERBY Java Database FAQs

Explain about Updatable Cursors

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

(Continued from previous question...)

Explain about Updatable Cursors

Cursors are read-only by default. For a cursor to be updatable, you must specify SELECT . . . FOR UPDATE. Use FOR UPDATE only when you will be modifying rows to avoid excessive locking of tables.

(Continued on next question...)

Other Job Interview Questions