1. |
The complete recovery method, recovering a datafile with no backup, can be used in which of the following situations?
Please select the best answer.
|
|
A. |
The corrupted datafiles belong to the system tablespace and have no backup, but all archived logs exist since the file was created.
|
|
B. |
The corrupted datafiles have no backup and all archived logs exist since the file was created. |
|
C. |
The datafiles needing recovery have no backup and some of the archived logs since the creation of these datafiles are damaged.
|
|
D. |
The damaged datafile belongs to a rollback segment tablespace and has no backup, but all archived logs exist since the datafile was created. |
|
The correct answer is B. B is correct because you can perform a complete recovery to a datafile with no backup as long as all archived logs exist since the file was created. A and D are incorrect because this method cannot be applied to any datafiles that belong to either a system or rollback segment tablespace. C is incorrect because the existence of the archived logs since the creation is one of the requirements for using this recovery method.
|