Oracle OCP 1Z0 053 Q138(DROP FLASHBACK ARCHIVE)

abstractcyj發表於2016-04-03
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


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2074519/,如需轉載,請註明出處,否則將追究法律責任。

相關文章