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?
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
Explanation:
E?
https://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV687
Recovering tables and table partitions from RMAN backups is useful in the following scenarios:
You want to recover data that is lost after a DDL operation modified the structure of tables. Using Flashback Table is not possible because a DDL was run on the tables between the desired point in time and the current time. Flashback Table cannot rewind tables through structural changes such as a truncate table operation.