What is ResultSets and Auto-Commit ?

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

(Continued from previous question...)

What is ResultSets and Auto-Commit ?

Except for the result sets associated with holdable cursors, issuing a commit will cause all result sets on your connection to be closed.

(Continued on next question...)

Other Job Interview Questions

• How to Transfer Read-Only Databases to Archive (Jar or Zip) Files?
• When Path Is Ambiguous with Databases in File System?
• How to changethe Boot Password?
• Does a Derby Database provides Storage and Recovery ?
• Standard Connections--Connecting to Databases in the File System Within the System
• How to Install Jar Files ?
• Explain about Embedded Derby JDBC Database Connection URL
• How to Use the databaseName Attribute ?
• The JDBC Connection and Transaction Model
• What is a Derby Database-Wide Properties ?
• More...