OCP CBT Question 625

Please solve the following question.

To retrieve data from the `EMPLOYEES` table as it appeared exactly one hour ago, without performing a full database restore or affecting the current state of the table, which SQL query syntax should be used?

sql-- Current time is '2023-06-24 11:00:00'.-- You want to see data as of '2023-06-24 10:00:00'.

SELECT * FROM employees AS OF TIMESTAMP SYSDATE - INTERVAL '1' HOUR;

SELECT * FROM employees BEFORE TIMESTAMP SYSDATE - INTERVAL '1' HOUR;

SELECT * FROM employees AT SCN (SELECT TIMESTAMP_TO_SCN(SYSDATE - INTERVAL '1' HOUR) FROM DUAL);

FLASHBACK QUERY ON employees TO TIMESTAMP SYSDATE - INTERVAL '1' HOUR;