OCP CBT Question 507

Please solve the following question.

A critical table EMPLOYEES in the HR schema was accidentally truncated by a user at approximately 10:30 AM on October 26, 2023. You need to recover the HR schema to a point just before the TRUNCATE operation. You have a full RMAN backup from the previous night (October 25, 2023, 11:00 PM) and all archived redo logs since then.Examine the RMAN commands below. Which sequence of commands will achieve the desired recovery?

sql-- Assume the database is in MOUNT state for recovery-- You have already connected to RMAN as TARGET database

sqlRESTORE DATABASE;RECOVER DATABASE UNTIL TIME '2023-10-26 10:25:00';

sqlRESTORE TABLESPACE HR;RECOVER TABLESPACE HR UNTIL TIME '2023-10-26 10:25:00';

sqlFLASHBACK DATABASE TO TIMESTAMP '2023-10-26 10:25:00';

sqlRESTORE TABLE HR.EMPLOYEES;RECOVER TABLE HR.EMPLOYEES UNTIL TIME '2023-10-26 10:25:00';