Identify the statement that is true about Flashback Data Archive.(Choose the best answer.)

A. You can use multiple tablespaces for an archive, and each archive can have its own retention time.

B. You can have one archive, and for each tablespace that is part of the archive you can specify a different retention period.

C. You can use multiple tablespaces for an archive, and you can have more than one default archive per retention period.

D. If you specify a default archive, it must exist in only one tablespace.

Answer: C

SQL> create tablespace fdatbs1 datafile 'C:\Apps\Oracle\oradata\cow\fdatbs1.dbf' size 10m;

表空间已创建。

SQL> create tablespace fdatbs2 datafile 'C:\Apps\Oracle\oradata\cow\fdatbs2.dbf' size 10m;

表空间已创建。

SQL> create tablespace fdatbs3 datafile 'C:\Apps\Oracle\oradata\cow\fdatbs3.dbf' size 10m;

表空间已创建。

SQL> create flashback archive fda1 tablespace fdatbs1 quota 10m retention 1 year;

闪回档案已创建。

SQL> create flashback archive fda2 tablespace fdatbs2 quota 10m retention 3 year;

闪回档案已创建。

SQL> alter flashback archive fda2 add tablespace fdatbs3;

闪回档案已变更。

SQL> select flashback_archive_name,retention_in_days from dba_flashback_archive;

FLASHBACK_ARCHIVE_NAME         RETENTION_IN_DAYS

------------------------------ -----------------

FDA1                                         365

FDA2                                        1095

SQL> select flashback_archive_name,tablespace_name from dba_flashback_archive_ts;

FLASHBACK_ARCHIVE_NAME         TABLESPACE_NAME

------------------------------ ------------------------------

FDA1                           FDATBS1

FDA2                           FDATBS2