YOU ISSUE THE COMMAND ALTER DATABASE CLEAR LOGFILE GROUP 2, AND IT...

2. You issue the command ALTER DATABASE CLEAR LOGFILE GROUP 2, and

it fails with the message “ORA-01624: log 2 needed for crash recovery of

instance orcl11g (thread 1).” What could be an explanation for this? (Choose

the best answer.)

A. Log file group 2 is active.

B. Log file group 2 is being used for recovery.

C. The database has not been checkpointed.

D. The group is not multiplexed.