Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)
A.
Database must be running in archivelog mode.
B.
Automatic undo management must be enabled.
C.
Undo retention guarantee must be enabled.
D.
The tablespace on which the Flashback Data Archive is created must be managed with
Automatic Segment Space Management (ASSM).
Explanation:
http://www.oracle.com/technetwork/database/features/storage/total-recall-whitepaper-171749.pdf?
ssSourceSiteId=ocomen Oracle White Paper- Oracle Total Recall with Oracle Database 11g
Release 2, Page 7
Flashback Data Archive Requirements
1. Flashback Data Archive tablespaces must be managed with automatic segment space
management (ASSM).
2. Automatic Undo Management must be enabled.
http://www.dba-oracle.com/t_11g_new_enabling_fdba.htm
There are a number of restrictions for flashback archives:
– The tablespaces used for a flashback archive must use local extent management and
automatic segment space management.
– The database must use automatic undo management.