The JDBC Connection and Transaction Model

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

(Continued from previous question...)

The JDBC Connection and Transaction Model

Session and transaction capabilities for SQL are handled through JDBC procedures, not by SQL commands.

JDBC defines a system session and transaction model for database access. A session is the duration of one connection to the database and is handled by a JDBC Connection object.

(Continued on next question...)

Other Job Interview Questions

• What is LDAP Directory Service
• Exceptions in Triggers Actions
• SQL Tips - Using Third-Party Tools
• How to define Users?
• User Authentication and Authorization Examples: Client/Server Environment
• How to Configure Deadlock Detection and Lock Wait Timeouts
• SQL Tips - Defining an Identity Column
• The JDBC Connection and Transaction Model
• What is a Derby Database Limitations ?
• What is Isolation Levels and Concurrency ?
• More...