Question:"Database Concurrency Control (COMMIT and ROLLBACK )"
1. Describe at least two business scenarios where COMMIT and ROLLBACK would be required to help maintain concurrency in a multiuser platform with the help of Transaction logs.
2. Describe how these functions would be essential for business continuity and concurrency control.
3. Identify how these functions would enable an organization to recover from a database corruption event.
4. Describe how locks could be used in order to qualify data transactions and enhance concurrency control. Suggest at least two business scenarios that would benefit from implementing locking methods.
Please site sources/references if any.
Thanks in advance