will undo all statements up to commit?

Related MCQs

• If                        are not obtained in undo operation it will cause problem in undo- phase.
• In order to undo the work of transaction after last commit which one should be used?
• 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
• 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.
• Which of the following is used for undo operations alone?
• For correct behaviour during recovery, undo and redo operation must be
• 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.
• A transaction commits as soon as its commit log record is written to stable storage at the primary site. This is