Oracle Database 12c: Advanced Administration — Question 60

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 are D and F because Automatic Undo Management is necessary for managing undo data effectively, and ASSM is required for efficient space management in the tablespace. Options A, B, C, and E are not prerequisites for setting up a Flashback Data Archive.