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.
Answer: D
标准答案是A，是错误的，验证如下：
SQL> create tablespace fla_tbs1 datafile 'C:\Apps\Oracle\oradata\cow\fla1.dbf' size 10M;
表空间已创建。
SQL> create flashback archive fla1 tablespace fla_tbs1 quota 10M retention 1 year;
闪回档案已创建。
SQL> select flashback_archive_name,status from dba_flashback_archive;
FLASHBACK_ARCHIVE_NAME STATUS
------------------------------ -------
FLA1
SQL> alter table scott.dept flashback archive;
alter table scott.dept flashback archive
*
第 1 行出现错误:
ORA-55608: 默认的闪回归档不存在
SQL> alter flashback archive fla1 set default;
闪回档案已变更。
SQL> select flashback_archive_name,status from dba_flashback_archive;
FLASHBACK_ARCHIVE_NAME STATUS
------------------------------ -------
FLA1 DEFAULT
SQL> alter table scott.dept flashback archive;
表已更改。
注意：设置默认闪回归档后，STATUS列下的DEFAULT，题中STATUS列为空，所以答案A是错误的。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2125721/ ，如需转载，请注明出处，否则将追究法律责任。
