The problem of ordering the update in multiple updates is avoided using

Related MCQs

•                              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.
• Lost update problem is
• Updates that violate                      are disallowed.
•                        refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails.
• In the                      phase, the system replays updates of all transactions by scanning the log forward from the last checkpoint.
• 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.
• 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?
• If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
• With multiple disks, we can improve the transfer rate as well by                        data across multiple disks.