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 ...

Get OCA: Oracle 10g™ Administration I: Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial