Multiple choice technology databases

You are using the following command to clear the log file group ALTER DATABASE CLEAR LOGFILE GROUP 2; In which case would the command be successful?

  1. Group 2 is the active group

  2. Group 2 is the current group

  3. Database is in the MOUNT stage

  4. Group 2 has been already archived
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The ALTER DATABASE CLEAR LOGFILE GROUP command succeeds only when the log group has been archived. This prevents accidental loss of redo data needed for recovery. The command fails if the group is current (actively being written), active (needed for crash recovery), or if the database is not in the appropriate state. The database must be at MOUNT stage to execute this command.

Keep practicing — related questions