[Free] 2018(Jan) EnsurePass Dumpsleader Oracle 1z0-053 Dumps with VCE and PDF 181-190

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: Administration II

Question No: 181 – (Topic 5)

You want to perform an RMAN backup of database as a copy. Which two factors will you consider while performing the backup operation? (Choose two).

  1. The backup as copy can only be taken to disk

  2. The backup as copy can only be taken to tape

  3. Backup can be performed only when the instance is shutdown

  4. Backup will constitute all used and unused blocks in the database

Answer: A,D

Question No: 182 – (Topic 5)

View the Exhibit and examine the RMAN commands.

Ensurepass 2018 PDF and VCE

Which statement describes the effect of a backup retention policy on the backup of a backup set?

  1. Either all the copies of a backup set are obsolete or none of them are as per the retention policy.

  2. The copies of the backup will be reported as obsolete under a redundancy-based backup retention policy.

  3. The copies of the backup will be reported as obsolete under a recovery window-based backup retention policy.

  4. All the copies of the backup set are counted as one instance of a backup and will

deleted in backup set exceeds the redundancy-based backup retention policy.

Answer: A

Question No: 183 – (Topic 5)

What is the purpose of the catalog command?

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

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

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

  4. To create a report that lists database backups

  5. To rebuild the recovery catalog

Answer: C Explanation:

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

Question No: 184 – (Topic 5)

You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups.

Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups. Identify two options for completing this task. (Choose two.)

  1. Reregistering the target database in recovery catalog

  2. Transporting the new tablespaces to the recovery catalog database

  3. Syncronizing the recovery catalog with the target database control file

  4. Performing a fresh backup of the target database to include the new data files in the

catalog database

Answer: C,D

Question No: 185 – (Topic 5)

Which of the following statements are true about the BACKUP command? (Choose all that apply.)

  1. The BACKUP command can not be used to make image copies of a datafile.

  2. The BACKUP command can improve performance by multiplexing backup files.

  3. The BACKUP can take advantage of the block-change tracking capability.

  4. The BACKUP command cannot store data in incremental backups.

  5. The BACKUP command can store data in cumulative incremental backups only.

Answer: B,C

Question No: 186 – (Topic 5)

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

  1. Database datafiles

  2. Control files

  3. Online redo logs

  4. Database pfiles

  5. Archived redo logs

Answer: C,D

Question No: 187 – (Topic 5)

What information does the report schema command not provide? (Choose all that apply.)

  1. Size of the datafiles

  2. Size of the tempfiles

  3. Date of last backup for datafiles and tempfiles

  4. Filenames for each datafile

  5. Checkpoint SCN associated with the last RMAN backup

Answer: C,E

Question No: 188 – (Topic 5)

Consider the following scenario for your database:

->Backup optimization is enabled in RMAN.

->The recovery window is set to 7 days in RMAN.

->The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.

->The TOOLS tablespace is read-only since November 4, 2007.

On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?

  1. The RMAN backup fails because the TOOLS tablespace is read-only

  2. The RMAN skips the backup of the tablespace because backup optimization is enabled

  3. The RMAN makes backup because optimization can be enabled only for backups to disk

  4. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

Answer: D

Question No: 189 – (Topic 5)

Examine the following RMAN script:

RMANgt; run { debug on;

allocate channel c1 type disk; backup datafile 5;


Which statement describes the purpose of the script?

  1. The data file is checked for physical corruption and backed up if found clean.

  2. The backup of data file 5 is performed and the interactive messages during the backup are suppressed.

  3. The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.

  4. The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed

Answer: D

Question No: 190 – (Topic 5)

Why would you execute the report obsolete command?

  1. To list all backups that were no longer available for restore operations

  2. To list all backups that had aged beyond the RMAN retention criteria

  3. To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media

  4. To list all datafiles that are no longer part of the database and thus do not need to be backed up

  5. To list all archived redo logs that are no longer needed for any database recovery

Answer: B Explanation:

You can report backup sets, backup pieces, and data file copies that are obsolete that is, not needed to meet a specified retention policy by specifying the OBSOLETE keyword.

100% Ensurepass Free Download!
Download Free Demo:1z0-053 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-053 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.