Review Questions
| 1. | What is a transaction? What are its properties? Why are transactions important units of operation in a DBMS? |
| 2. | Draw a state diagram and discuss the typical states that a transaction goes through during execution. |
| 3. | How does the DBMS ensure that the transactions are executed properly? |
| 4. | What is consistent database state and how is it achieved? |
| 5. | What is transaction log? What are its functions? |
| 6. | What are the typical kinds of records in a transaction log? What are transaction commit points and why are they important? |
| 7. | What is a schedule? What does it do? |
| 8. | What is concurrency control? What are its objectives? |
| 9. | What do you understand by the concurrent execution of database transactions in a multi-user environment? |
| 10. | What do ... |
Get Database Systems: Concepts, Design and Applications now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
