5.7. Review Questions

  1. What type of recovery is the Flashback Database best suited for? (Choose all that apply.)

    1. User error

    2. Physical corruption

    3. Logical corruption

    4. Media failure

  2. Flashback Database recovery can recover from which of the following failure scenarios?

    1. Loss of control file

    2. Dropping a tablespace through RESETLOGS

    3. A user error that resized datafiles to a smaller size

    4. A large truncated table or group of tables

  3. What new background process is responsible for writing before block images and recovering from the Flashback Database log?

    1. RWVR

    2. RVWR

    3. RWRV

    4. RVRW

  4. What are the benefits of the flash recovery area in the recovery and backup process?

    1. Recovery efficiency is improved because all files are stored on tape media for fast access.

    2. Recovery efficiency is improved because the files are stored in multiple locations.

    3. Recovery efficiency is improved because the files are stored in one location on tape.

    4. Recovery efficiency is improved because the files are stored in one location on disk.

  5. Where is information about the status of the flash recovery area displayed? (Choose all that apply.)

    1. Alert log

    2. Background trace files

    3. V$_OUSTANDING_ALERTS

    4. DBA_OUTSTANDING_ALERTS

  6. How is the size of the flash recovery area determined? (Choose all that apply.)

    1. The size is automatically allocated at 2 gigabytes.

    2. Using the ALTER SYSTEM command to dynamically set the size.

    3. With the initialization parameter DB_RECOVERY_FILE_DEST_SIZE.

    4. Using the ALTER TABLESPACE command.

  7. What type of backup commands can the flash recovery area be used for? (Choose all that apply.)

    1. BACKUP COPY

    2. BACKUP IMAGE

    3. BACKUP

    4. BACKUPSET

  8. The flash recovery area space utilization and stored files can be identified by what method?

    1. DBA_OUTSTANDING_ALERTS

    2. V$OUTSTANDING_ALERTS

    3. V$RECOVERY_FILE_DEST

    4. DBA_RECOVERY_FILE_DEST

  9. What parameter determines the length of time that the Flashback Database will store "before" images that can be used in the recovery process?

    1. DB_FLASHBACK_RETENTION_POLICY

    2. DB_FLASHBACK_RETENTION_TIME

    3. DB_FLASHBACK_RETENTION_STORE

    4. DB_FLASHBACK_RETENTION_TARGET

  10. How is the DB_FLASHBACK_RETENTION_TARGET parameter measured?

    1. By SCN

    2. By redo log sequences

    3. By time in minutes

    4. By redo log sequence and threads

  11. To enable the Flashback Database, what must be done to the database? (Choose all that apply.)

    1. It must be mounted.

    2. It must be opened with RESETLOGS.

    3. The flash recovery area must be created.

    4. The database must be in ARCHIVELOG mode.

  12. When using the Flashback Database in a recovery situation, what information would be useful to know? (Choose all that apply.)

    1. Information about the smallest SCN number that is stored in the Flashback Database log

    2. Information about the earliest timestamp that is stored in the Flashback Database log

    3. Information about the greatest SCN number that is stored in the Flashback Database log

    4. Information about the latest timestamp that is stored in the Flashback Database log

  13. How can you determine if the Flashback Database is turned on?

    1. Query the DBA_FLASHBACK_DATABASE view.

    2. Query the VSDATABASE dynamic view.

    3. Check the initialization parameters.

    4. Check the alert log.

  14. Which of the following views can determine how much space you may need in the future in the Flashback Database logs?

    1. V$DATABASE

    2. V$FLASHBACK_DATABASE_STAT

    3. V$FLASHBCK_DATABASE_LOG

    4. DBA_FLASHBACK_LOG

  15. What is the default size of a redo log file created in the flash recovery area?

    1. 100MB

    2. 150MB

    3. 10MB

    4. 50MB

  16. Which initialization parameter will create archive logs to the flash recovery area?

    1. ARCHIVE_LO6_DEST

    2. ARCHIVE_DUPLEX_DEST

    3. ARCHIVE_LOG_DEST_ n

    4. LOG_ARCHIVE_DEST_n

  17. Which database files are permanently stored in the flash recovery area? (Choose all that apply.)

    1. Datafiles

    2. RMAN files

    3. Control files

    4. Current online redo logs

    5. Archive logs

  18. Which files will not be backed up in the flash recovery area when you're using the BACKUP RECOVERY AREA and BACKUP RECOVERY FILES commands? (Choose all that apply.)

    1. Control files

    2. Redo logs

    3. Datafiles

    4. Permanent files

    5. Flashback logs

  19. What is responsible for applying the "before" images to the database during a Flashback Database recovery?

    1. LGWR

    2. SMON

    3. DBWR

    4. RVWR

  20. What administrative database activity cannot be undone with the Flashback Database recovery?

    1. Dropped table

    2. Dropped user

    3. Resized datafiles to smaller size

    4. Dropped tablespace

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset