OCP CBT Question 621

Please solve the following question.

You have configured a Flashback Data Archive (FDA) named `HR_ARCHIVE` for the `HR` schema with a retention period of 1 year. The `EMPLOYEES` table is enabled for FDA. Which statement describes a correct behavior or capability when using this FDA configuration?

sqlCREATE FLASHBACK ARCHIVE hr_archive TABLESPACE users RETENTION 1 YEAR;ALTER TABLE employees FLASHBACK ARCHIVE hr_archive;

You can drop the EMPLOYEES table and still query its historical data through the FDA.

Rows deleted from the EMPLOYEES table will automatically be purged from the FDA after 30 days, regardless of the 1-year retention.

Updates and deletes to the EMPLOYEES table are automatically recorded in the FDA for 1 year, allowing SELECT ... AS OF TIMESTAMP queries beyond the UNDO_RETENTION period.

TRUNCATE TABLE employees operations are fully recorded in the FDA and can be flashed back using FLASHBACK TABLE employees TO TIMESTAMP ....