Database Systems: Concepts, Design and Applications

Tick (✓) the Appropriate Answer

1.	Which of the following is not a recovery technique? Shadow paging. Deferred update. Write-ahead logging. Immediate update.
2.	Incremental logging with deferred updates implies that the recovery system must necessarily store the old value of the updated item in the log. the new value of the updated item in the log. both the old and new value of the updated item in the log. only the begin transaction and commit transaction records in the log.
3.	Which of the following are copies of physical database files? Transaction log Physical backup Logical backup None of these.
4.	In case of transaction failure under a deferred update incremental logging scheme, which of the following will be needed: An undo operation A redo operation ...