Oracle Database 12c: Advanced Administration — Question 92

Your database is running in ARCHIVELOG mode and flashback is enabled.
In which scenario must you use RMAN backups for recovering tables and table partitions?

Answer options

• A. when recovering a table to a point in time
• B. when recovering a table that has been logically corrupted
• C. when recovering dropped tables that are present in the recyclebin
• D. when recovering the data of a table to the desired point in time, which is more recent that the oldest available undo
• E. when recovering data that was lost after a DDL operation modified the structure of a table

Correct answer: A

Explanation

The correct answer is A, as RMAN backups are required for point-in-time recovery, which is not achievable with flashback. Options B, C, D, and E do not necessitate RMAN backups since those scenarios can be resolved using other recovery methods like flashback or the recycle bin.