138.You are working on the APPDB database as a DB A. The database has a defaultFlashback Data
Archive DFLA1 created on it. You issued the following command to drop theFlashback 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
答案解析:
以 管理员用户身份,删除 FLA1 闪回数据归档。
DROP FLASHBACK ARCHIVE
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.
You must have the FLASHBACK
ARCHIVE
ADMINISTER
system privilege to drop a flashback data archive.
flashback_archive
Specify the name of the flashback data archive you want to drop.
官方参考:http://docs.oracle.com/cd/E16655_01/server.121/e17209/statements_8016.htm#SQLRF20010