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;
The correct answer should be D and E.