OCP CBT Question 569

Please solve the following question.

A critical batch job mistakenly updated all employee salaries to zero. You realize the error quickly and want to revert the database to its state before the batch job started. Flashback Database is enabled, and the flashback retention target is sufficient. The batch job started at 14:00. Which set of commands would you use to efficiently revert the database?

sql-- Database name: ORCL-- Flashback Database is enabled.-- Flashback retention target is set to 24 hours.-- Logical corruption occurred at 2023-07-01 14:00:00.

sqlSHUTDOWN IMMEDIATE;STARTUP MOUNT;FLASHBACK DATABASE TO TIMESTAMP '2023-07-01 13:59:00';ALTER DATABASE OPEN RESETLOGS;

sqlSHUTDOWN IMMEDIATE;STARTUP MOUNT;RESTORE DATABASE UNTIL TIME '2023-07-01 13:59:00';RECOVER DATABASE UNTIL TIME '2023-07-01 13:59:00';ALTER DATABASE OPEN RESETLOGS;

sqlFLASHBACK TABLE EMPLOYEES TO TIMESTAMP '2023-07-01 13:59:00';

sqlFLASHBACK DATABASE TO SCN (SELECT MAX(CHECKPOINT_CHANGE#) FROM V$DATAFILE WHERE FILE# = 1);ALTER DATABASE OPEN;