Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 91:

  Which view provides information on the backup status of the datafiles in the database?

  A. V$BACKUP

  B. V$BACKUP_STATUS

  C. V$BACKUP_DATAFILE

  D. V$DATAFILE_BACKUP

  E. V$TABLESPCE_BACKUP

  Correct Answer: A

• Question 92:

  Which type of backup contains only the blocks that have changed since the last level 0 incremental backup?

  A. a cumulative level 1 backup

  B. a differential level 1 backup

  C. a full backup

  D. a whole backup

  Correct Answer: A

• Question 93:

  What feature comes into play to help ensure the completion of the backup should one of three backup devices fail during a backup that is using three different channels?

  A. Channel failover

  B. Restartable backups

  C. Rescheduable backups

  D. Automatic backup recovery

  E. Channel recovery

  Correct Answer: A

• Question 94:

  What command would you use to set a persistent setting in RMAN so that backups are all written to a tape device?

  A. CONFIGURE DEFAULT DEVICE TYPE TO TAPE MEDIA

  B. CONFIGURE DEFAULT DEVICE TYPE TO TAPE

  C. CONFIGURE DEFAULT DEVICE TYPE TO SBT

  D. CONFIGURE DEFAULT DEVICE TYPE TO SBT_TAPE

  Correct Answer: C

  SBT_TAPE is incorrect, it should be SBT TAPE, without underline strike.

• Question 95:

  Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN. (choose all that apply)

  A. Limiting the input/output (I/O) bandwidth consumption

  B. Specifying the size of backup sets and backup pieces

  C. Specifying vendor-specific information for a media manager

  D. Specifying the parallelism for backup and restore operations

  Correct Answer: AC

  For Limiting the I/O bandwith: CONFIGURE [| ALLOCATE] CHANNEL....RATE For limiting backup pieces: CONFIGURE [| ALLOCATE] CHANNEL....MAXPIECESIZE For backup sets, you need to use BACKUP..MAXSETSIZE command to limit! For parallelism, either to use CONFIGURE DEVICE TYPE..PARALLELISM or to allocate multiple channels during job. NOT to be done with CONFIGURE CHANNEL.

  Link to here: Configuring Advanced Channel Options

  

• Question 96:

  You want to set the following initialization parameters for your database instance:

  LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 = 'LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch' LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/arch MANDATORY'

  Identify the statement that correctly describes this setting.

  A. The MANDATORY location must be a flash recovery area.

  B. The optional destinations may not use the flash recovery area.

  C. This setting is not allowed because the first destination is not set as MANDATORY.

  D. The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.

  Correct Answer: D

  MANDATORY

  Specifies that filled online log files must be successfully archived to the destination before they can be reused.

  If MANDATORY is not specified, then, by default, the destination is considered to be optional. At least one destination must succeed, even if all destinations are optional. If archiving to an optional destination fails, the online redo log file is still

  available for reuse and may be overwritten eventually. However, if the archival operation of a mandatory destination fails, online redo log files cannot be overwritten.

• Question 97:

  You issue the following command: RMAN>CONFIGURE BACKUP OPTIMIZATION ON; What is the result of this command on your backups?

  A. An incremental backup strategy will be used automatically.

  B. Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.

  C. RMAN will configure itself for maximum performance at the cost of CPU.

  D. RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.

  E. RMAN will automatically compress backups.

  Correct Answer: B

• Question 98:

  What command would you issue to enable automated backups of control files?

  A. alter database controlfile autobackup on

  B. alter system controlfile autobackup on

  C. configure controlfile autobackup on

  D. enable controlfile autobackup

  Correct Answer: C

• Question 99:

  You configured the default backup device type as disk for RMAN backups. In your database, because of business requirements, you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using the RMAN CONFIGURE command to achieve this?

  A. MAXSETSIZE TO 2;

  B. DEVICE TYPE DISK PARALLELISM 2;

  C. RETENTION POLICY TO REDUNDANCY 2;

  D. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

  Correct Answer: D

  Duplexing Backup Sets with CONFIGURE BACKUP COPIES (Link)

• Question 100:

  Which of the following best describes a full backup?

  A. All datafiles of a database

  B. All datafiles, archive logs, and control files

  C. All datafiles and control files

  D. All the used blocks in a datafile

  Correct Answer: D

  From the training book:

  "Full backup: Makes a copy of each data block that contains data and that is within the files being backed up."

  "A full backup contains all used data file blocks."

  "A full backup is different from a whole database backup." Conclusion it means that not all data files are backed up when you do full backup.