Chapter 16, Performing Database Backups Video Solutions, OCA Oracle Database 11g

Problem 1

What file types can be backed up by RMAN? (Choose all correct answers.)
A. Archive $\log$ files
B. Controlfile
C. Online log files
D. Password file
E. Permanent tablespace datafiles
F. Server parameter file
G. Static parameter file
H. Temporary tablespace tempfiles

Check back soon!

Problem 2

If your database is in noarchivelog mode, which of the following is possible? (Choose the best answer.)
A. Online backups
B. Partial backups
C. Incremental backups
D. All of the above, but only if you use RMAN

Check back soon!

Problem 3

RMAN backup sets are smaller than RMAN image copies because ... (Choose the best answer.)
A. They always use compression.
B. They always skip include unused blocks.
C. They never include tempfiles.
D. They can be written directly to tape.

Check back soon!

Problem 4

Which of the following statements is correct about RMAN offline backup? (Choose all correct answers.)
A. The database must be in NOMOUNT mode.
B. The database must be in MOUNT mode.
C. The backup will fail if the shutdown mode was SHUTDOWN IMMEDIATE.
D. Noarchivelog databases can only be backed up offline.
E. Archivelog databases cannot be backed up offline.
F. Offline backups can be incremental.

Check back soon!

Problem 5

You need to back up the control file while the database is open. What will work? (Choose the best answer.)
A. The controlfile can be included in an RMAN backup set, but not backed up as an image copy.
B. The ALTER DATBASE BACKUP CONTROLFILE TO TRACE command will make an image copy of the controlfile.
C. You cannot back up the controlfile while it is in use-it is protected by multiplexing.
D. None of the above.

Check back soon!

Problem 6

You perform a full backup on Sunday, an incremental level 0 backup on Monday, an incremental level 1 differential backup on Tuesday, an incremental level 1 cumulative backup on Wednesday, and an incremental level 1 cumulative backup on Thursday. Which blocks will be included in the Thursday backup? (Choose the best answer.)
A. All blocks changed since Sunday
B. All blocks changed since Monday
C. All blocks changed since Tuesday
D. All blocks changed since Wednesday

Check back soon!

Problem 7

If you issue this RMAN command, backup incremental level 1; and there is no level 0 backup, what will happen? (Choose the best answer.)
A. The command will fail.
B. The incremental backup will be based on the most recent full backup.
C. RMAN will perform a level 0 backup.
D. RMAN will perform a level 1 cumulative backup of all blocks that have ever been changed.

Check back soon!

Problem 8

What processes must be running if an RMAN backup scheduled within the Oracle environment is to run? (Choose all correct answers.)
A. The database instance processes must be running, in MOUNT or OPEN mode.
B. The database instance processes must be running, in at least NOMOUNT mode.
C. The Enterprise Manager processes (either Database Control or the Grid Control agent) must be running.
D. The operating system scheduler must be running.

Check back soon!

Problem 9

What is true about the crosscheck command? (Choose the best answer.)
A. Crosscheck will check the validity of the backup pieces.
B. Crosscheck will delete references to files that no longer exist.
C. Crosscheck will verify the existence of backup set pieces.
D. Crosscheck only works with backup sets, not image copies.

Check back soon!

Problem 10

If the volume of data in the flash recovery area has reached the limit defined by DB_RECOVERY_FILE_DEST_SIZE, what will happen when RMAN attempts to write more data to it? (Choose the best answer.)
A. If AUTOEXTEND has been enabled and the MAXSIZE has not been reached, the flash recovery area will extend as necessary.
B. The operation will fail.
C. This will depend on whether warning and critical alerts have been enabled for the flash recovery area.
D. RMAN will automatically delete OBSOLETE backups.
E. RMAN will automatically delete EXPIRED backups.

Check back soon!