Creating Backup Sets   «Prev  Next»

Oracle Parallelism and Backup Sets - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which factors can affect how much useful concurrent work RMAN performs during a backup?
Please select all the correct answers.
  A. The number of channels allocated or configured for the device type
  B. The number of independent backup sets, input files, or file sections available for processing
  C. The FILESPERSET value used to group input files into backup sets
  D. The filename template specified by the FORMAT clause

2. Assume CONFIGURE CONTROLFILE AUTOBACKUP OFF. Which command automatically includes the current control file in the data file backup set?
Please select the best answer.
  A. BACKUP DATAFILE 1;
  B. BACKUP DATAFILE 2;
  C. BACKUP TABLESPACE USERS;
  D. BACKUP ARCHIVELOG ALL;

3. Which commands use valid RMAN syntax to select archived redo logs for backup?
Please select all the correct answers.
  A. BACKUP ARCHIVELOG ALL;
  B. BACKUP ARCHIVELOG UNTIL TIME 'SYSDATE-1';
  C. BACKUP ARCHIVELOG FROM SCN 500000;
  D. BACKUP ARCHIVELOG = '/archive/log1.arc';

4. Which statements about RMAN multisection backups are true?
Please select all the correct answers.
  A. SECTION SIZE divides a large data file into contiguous ranges of blocks.
  B. Multiple channels can back up different sections of one large data file concurrently.
  C. The section pieces belong to the same multisection backup set.
  D. SECTION SIZE can be combined with MAXPIECESIZE in the same backup.

5. Which statements correctly describe RMAN backup-set multiplexing?
Please select all the correct answers.
  A. One channel can read blocks from multiple input files and write those blocks into the same backup piece.
  B. FILESPERSET affects how many input files can belong to one backup set.
  C. MAXOPENFILES limits how many input files one channel can read concurrently.
  D. Multiplexing uses several channels to back up different sections of one large data file.