DB2 10 for z/OS Database Administrator — Question 2

A production database has the following daily midnight backup schedule which includes all table spaces. The database incurs the same volume of daily activity
(inserts, updates, and deletes).

Sunday Delta -

Monday Incremental -

Tuesday Delta -

Wednesday Delta -

Thursday Incremental -

Friday Delta -

Saturday Full -
Which day would you expect a RECOVER DATABASE following that days backup to take the longest time to complete?

Answer options

• A. Friday
• B. Monday
• C. Saturday
• D. Wednesday

Correct answer: A

Explanation

A full backup on Saturday captures the entire database, making it the most comprehensive and requiring the longest recovery time. In contrast, the other backup types (delta and incremental) only capture changes since the last backup, leading to shorter recovery times.