O'Reilly logo

OCA: Oracle 10g™ Administration I: Study Guide by Matthew Weishan, Joseph C. Johnson, Bob Bryla, Chip Dawes

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

10.6. Review Questions

  1. Which of the following is the most serious type of redo log file failure?

    1. The loss of an entire redo log file group, but no loss in any other group

    2. The loss of one member of each redo log file group

    3. The failure of the ARC0 background process

    4. The failure of the LGWR background process

  2. Which of the following tools or options does not ensure that either no committed transactions are lost or the MTBF is minimized?

    1. Streams

    2. Real Application Clusters

    3. LogMiner

    4. Archived redo logs

    5. Standby databases

  3. When the database is in ARCHIVELOG mode, database recovery is possible up to which event or time?

    1. The last redo log file switch

    2. The last checkpoint position

    3. The last commit

    4. The last incremental backup using RMAN

  4. From the following, select the true statement ...

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