Oracle Database Administration II — Question 180

Which three are true about a whole database backup? (Choose three.)

Answer options

• A. It can consist of either backup sets or image copies.
• B. It is the only possible backup type for a database in NOARCHIVELOG mode.
• C. It can be consistent.
• D. It can be created only by using RMAN.
• E. It can be inconsistent.
• F. It always includes all data files, the current control file, the server parameter file, and archived redo logs.

Correct answer: A, C, E

Explanation

Options A, C, and E are correct because a whole database backup can be made up of backup sets or image copies (A), can be consistent if taken while the database is in a consistent state (C), and can also be inconsistent if taken during active transactions (E). Options B, D, and F are incorrect as a backup in NOARCHIVELOG mode can include other types, backups can be created using different methods besides RMAN, and not all backups necessarily include archived redo logs.