Students who complete this unit will demonstrate that they can:

• Create a transaction by embedding SQL into an application program.
• Explain the concept of implicit commits.
• Describe the issues specific to efficient transaction execution.
• Explain when and why rollback is needed and how logging assures proper rollback.
• Explain the effect of different isolation levels on the concurrency control mechanisms.
• Choose the proper isolation level for implementing a specified transaction protocol.
• Identify appropriate transaction boundaries in application programs.