Oracle 11G OCP 1Z0-053 166

（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部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1259659/，如需轉載，請註明出處，否則將追究法律責任。