OCP CBT Question 690

Please solve the following question.

You are managing an Oracle database with a configured Flash Recovery Area (FRA). You notice that RMAN backups are failing with errors indicating a lack of space in the FRA. Which statement accurately describes the default behavior of Oracle when the FRA reaches full capacity?

The Flash Recovery Area (FRA) is a designated disk location that Oracle Database can use to store and manage a variety of files related to backup and recovery, including RMAN backups, archived redo logs, and flashback logs. Its size is controlled by the DB_RECOVERY_FILE_DEST_SIZE parameter. You can examine current FRA settings using:
SHOW PARAMETER DB_RECOVERY_FILE_DEST;
SHOW PARAMETER DB_RECOVERY_FILE_DEST_SIZE;

Oracle automatically purges the oldest files from the FRA until sufficient space is available.

The database halts activity for any operations that attempt to create new files in the FRA until space is freed manually.

Oracle moves the oldest files from the FRA to an alternative recovery location, if configured.

The database switches to NOARCHIVELOG mode to prevent further growth of archived redo logs in the FRA.