The property of a transaction that persists all the crashes is

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 the complete execution of the transaction(s) takes the database from one consistent state to the other then that property of transaction is called:
• The storage structure which do not survive system crashes are              
• The command                                  such tables are available only within the transaction executing the query and are dropped when the transaction finishes.
•          means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
• If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by
• When the transaction finishes the final statement the transaction enters into
•                means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
• 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.
• The                      requires that each transaction Ti executes in two or three different phases in its lifetime, depending on whether it is a read-only or an update transaction.