Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 281:

  You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent.

  Which type of backup should you perform?

  A. standard backup set

  B. image copy

  C. compressed backup

  D. user-managed backup

  Correct Answer: C

• Question 282:

  You executed the following command in Recovery Manager (RMAN):

  RMAN> REPORT NEED BACKUP days 3;

  What is the output of this command?

  A. a list of files that require a backup within three days

  B. a list of files requiring more than 3 days of archive logs to apply

  C. a list of files that RMAN recommends be backed up only once in every three days, based on low volatility

  D. a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

  Correct Answer: B

  Using RMAN REPORT NEED BACKUP with Different Retention Policies (link) You can specify different criteria for REPORT NEED BACKUP, using one of the following forms of the command:

  REPORT NEED BACKUP RECOVERY WINDOW OF n DAYS Displays objects requiring backup to satisfy a recovery window-based retention policy REPORT NEED BACKUP REDUNDANCY n Displays objects requiring backup to satisfy a redundancy-based retention policy REPORT NEED BACKUP DAYS n Displays files that require more than n days' worth of archived redo log files for recovery REPORT NEED BACKUP INCREMENTAL n Displays files that require application of more than n incremental backups for recovery

• Question 283:

  Which dynamic view displays the status of block-change tracking?

  A. V$BLOCK_CHANGE

  B. V$BLOCK_CHANGE_TRACKING

  C. V$BLOCKCHANGE

  D. V$BLOCK_TRACKING

  Correct Answer: B

  V$BLOCK_CHANGE_TRACKING displays the status of block change tracking for the database.

• Question 284:

  Examine the following command used to perform incremental level 0 backup:

  RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;

  To enable the block change tracking, after the incremental level 0 backup you issued the following command:

  SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/rman_change_track.f';

  To perform incremental level 1 cumulative backup, you issued the following command:

  RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

  Which two statements are true in the above situation? (Choose two.)

  A. The block change tracking data will be used only from the next incremental 0 backup.

  B. The incremental backup will use change tracking data for accomplishing the backup.

  C. The incremental backup will not use change tracking data for accomplishing the backup.

  D. The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0 backup.

  Correct Answer: AC

• Question 285:

  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.)

  A. The data file backup is done with multiple channels

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

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

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

  Correct Answer: CD

• Question 286:

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

  CONFIGURE RETENTION POLICY TO REDUNDANCY 3;

  Which statement is true?

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

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

  C. Backup optimization is permanently disabled

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

  Correct Answer: B

• Question 287:

  A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger, which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?

  A. backup database all

  B. backup compressed database

  C. backup as compressed backupset database;

  D. backup as compressed backup database plus archivelog all;

  E. backup as compressed backupset database plus compress archivelog all;

  Correct Answer: A

  

  RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/23/2014 11:46:01 ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode RMAN>

• Question 288:

  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?

  A. Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE.

  B. Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE.

  C. Use compression when performing tape backups.

  D. Configure multiple SBT channels.

  Correct Answer: B

• Question 289:

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

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

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

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

  D. 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.

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

  Correct Answer: C

• Question 290:

  You want to use RMAN to create compressed backups.

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

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

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

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

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

  Correct Answer: A