Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 131:

  What is the impact of the following backup if it exceeds the duration allowance?

  backup as compressed backupset duration 2:00 partial minimize load database ;

  A. The entire backup will fail. It will not be usable for recovery.

  B. The entire backup will fail, but any datafile successfully backed up will be usable for recovery.

  C. If this backup fails, subsequent backups will prioritize datafiles not backed up.

  D. If this backup fails, an error will be raised and any other commands will not be executed.

  E. If this backup fails, no error will be raised and any other commands will be executed.

  Correct Answer: B

• Question 132:

  What is the impact of the results of the output of the following command?

  RMAN> report unrecoverable database; Report of files that need backup due to unrecoverable operations File Type of Backup Required Name ---- ----------------------- ----------------------------------- 4 full or incremental C:\ORACLE\ORADATA\ORCL \USERS01.DBF

  A. There are no backup sets with any backups of the users01.dbf datafile.

  B. The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be backed up or some data loss is possible during a recovery.

  C. The users01.dbf datafile is corrupted.

  D. The users01.dbf datafile backup exceeds the retention criteria.

  E. The last backup of the users01.dbf datafile failed and must be rerun.

  Correct Answer: D

• Question 133:

  True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to trace.

  A. True

  B. False

  Correct Answer: B

• Question 134:

  Why would you run the delete obsolete command? (Choose all that apply.)

  A. To remove missing backup set pieces physically from disk

  B. To remove metadata related to backup set pieces in the control file and the recovery catalog

  C. To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets

  D. To delete backup set pieces associated with backups that are no longer needed due to retention criteria

  E. To remove old versions of RMAN backups

  Correct Answer: CD

  Deleting Expired RMAN Backups and Copies

  If you run CROSSCHECK, and if RMAN cannot locate the files, then it updates their records in the RMAN repository to EXPIRED status. You can then use the DELETE EXPIRED command to remove records of expired backups and copies

  from the RMAN repository. The DELETE EXPIRED command issues warnings if any files marked as EXPIRED actually exist. In rare cases, the repository can mark a file as EXPIRED even though it exists. For example, a directory containing

  a file is corrupted at the time of the crosscheck, but is later repaired, or the media manager was not configured properly and reported some backups as not existing when they really existed.

  To delete expired repository records:

  If you have not performed a crosscheck recently, then issue a CROSSCHECK command. For example,

  issue:

  CROSSCHECK BACKUP;

  Delete the expired backups. For example, issue:

  DELETE EXPIRED BACKUP;

  Deleting Obsolete RMAN Backups Based on Retention Policies The RMAN DELETE command supports an OBSOLETE option, which deletes backups that are no longer needed to satisfy specified recoverability requirements. You can delete

  files that are obsolete according to the configured default retention policy, or another retention policy that you specify as an option to the DELETE OBSOLETE command. As with other forms of the DELETE command, the files deleted are

  removed from backup media, deleted from the recovery catalog, and marked as DELETED in the control file.

  If you specify the DELETE OBSOLETE command with no arguments, then RMAN deletes all obsolete backups defined by the configured retention policy. For example:

  DELETE OBSOLETE;

• Question 135:

  Which of the following commands will fail?

  A. report schema;

  B. report need backup;

  C. report need backup days 3;

  D. report user;

  E. report obsolete;

  Correct Answer: D

• Question 136:

  You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control- file autobackups. Which files are not backed up during the RMAN backup?

  A. Database Datafiles

  B. Database Control Files

  C. Online redo logs

  D. Archived redo logs

  E. The database SPFILE

  F. None of the above, all these files are backed up.

  Correct Answer: C

• Question 137:

  Which of the following files cannot be backed up by RMAN? (Choose all that apply.)

  A. Database datafiles

  B. Control files

  C. Online redo logs

  D. Database pfiles

  E. Archived redo logs

  Correct Answer: CD

• Question 138:

  Which of the following RMAN structures can data from a datafile span?

  A. RMAN backup-set pieces spanning backup sets

  B. RMAN backup-set pieces within a given backup set

  C. RMAN backups

  D. RMAN channels

  E. None of the above

  Correct Answer: B

• Question 139:

  What is an obsolete backup set?

  A. A backup set that is missing one or more backup set pieces

  B. A backup that has exceeded the retention criteria and is no longer needed

  C. A backup set that does not include archived redo logs

  D. A backup set that can not be recovered due to corruption

  E. A backup set superceded by a datafile copy

  Correct Answer: B

• Question 140:

  What is the purpose of the catalog command?

  A. To review RMAN control file and recovery catalog metadata and ensure that its correct

  B. To delete RMAN backup-related metadata from the recovery catalog

  C. To create metadata in the control file and the recovery catalog related to backup set pieces

  D. To create a report that lists database backups

  E. To rebuild the recovery catalog

  Correct Answer: C

  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