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;
DE
DE
D and E
DE – OK
http://www.dummies.com/how-to/content/basics-of-oracle-12cs-flashback-data-archive.html
DE
DE
A E
DE are correct
http://www.dummies.com/how-to/content/basics-of-oracle-12cs-flashback-data-archive.html
DE
its a Flashback Data Archive feature
D,E are correct
Always a huge fan of linking to bloggers that I enjoy but do not get a lot of link enjoy from.
Here is a great Weblog You might Find Intriguing that we encourage you to visit.
please check out the websites we comply with, which includes this one particular, as it represents our picks through the web
the time to study or take a look at the content or websites we have linked to below the
please stop by the web-sites we comply with, including this a single, as it represents our picks from the web
Every after in a although we select blogs that we study. Listed below would be the latest web-sites that we pick out
please stop by the web sites we adhere to, such as this one particular, as it represents our picks from the web
just beneath, are many entirely not connected web pages to ours, on the other hand, they are surely really worth going over
the time to read or visit the subject material or web-sites we have linked to below the
usually posts some incredibly intriguing stuff like this. If you are new to this site
just beneath, are quite a few totally not connected web sites to ours, even so, they are certainly worth going over
Here are several of the sites we recommend for our visitors
just beneath, are various absolutely not related internet sites to ours, having said that, they are surely worth going over
Here is an excellent Weblog You may Come across Interesting that we Encourage You
please visit the web pages we stick to, like this 1, as it represents our picks in the web
check beneath, are some totally unrelated web sites to ours, however, they are most trustworthy sources that we use
Here are some of the sites we suggest for our visitors
Here are a number of the sites we advocate for our visitors
although internet websites we backlink to beneath are considerably not associated to ours, we feel they may be actually really worth a go through, so possess a look
Every the moment in a while we decide on blogs that we read. Listed beneath would be the newest internet sites that we decide on
usually posts some incredibly exciting stuff like this. If youre new to this site
we came across a cool site which you may well get pleasure from. Take a appear if you want
below youll find the link to some web sites that we consider it is best to visit
that could be the end of this article. Here you will discover some web pages that we assume you will appreciate, just click the hyperlinks over
one of our guests not long ago proposed the following website
Sites of interest we have a link to
that will be the finish of this post. Here youll locate some sites that we feel youll enjoy, just click the hyperlinks over
below youll uncover the link to some web pages that we think you need to visit