Fill in the Blanks

1.________ is a process of restoring a database to the correct state in the event of a failure.
2.If only the transaction has to be undone, then it is called a ________.
3.When all the active transactions have to be undone, then it is called a ________.
4.If all pages updated by a transaction are immediately written to disk when the transaction commits, this is called a ________ and the writing is called a ________.
5.If the pages are flushed to the disk only when they are full or at some time interval, then it is called ________.
6.Shadow paging technique does not require the use of a transaction log in ________ environment.
7.Shadow paging technique is classified as ________ algorithm.
8.Concurrency control and database ...

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.