1Z0-053 V13.02 Q138

138.You are working on the APPDB database as a DB A. The database has a default Flashback 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

以 管理员 用户身份，删除闪回数据归档。

删除闪回数据归档也会删除内部防篡改历史记录表。由于审计和安全的要求，无法直接删除此表。由于表空间可能包含其它数据，因此删除闪回数据归档不会删除它所在的表空间。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/81227/viewspace-2130887/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/81227/viewspace-2130887/