When setting up the Flashback Data Archive, which of these key parameters are required?
(Choose all that apply.)
A.
Tablespace name
B.
Storage quota
C.
Retention
D.
Table name
E.
Create a default archive
which of these key parameters are required?
When setting up the Flashback Data Archive, which of these key parameters are required?
(Choose all that apply.)
A and C are correct:
https://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_flashback.htm#BJFBJCCF
Create a default Flashback Data Archive named fla1 that uses up to 10 G of tablespace tbs1, whose data will be retained for one year:
CREATE FLASHBACK ARCHIVE DEFAULT fla1 TABLESPACE tbs1
QUOTA 10G RETENTION 1 YEAR;
Create a Flashback Data Archive named fla2 that uses tablespace tbs2, whose data will be retained for two years:
CREATE FLASHBACK ARCHIVE fla2 TABLESPACE tbs2 RETENTION 2 YEAR;
From the same link:
Creating a Flashback Data Archive
Create a Flashback Data Archive with the CREATE FLASHBACK ARCHIVE statement, specifying the following:
Name of the Flashback Data Archive
Name of the first tablespace of the Flashback Data Archive
(Optional) Maximum amount of space that the Flashback Data Archive can use in the first tablespace
The default is unlimited. Unless your space quota on the first tablespace is also unlimited, you must specify this value; otherwise, you will get error ORA-55621.
Retention time (number of days that Flashback Data Archive data for the table is guaranteed to be stored)