Upgrade Oracle DBA 11g to Oracle Database 12c — Question 50

Which two are prerequisites for setting up Flashback Data Archive?

Answer options

• A. Fast Recovery Area should be defined.
• B. Undo retention guarantee should be enabled.
• C. Supplemental logging should be enabled.
• D. Automatic Undo Management should be enabled.
• E. All users using Flashback Data Archive should have unlimited quota on the Flashback Data Archive tablespace.
• F. The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled.

Correct answer: D, F

Explanation

The correct answers, D and F, are prerequisites because Automatic Undo Management is essential for managing undo data effectively, and ASSM is required for the tablespace to efficiently handle segment space. Options A, B, C, and E are not required for the Flashback Data Archive setup, although they may be relevant for other Oracle functionalities.