Oracle Database 12c: Advanced Administration — Question 83

Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?

Answer options

Correct answer: B

Explanation

Option B is correct because it specifies a level 0 backup on Sunday, which captures all data, followed by differential incremental backups on Wednesday and Friday that include changes since the last full backup. The cumulative incremental level 1 backups on other days align with the requirement of only backing up changes since the last day's backup. The other options do not correctly match the specified backup strategy outlined in the requirements.