Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 101:

  Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?

  A. Differential incremental backup

  B. Different incremental backup

  C. Cumulative backup

  D. Cumulative incremental backup

  Correct Answer: A

• Question 102:

  Which type of backup must be performed first with an incremental backup?

  A. Level 1

  B. Level 0

  C. Level 2

  D. Level 3

  Correct Answer: B

• Question 103:

  Which of the following most closely represents an image copy?

  A. Unix cp command of a file

  B. Bit-by-bit copy of a file

  C. Windows COPY command of a file

  D. All of the above

  Correct Answer: D

• Question 104:

  Examine the following RMAN script:

  RMAN> run {

  debug on;

  allocate channel c1 type disk;

  backup datafile 5;

  }

  Which statement describes the purpose of the script?

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

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

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

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

  Correct Answer: D

• Question 105:

  Which command creates an image copy?

  A. backup as copy

  B. backup copy

  C. copy as backup

  D. copy back

  Correct Answer: A

• Question 106:

  The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:

  LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive' LOG_ARCHIVE_DEST_2 = 'SERVICE = stdb1' DB_RECOVERY_FILE_DEST = '/u01/oradata'

  Examine the following RMAN command issued to set the deletion policy for archived log files: RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO sbt;

  Which statement is true regarding what this command accomplishes?

  A. All archived redo log files backed up at least twice to tape are deleted.

  B. All archived redo log files backed up at least once to tape are eligible for deletion.

  C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.

  D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

  Correct Answer: D

• Question 107:

  Which command is used to configure RMAN to perform a compressed backup for every backup executed?

  A. BACKUP AS COMPRESSED BACKUPSET DATABASE

  B. BACKUP AS COMPRESSED COPY OF DATABASE

  C. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET

  D. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS

  E. BACKUP DATABASE COMPRESS

  Correct Answer: C

• Question 108:

  Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backup and specify the KEEP clause.

  Which components are backed up when this option is specified?

  A. only the control file, the current SPFILE, and data files

  B. only the current SPFILE and data files if autobackup is disabled

  C. only the data files and the archived redo logs

  D. the control file, current SPFILE file, data files, and archived redo logs

  Correct Answer: D

• Question 109:

  Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMAN repository can be listed? (Choose two.)

  A. stored scripts in the recovery catalog

  B. backups that can be deleted from disk

  C. backup sets and image copies are obsolete

  D. backups that do not have the AVAILABLE status in the RMAN repository

  Correct Answer: AD

  About the LIST command

  The primary purpose of the LIST command is to list backup and copies. For example, you can list:

  Backups and proxy copies of a database, tablespace, data file, archived redo log, or control file Backups that have expired

  Backups restricted by time, path name, device type, tag, or recoverability Archived redo log files and disk copies

  Besides backups and copies, RMAN can list other types of data. For example, you can list:

  Backup sets and proxy copies

  Image copies

  Archived redo log files

  Database incarnations

  Databases in a Data Guard environment

  Backups and copies for a primary or standby database in a Data Guard environment

  Restore points

  Names of stored scripts

  Failures for use with Data Recovery Advisor

• Question 110:

  Examine the following set of RMAN commands:

  RMAN> CONFIGURE CHANNEL dc1 DEVICE TYPE DISK FORMAT '/u02/backup/%U'; RMAN> RUN (

  ALLOCATE CHANNEL Chi DEVICE TYPE DISK;

  EXECUTE SCRIPT full_backup;

  )

  Which statement is true when the RMAN RUN block is executed?

  A. The execution of the script fails because multiple channels cannot coexist.

  B. The script is executed and both the channels are used for the script execution.

  C. The new channel 'CHI' is Ignored because a channel has been configured already.

  D. configuration parameter dc1 is overridden because a new channel is allocated in RMAN RUN block.

  Correct Answer: D