[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-053 Dumps with VCE and PDF 351-360

2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: Administration II

Question No: 351 – (Topic 10)

You want to use RMAN to create compressed backups.

Which statement is true about the compression algorithms that RMAN can use?

  1. The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.

  2. The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.

  3. The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.

  4. Only the BZIP2 compression algorithm can be used to make compressed backups to disk.

Answer: A

Question No: 352 – (Topic 10)

You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy:


Which statement is true?

  1. The command fails because you cannot configure a redundancy-based retention policy when backup optimization is enabled

  2. Backup optimization is performed, but RMAN considers the redundancy-based retention policy when it determines which datafiles should be backed up

  3. Backup optimization is permanently disabled

  4. Backup optimization is temporarily disabled because a redundancy-based retention policy is specified

Answer: B

Question No: 353 – (Topic 10)

You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups.

Which action should you take?

  1. Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE.

  2. Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE.

  3. Use compression when performing tape backups.

  4. Configure multiple SBT channels.

Answer: B

Question No: 354 – (Topic 10)

You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN command:


Which two statements are true regarding the execution of the above command? (Choose two.)

  1. The RMAN parallelizes the backup although the parallelism is not set for a channel.

  2. The backup piece size will be limited to 300 MB.

  3. The operation is accomplished using the default channel available.

  4. Three channels for the tape drive must be configured by setting the parallelism to three.

Answer: B,C Explanation:

SECTION SIZE sizeSpec Specifies the size of each backup section produced during a data file backup.

By setting this parameter, RMAN can create a multisection backup. In a multisection backup, RMAN creates a backup piece that contains one file section, which is a contiguous range of blocks in a file. All sections of a multisection backup are the same size. You can create a multisection backup for a data file, but not a data file copy.

File sections enable RMAN to create multiple steps for the backup of a single large data file. RMAN channels can process each step independently and in parallel, with each channel producing one section of a multisection backup set.

If you specify a section size that is larger than the size of the file, then RMAN does not use multisection backup for the file. If you specify a small section size that would produce more than 256 sections, then RMAN increases the section size to a value that results in exactly 256 sections.

Depending on where you specify this parameter in the RMAN syntax, you can specify different section sizes for different files in the same backup job.


Question No: 355 – (Topic 10)

You have enabled backup optimization for the RMAN environment.

Identify two criteria on which RMAN will skip the file, if it has already been backed up. (Choose two.)

  1. The data file backup is done with multiple channels

  2. The data files is in the read-write mode after being backed up in the read only mode

  3. The backup was taken after the data files was taken offline-normal or is in the read only mode

  4. The data file backup complies with the back retention policy and the backup duplexing feature

Answer: C,D

Question No: 356 – (Topic 10)

What does the minimize load database parameter mean when backing up a database?

  1. RMAN will attempt to make the backup run as fast as possible without any IO limitations.

  2. RMAN will automatically restrict the number of channels in use to one.

  3. RMAN will spread the backup IO over the total duration stated in the backup command.

  4. RMAN will skip any datafile that currently is involved in an IO operation. RMAN will retry backing up the datafile later and an error will be raised at the end of the backup if the datafile cannot be backed up.

  5. Datafiles will be backed up; those having the lowest current number of IO operations will be backed up first.

Answer: C

Question No: 357 – (Topic 10)

You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN):


Identify the statement that correctly describes the implications of this command.

  1. when there are already three backups, for the fourth backup RMAN removes the oldest backup.

  2. When there are already three backups, for the fourth backup RMAN marks the oldest backup as obsolete.

  3. the number of backups that are retained is equal to three and it includes full, incremental, and cumulative backups.

  4. when there are already three backup, one of the existing backups must be removed manually before taking the fourth backup.

Answer: B Explanation:

Configuring a Redundancy-Based Retention Policy

The REDUNDANCY parameter of the CONFIGURE RETENTION POLICY command specifies how many full or level 0 backups of each data file and control file that RMAN should keep. If the number of full or level 0 backups for a specific data file or control file exceeds the REDUNDANCY setting, then RMAN considers the extra backups as obsolete.

The default retention policy is REDUNDANCY 1.

As you produce more backups, RMAN keeps track of which ones to retain and which are obsolete. RMAN retains all archived logs and incremental backups that are needed to recover the nonobsolete backups.

Assume that you make a full backup of data file 7 on Monday, Tuesday, Wednesday, and Thursday. You now have four full backups of this data file.If REDUNDANCY is 2, then the Monday and Tuesday backups are obsolete. If you make another backup on Friday, then the Wednesday backup of data file 7 becomes obsolete. Assume a different case in which REDUNDANCY is 1. You run a level 0 database backup at noon on Monday, a level 1 cumulative backup at noon on Tuesday and Wednesday, and a level 0 backup at noon on Thursday. Immediately after each daily backup you run the command DELETE OBSOLETE. The Wednesday DELETE command does not remove the Tuesday level 1 backup because this backup is not redundant: the Tuesday level 1 backup could be used to recover the Monday level 0 backup to a time between noon on Tuesday and noon on Wednesday. However, the DELETE command on Thursday removes the previous level 0 and level 1 backups.

Run the CONFIGURE RETENTION POLICY command at the RMAN prompt, as in the following example: CONFIGURE RETENTION POLICY TO REDUNDANCY 3;

Question No: 358 – (Topic 10)

View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.

What is the reason for this error? Exhibit:

Ensurepass 2018 PDF and VCE

  1. Another repair session is running concurrently.

  2. The failure ID has not been mentioned in the command for data file 5.

  3. There are new failures recorded in the Automatic Diagnostic Repository (ADR).

  4. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.

Answer: A

Topic 11, Using Flashback Technology

Question No: 359 – (Topic 11)

You executed the following commands in a database session:

Ensurepass 2018 PDF and VCE

What could have caused the recycle bin to clean up?

  1. There is demand for space from the new table

  2. The undo tablespace does not have sufficient free space

  3. The new table name is the same as the table name in the recycle bin

  4. The temporary tablespace that is assigned to you does not have sufficient free space

Answer: A

Question No: 360 – (Topic 11)

On which two database objects can the VERSIONS clause of the Flashback Versions Query be used? (Choose two.)

  1. fixed tables

  2. heap tables

  3. external tables

  4. temporary tables

  5. Index-Organized Tables (IOTs)


    Answer: B,E

    100% Free Download!
    Download Free Demo:1z0-053 Demo PDF
    100% Pass Guaranteed!
    Download 2018 EnsurePass 1z0-053 Full Exam PDF and VCE

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

    2018 EnsurePass IT Certification PDF and VCE

Leave a Comment


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