You must track all transactions that modify certain tables in the sales schema for at least three
years.
Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions?
A.
Enable supplemental logging for the database.
B.
Specify undo retention guarantee for the database.
C.
Create a Flashback Data Archive in the tablespace where the tables are stored.
D.
Create a Flashback Data Archive in any suitable tablespace.
E.
Enable Flashback Data Archiving for the tables that require tracking.
Explanation:
E: By default, flashback archiving is disabled for any table. You can enable
flashback archiving for a table if you have the FLASHBACK ARCHIVE object privilege on the
Flashback Data Archive that you want to use for that table.
D: 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
/ 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;
D&E
D E
DE
I don’t Understand
D and E.
From the book OCA/OCP oracle database 12c all-in-One exam Guide P. #799
Architecturally, flashback data archive requires one or more tablespaces, … it is technically possible to create the archived in a preexisitng tablespace …
exercise 26-3
point 2. creata e flashback data archive with a retention of 7 years
create flashback archive fla1 tablespace fda retention 7 years;
point 5. create a table and enable the flashback data archive for this table
alter table t1 flashback archive fla1;