In order to undo the work of transaction after last commit which one should be used?

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                        are not obtained in undo operation it will cause problem in undo- phase.
•              will undo all statements up to commit?
• Which TCL command undo all the updates performed by the SQL in the transaction?
•                        determines which transactions to undo, which pages were dirty at the time of the crash, and the LSN from which the redo pass should start.
•          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.
• In case of any shut down during transaction before commit which of the following statement is done automatically?
• The                                policy, allows a transaction to commit even if it has modified some blocks that have not yet been written back to disk.