Note the output of the following query;
SQL> SELECT flashback_archieve_name, status FROM dba_flashback_archieve;
FLASHBACK_ARCHIEVE_NAME STATUS
—————————————- ———–FLA1
You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIEVE;
What is the outcome of this command?
A.
The table uses the default Flashback Data Archive.
B.
The Flashback Data Archive Is created In the SYSAUX tablespace.
C.
The Flashback Data Archive is created in the same tablespace where the tables are stored.
D.
The command generates an error because no flashback Data Archive name is specified and
there is no default Flashback Data Achieve.
Correct answer is D I think.
I agree with you. Here is the test case:
SQL> create flashback archive fla1 tablespace users quota 10m retention 1 year;
Flashback archive created.
SQL> SELECT flashback_archive_name, status FROM dba_flashback_archive;
FLASHBACK_ARCHIVE_NAME STATUS
—————————— ————–
FLA1
SQL> alter table hr.employees flashback archive;
alter table hr.employees flashback archive
*
ERROR at line 1:
ORA-55608: Default Flashback Archive does not exist
SQL> alter table hr.employees flashback archive fla1;
Table altered.
yes, it looks like it should be D.
DBA_FLASHBACK_ARCHIVE
STATUS – Indicates whether the flashback archive is a default flashback archive for the system (DEFAULT) or not (NULL)