Creating Backup Sets   «Prev  Next»

Backup Sets and Properties in Oracle - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which of the following statements about RMAN backup sets are true?
Please select all the correct answers.
  A. RMAN creates backup sets when it executes a BACKUP command.
  B. ALTER DATABASE BEGIN BACKUP is required before RMAN can create a backup set.
  C. A data file backup set normally stores blocks that have never been used.
  D. A single backup set cannot contain both data file backups and archived redo log backups.

2. Which statements about an RMAN FORMAT specification are true?
Please select all the correct answers.
  A. It can specify the location and naming pattern for backup pieces.
  B. It can contain literal directory and filename characters.
  C. It can contain substitution variables such as %d, %T, and %U.
  D. %U is written literally as the two filename characters % and U.

3. Under which circumstances does RMAN not multiplex blocks from multiple input files into the same backup piece?
Please select all the correct answers.
  A. A data file backup uses FILESPERSET 1.
  B. RMAN creates an image copy instead of a backup set.
  C. RMAN creates a multisection backup of one data file by using SECTION SIZE.
  D. One channel backs up at least four data files with FILESPERSET 4 and MAXOPENFILES 4.

4. Which statements correctly distinguish a backup set from a backup piece?
Please select all the correct answers.
  A. A backup set is a logical unit recorded in the RMAN repository.
  B. A backup piece is a physical file or media-manager object that belongs to a backup set.
  C. Every backup set must contain exactly one backup piece.
  D. A multisection backup set can contain pieces produced independently by multiple channels.

5. Which statements correctly describe FILESPERSET and MAXOPENFILES?
Please select all the correct answers.
  A. FILESPERSET limits the number of input files that RMAN can place in one backup set.
  B. MAXOPENFILES limits how many input files one channel can read concurrently.
  C. The multiplexing level is limited by both MAXOPENFILES and the number of files in the backup set.
  D. Increasing FILESPERSET always causes RMAN to create more backup sets.