What is a transaction?
A transaction is a set of operations that begin when the first DML is issued and end when a commit or rollback is issued. BEGIN COMMIT/ROLLBACK are the boundries of a transaction.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Explain the different Transaction Attributes and Isolation Levels with reference to a scenario. 27.10.08
The Enterprise JavaBeans model supports six different transaction rules: · TX_BEAN_MANAGED. The TX_BEAN_MANAGED setting indicates that the en...What are transaction attributes? 27.10.08
A: The transaction attribute specifies how the Container must manage transactions for a method when a client invokes the method via the enterprise bean...Give examples of degenerated dimensions ? 22.09.08
Degenerated Dimension is a dimension key without corresponding dimension. Example: In the PointOfSale Transaction Fact table, we have: Date...Explain transactions, commits and rollbacks in DB2 ? 02.04.08
In DB2 a transaction typically requires a series of updates, insertions and deletions that represent a logical unit of work. A transaction puts an implicit lock...What are Benefits of wrapping database calls into MTS transactions? 16.04.07
If database calls are made within the context of a transaction, aborting the transaction will undo and changes that occur within that transaction. This removes...Overall how do you write transaction programs in SAP? 12.04.07
Create program-SE93-create transaction code -Run it from command field. Create the transaction using object browser (SE80) Define the objects e.g. screen,...What is Read-Only Transaction? 03.11.06
A Read-Only transaction ensures that the results of each query executed in the transaction are consistent with respect to the same point in time....What is JTA and JTS? 02.10.06
JTA is the abbreviation for the Java Transaction API. JTS is the abbreviation for the Jave Transaction Service. JTA provides a standard interface and allows you...What are transaction attributes? 08.08.06
The transaction attribute specifies how the Container must manage transactions for a method when a client invokes the method via the enterprise bean’s home or...What is transaction manager 11.03.06
Provides the services and management functions required to support transaction demarcation, transactional resource management, synchronization, and transaction...