Oracle Database 12c: Installation and Administration — Question 26

Backup requirements for a database:
* Level 0 backup on Sunday
* Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday
* Differential incremental level 1 backup on Tuesday, Thursday, and Friday
Which three statements are true about the strategy? (Choose three.)

Answer options

• A. Level 0 backup on Sunday contains all the blocks that have been formatted.
• B. Level 0 backup on Sunday contains all the blocks that have been changed since the last level 1 backup.
• C. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 1 backup.
• D. Level 1 backup on Monday, Wednesday, and Saturday contains all the blocks that have been changed since the last level 0 backup.
• E. Level 1 backup on Tuesday, Thursday, and Friday contains all the blocks that have been changed since the last level 0 backup.

Correct answer: B, D, E

Explanation

Option B is correct because the Level 0 backup captures all blocks formatted since the last backup. Option D is correct as it states that the Level 1 backup on Monday, Wednesday, and Saturday includes changes since the last Level 0 backup. Option E is true since the Level 1 backups on Tuesday, Thursday, and Friday track changes since the last Level 0 backup, while options A and C incorrectly describe the nature of Level 0 and Level 1 backups.