O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Tick (✓) the Appropriate Answer

1.Which of the following is not a recovery technique?
  1. Shadow paging.

  2. Deferred update.

  3. Write-ahead logging.

  4. Immediate update.

2.Incremental logging with deferred updates implies that the recovery system must necessarily store
  1. the old value of the updated item in the log.

  2. the new value of the updated item in the log.

  3. both the old and new value of the updated item in the log.

  4. only the begin transaction and commit transaction records in the log.

3.Which of the following are copies of physical database files?
  1. Transaction log

  2. Physical backup

  3. Logical backup

  4. None of these.

4.In case of transaction failure under a deferred update incremental logging scheme, which of the following will be needed:
  1. An undo operation

  2. A redo operation ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required