OCP CBT Question 509

Please solve the following question.

You have enabled Flashback Database for your production system to quickly revert the database to a previous point in time in case of logical corruption or user error. You want to ensure that the database can be flashed back to any point within the last 48 hours.Which statement is a mandatory configuration prerequisite or a key characteristic for achieving this goal?

sqlSELECT FLASHBACK_ON, LOG_MODE FROM V$DATABASE;-- Output might be:-- FLASHBACK_ON LOG_MODE-- ------------ -------------- YES ARCHIVELOG

The DB_FLASHBACK_RETENTION_TARGET parameter must be set to at least 2880 minutes (48 hours).

Flashback Database can only be performed when the database is mounted, not open.

Flashback logs are stored in the system undo tablespace.

The database must be operating in NOARCHIVELOG mode.