（678）Which are the two prerequisites before setting up Flashback Data Archive?(Choose two.)

A. Flash recovery area must be defined

B. Undo retention guarantee must be enabled.

C. Database must be running in archivelog mode.

D. Automatic undo management must be enabled.

E. The tablespace in which the Flashback Data Archive is created must have automatic segment space Management(ASSM).

答案：（D、E）

解析：

Flashback Data Archive的两个先决条件就是：

Flashback data archive只能在ASSM的tablespace上创建；

Flashback data archive要求必须使用自动undo管理，即undo_management参数为auto

ITPub博客

Oracle 11G OCP 1Z0-053 678