OCP 12c - RMAN sample question and answer.

1. How is block-change tracking enabled?

A. With ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

B. With ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING

C. With an init.ora parameter change

D. With an spfile parameter change

2. What type of backup is stored in a proprietary RMAN format?

A. Backup set

B. Image copy

C. Backup section

D. Backup group

3. Consider the following command:

Backup database plus archivelog delete input;

How many backup sets would be created by this command if the following were true:

■■ Control-file auto backups were enabled.

■■ The size of backup sets was not restricted.

■■ One channel was allocated.

A. 1

B. 2

C. 3

D. 4

E. 5

Note:- 

The following four backup sets would be created:

■■ One for an archive log backup before the main backup.

■■ One for the main backup. Since we are using a single channel with no backup-set

size restriction, RMAN would create a single backup set.

■■ One for an archive log backup after the main backup.

■■ One for the control-file autobackup.

4. Which command creates an image copy?

A. BACKUP AS COPY

B. BACKUP COPY

C. COPY AS BACKUP

D. COPY BACK

5. Compressed backups work with which of the following commands?

A. COPY AS BACKUP

B. BACKUP AS COPY

C. BACKUP

D. COPY

Note:- Compressed backups work only with backup sets, not image copies. Thus, compressed

backups will work only with the BACKUP command.

6. Which is the correct command to back up the database, back up the archived redologs, and then remove the backed-up archived redo logs?

A. BACKUP DATABASE

B. BACKUP DATABASE AND ARCHIVELOGS

C. BACKUP DATABASE PLUS ARCHIVELOGS

D. BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT

E. BACKUP DATABASE AND ARCHIVELOG DELETE INPUT

7. Which of the following best describes a full backup?

A. All data files of a database

B. All data files, archive logs, and control files

C. All data files and control files

D. All the used blocks in a data file

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

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

A. Level 1

B. Level 0

C. Level 2

D. Level 3

10. Which backup option defines a user-defined name for a backup?

A. FORMAT

B. NAME

C. TAG

D. FORMAT U%

11. Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?

a. SHUTDOWN IMMEDIATE from RMAN

b. Log into RMAN

c. STARTUP MOUNT from RMAN

d. BACKUP DATABASE

e. ALTER DATABASE OPEN

f. BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT

A. b, c ,a, d, e

B. b, a, c, f, e

C. a, c, e, d

D. b, a, c, e, f

E. b, a, c, d, e

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

Note:- Image copies are similar to operating-system copy commands. These equate to bit-by-bit copies of a file.

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

14. 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. Reschedulable backups

D. Automatic backup recovery

E. Channel recovery

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

16. The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that apply.)

A. The initialization parameter should be set to 0 when the RMAN repository is being used.

B. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the recovery catalog only.

C. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the control file or the recovery catalog.

D. The initialization parameter should be set to 0 with the RMAN repository utilizing

the control file or the recovery catalog.

E. The initialization parameter should never be set to 0 if you are using RMAN.

17. Given the following steps, which would be the correct order to create a backup of an Oracle database in ARCHIVELOG mode with control-file autobackups enabled?

a. BACKUP ARCHIVELOG ALL

b. BACKUP DATABASE ALL

c. BACKUP CONTROLFILE

d. BACKUP ARCHIVELOG, DATABASE, CONTROLFILE DELETE INPUT

e. BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT

A. e

B. a, b, a, c

C. d

D. b, a, c

E. b, a, c, d, e

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

A. The BACKUP command cannot be used to make image copies of a data file.

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

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

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

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

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

A. BACKUP AS COMPRESSED BACKUP SET DATABASE

B. BACKUP AS COMPRESSED COPY OF DATABASE

C. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUP SET

D. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS

E. BACKUP DATABASE COMPRESS

20. 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 data files 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.