Your database instance is abnormally terminated because of a power outage. At the next startup, from which
point in the redo log does the recovery start?
A.
from the last complete checkpoint position
B.
from the beginning of the current redo log file until the instance failure
C.
from the last committed transaction
D.
from the beginning of the current redo log file to the checkpoint position
E.
from the most recent incremental checkpoint
Explanation:
Have a recovery time governed by the number of terminated instances, amount of redo generated in each terminated redo thread since the last checkpoint, and by user-configurable factors such as the number and size of redo log files, checkpoint frequency, and the parallel recovery setting
Reference https://docs.oracle.com/cd/B28359_01/server.111/b28318/startup.htm#CNCPT005
a