Oracle Database Administration II — Question 54

Which four are true about RMAN backup sets? (Choose four.)

Answer options

• A. A backup piece can belong to only one backup set.
• B. A data file can be split into multiple sections stored in different backup sets.
• C. A data file can be split into multiple sections stored in different backup pieces in the same backup set.
• D. Blocks from multiple data files can be contained in one backup piece.
• E. A backup set can contain only one backup piece.
• F. A backup set must be written to media.
• G. A backup set must be written to disk.
• H. Blocks from multiple data files can be contained in one backup set.

Correct answer: A, C, D, H

Explanation

The correct answers A, C, D, and H accurately describe the characteristics of RMAN backup sets. For example, A emphasizes that a backup piece is unique to a backup set, while C and D highlight the flexibility in how data files and blocks can be organized. Options B, E, F, and G are incorrect as they misrepresent the relationships and requirements of backup sets and pieces.