What are the advantages of the
ALTER DATABASE CLEAR LOGFILE command?
Please select all the correct answers.
|The command can be used to clear an online redo log file required for media recovery.
|The command can be used to clear the corrupt redo log file that belongs to the current group.
|The command can be used to clear a corrupt online redo log file even if there are only two online redo log groups.
|This command can be used to clear a corrupted, unarchived online redo log file and makes complete recovery unnecessary.