O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required