OCP CBT Question 618

Please solve the following question.

You are administering an Oracle database. A user accidentally updated a large number of rows in the `EMPLOYEES` table, committing the transaction. You want to revert the `EMPLOYEES` table to its state just before the erroneous update, minimizing downtime and data loss for other objects. The table has `ROW MOVEMENT` enabled. Which command should you execute to achieve this?

sqlSELECT SCN_TO_TIMESTAMP(DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER) FROM DUAL;-- Suppose this returns '24-JUN-23 10.00.00.000000000 AM'-- Erroneous update occurs at SCN 1234567, corresponding to TIMESTAMP '24-JUN-23 10.05.00.000000000 AM'-- Current SCN is 1234570, corresponding to TIMESTAMP '24-JUN-23 10.10.00.000000000 AM'

FLASHBACK DATABASE TO SCN 1234566;

FLASHBACK TABLE employees TO TIMESTAMP TO_TIMESTAMP('24-JUN-23 10.00.00.000000000 AM', 'DD-MON-RR HH.MI.SS.FF AM');

RESTORE DATABASE TO SCN 1234566;

RECOVER TABLE employees TO TIMESTAMP TO_TIMESTAMP('24-JUN-23 10.00.00.000000000 AM', 'DD-MON-RR HH.MI.SS.FF AM');