138.You are working on the APPDB database as a DBA. The database has a default Flashback Data
Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1:
DROP FLASHBACK ARCHIVE fla1;
What is the effect of this command?
A. The Flashback Archive FLA1 is dropped only if it is empty.
B. The tablespace having Flashback Archive is dropped.
C. The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback
Archive.
D. The Flashback Data Archive and historical data are dropped.
Answer: D

Drop Flashback Data Archive会删除历史数据以及flashback data archive。
官方文档没有提及将存在的数据转移到默认的flashback archive

D错

http://docs.oracle.com/database/121/SQLRF/statements_8016.htm#SQLRF20010

DROP FLASHBACK ARCHIVE

Purpose

Use the DROP FLASHBACK ARCHIVE clause to remove a flashback data archive from the system. This statement removes the flashback data archive and all the historical data in it, but does not drop the tablespaces that were used by the flashback data archive.

ITPub博客

Oracle OCP 1Z0 053 Q138(DROP FLASHBACK ARCHIVE)

DROP FLASHBACK ARCHIVE

最新文章