August 2009
Intermediate to advanced
893 pages
26h 48m
English
Content preview from Database Systems: Concepts, Design and Applications
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ... |