Transaction Properties

Each transaction must possess properties commonly referred to as the ACID properties:

• Atomicity
• Consistency
• Isolation
• Durability

In nested transactions, child transactions exhibit atomicity, consistency, and isolation properties. They do not exhibit the durability property since the parent adopts its operation when it is committed. The operations affect the database only when the top-level transaction is committed. Therefore, even though a child transaction is committed, its operations and locks can be lost if the parent transaction is rolled back.