OCP-1Z0-053-V12.02-138题

youli3

　　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 FLASHBACKARCHIVE fla1;
　　What is the effect of this command?
　　A. The FlashbackArchive 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 闪回数据归档。
注：删除闪回数据归档也会删除内部防篡改历史记录表。由于审计和安全的要求，无法直接删除此表。由于表空间可能包含其它数据，因此删除闪回数据归档不会删除它所在的表空间。 参考：http://blog.iyunv.com/rlhua/article/details/12222819　　
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 doesnot drop the tablespaces that were used by the flashback data archive.
　　Prerequisites
　　You must have the FLASHBACK ARCHIVE ADMINISTER system privilege to drop a flashback data archive.
http://onexin.iyunv.com/source/plugin/onexin_bigdata/file:///C:/Users/Administrator/AppData/Local/Temp/Wiz/816e79b4-1b89-4161-99ee-17db5bcbd8be_128_files/17069379.png
　　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
　　
         版权声明：本文为博主原创文章，未经博主允许不得转载。