In case of any shut down during transaction before commit which of the following statement is done automatically?

Related MCQs

• If only the primary is active, the transaction is allowed to commit as soon as its commit log record is written to stable storage at the primary site. This is
• 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.
• In order to undo the work of transaction after last commit which one should be used?
• The                                policy, allows a transaction to commit even if it has modified some blocks that have not yet been written back to disk.
• A transaction commits as soon as its commit log record is written to stable storage at the primary site. This is
• A transaction commits as soon as its commit log record is written to stable storage at the primary and the backup site. This is
• A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a
•          means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
•                means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.
• ____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.