View the Exhibit and examine the output.
You executed the following command to enable Flashback Data Archive on the
EXCHANGE_RATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIVE;
What is the outcome of this command?
Exhibit:
A.
The Flashback Archive is created on the same tablespace where the tables are stored.
B.
The Flashback Archive is created on the SYSAUX tablespace.
C.
The command generates an error because no Flashback Archive name is specified and
there is no default Flashback Archive.
D.
The table uses the default Flashback Archive.
The next statement specifies tracking for the oe.customers table. The flashback data archive is not specified, so data will be archived in the default flashback data archive, test_archive1:
ALTER TABLE oe.customers
FLASHBACK ARCHIVE;
Answer is D
The exhibit shows you that there’s not default flashback archive, if it was the output of the query would be something like this:
SQL> select flashback_archive_name, status from dba_flashback_archive;
FLASHBACK_ARCHIVE_NAME
——————————————————————————–
STATUS
——-
FDA1
DEFAULT