Creating Backup Sets   «Prev  Next»

Backup Sets and Properties in Oracle - Quiz

Backup Sets and Their properties - Quiz

Each question is worth one point. Select the best answer or answers for each question.

1. Which of the following statements about backup sets are true?
Please select all the correct answers.
  A. Recovery Manager creates a backup set.
  B. You must issue alter database commands to create backup sets with Recovery Manager.
  C. A backup set includes unused data blocks from data files.
  D. A backup set cannot combine data from data files and archive logs.

2. Which of the following statements are true about the format option for the backup command?
Please select all the correct answers.
  A. The format option must be followed by a format spec in single quotes.
  B. The format spec can include literals.
  C. The format spec can include substitution variables, which are usually in the form of a percentage sign followed by a lowercase letter.
  D. The format option must be followed by a format spec in double quotes.

3. Under which of the following circumstances will multiplexing of data blocks in a backup piece NOT occur?
Please select all the correct answers.
  A. When no filesperset option is specified and multiple data files are specified
  B. When a filesperset option is specified that is greater than the number of files indicated for the backup set
  C. When a filesperset option is specified that is equal to than the number of files indicated for the backup set
  D. When a filesperset option is specified that is less than the number of files indicated for the backup set