QUESTION 91While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 p.m. on September 6, 2008. Which of the following would be the correct commands to use to restore the database to a point in time before the orruption?

A. Option AB. Option BC. Option CD. Option DE. Option E

Answer: C

QUESTION 92What is the purpose of the until change option of the restore command?

A. It allows you to select the SCN that you want to restore to.B. It allows you to select the log sequence number you want to restore to.C. It allows you to select the timestamp you want to restore to.D. It allows you to manually stop the restore at any time as online redo logs are applied.E. None of the above.

Answer: AExplanation:The keyword of CHANGE means to point to the system change number (SCN).

QUESTION 93What is the purpose of the recover command? (Choose all that apply.)

A. A backup set that is missing one or more backup set piecesB. A backup that has exceeded the retention criteria and is no longer neededC. A backup set that does not include archived redo logsD. A backup set that can not be recovered due to corruptionE. A backup set superceded by a datafile copy

Answer: B

QUESTION 95What is the purpose of the list expired backup command?

A. Lists all backups impacted by a resetlogs commandB. Lists all backups that are subject to retention criteriaC. Lists all backups that are missing associated physical backup set piecesD. Lists the status of datafile backup failures due to the use of the duration commandE. Lists backups that cannot be used by the restore command because they have been marked as disabled

Answer: C

QUESTION 96What is the purpose of the catalog command?

A. To review RMAN control file and recovery catalog metadata and ensure that its correctB. To delete RMAN backup-related metadata from the recovery catalogC. To create metadata in the control file and the recovery catalog related to backup set piecesD. To create a report that lists database backupsE. To rebuild the recovery catalog

Answer: CExplanation:Use the CATALOG command to do the following:Add backup pieces and image copies on disk to the RMAN repository Record a data file copy as a level 0 incremental backup in the RMAN repository, which enables you to use it as part of an incremental backup strategy