If a database is restored using before-image dumps, where should the process begin following an interruption?
A.
Before the last transaction
B.
After the last transaction
C.
As the first transaction after the latest checkpoint
D.
As the last transaction before the latest checkpoint
Explanation:
If before images are used, the last transaction in the dump will not have updated the database prior to the dump being taken. The last transaction will not have updated the database and must be reprocessed. Program checkpoints are irrelevant in this situation.
A