refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails.

Related MCQs

• If several concurrent transactions are executed over the same data set and the second transaction updates the database before the first transaction is finished, the ____ property is violated and the database is no longer consistent.
• If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by
• Which of the following command makes the updates performed by the transaction permanent in the database?
• Which TCL command undo all the updates performed by the SQL in the transaction?
•                              policy allows multiple updates to accumulate on a block before it is output to stable storage, which can reduce the number of output operations greatly for frequently updated blocks.
• Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?
• If a transaction does not modify the database until it has committed, it is said to use the                        technique.
• In the                      phase, the system replays updates of all transactions by scanning the log forward from the last checkpoint.
• A system is in a              state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.
• Updates that violate                      are disallowed.