（166）Exhibit:

SQL>select flashback_archive_name, status from dba_flashback_archive

FLASHBACK_ARCHIVE NA STATUS

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

FLA1

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?

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.

答案：（C）

解析：

DBA_FALSHBACK_ARCHIVE

STATUS列:

1. DEFAULT-表明闪回归档是系统默认的闪回归档

2. NULL

ITPub博客

Oracle 11G OCP 1Z0-053 166