During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery.
Which view or views would you use to determine this information? (Choose all that apply.)
A. V$LOGFILE
B. V$RECOVER_LOG
C. V$RECOVER_DATABASE
D. V$LOG_RECOVER
E. V$LOG
The V$LOGFILE view will given you the name of the online redo logs associated with each group.The V$LOG view will provide the current sequence number assigned to each group.