Oracle OCP 1Z0 053 Q138(DROP FLASHBACK ARCHIVE)
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
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP 1Z0 053 Q143(Flashback Data Archive)OracleHive
- Oracle OCP 1Z0 053 Q648(Flashback)Oracle
- Oracle OCP 1Z0 053 Q83(Flashback Database)OracleDatabase
- Oracle OCP 1Z0 053 Q373(Flashback Table)Oracle
- Oracle OCP 1Z0 053 Q704(Flashback Versions Query)Oracle
- Oracle OCP 1Z0 053 Q130(flashback transactions)Oracle
- Oracle OCP IZ0-053 Q166(Flashback Data Archive)OracleHive
- Oracle OCP 1Z0-053 Q672(Flashback Data Archive)OracleHive
- Oracle OCP 1Z0 053 Q387(FLASHBACK_TRANSACTION_QUERY)Oracle
- Oracle OCP 1Z0 053 Q63(flashback_transaction_query)Oracle
- Oracle OCP 1Z0 053 Q677(Flashback Transaction Query)Oracle
- flashback drop/query/table/database/archiveDatabaseHive
- Oracle ocp 1Z0 053 Q563(archive-log destination)OracleHive
- Oracle OCP 1Z0 053 Q64(RESETLOGS&LOG_ARCHIVE_FORMAT)OracleHiveORM
- Oracle OCP 1Z0 053 Q618(LOG_ARCHIVE_DEST&Mandatory)OracleHive
- Oracle OCP 1Z0 053 Q43(Flashback Transaction(NOCASCADE_FORCE))Oracle
- Oracle OCP 1Z0 053 Q390(Flashback database&Named restore point)OracleDatabaseREST
- Oracle OCP 1Z0 053 Q511(LOG_ARCHIVE_MIN-SUCCEED_DEST)OracleHive
- Oracle 1Z0 053 Q666(Flashback Table)Oracle
- Oracle OCP 1Z0 053 Q650Oracle
- Oracle OCP 1Z0 053 Q324Oracle
- Oracle OCP 1Z0 053 Q27Oracle
- Oracle OCP 1Z0 053 Q49Oracle
- Oracle OCP 1Z0 053 Q10Oracle
- Oracle OCP 1Z0 053 Q685Oracle
- Oracle OCP 1Z0 053 Q454Oracle
- Oracle OCP 1Z0 053 Q500Oracle
- Oracle Flashback Data ArchiveOracleHive
- 【FLASHBACK】Oracle flashback data archive 介紹OracleHive
- Oracle OCP 1Z0 053 Q444(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q440(Scheduler)Oracle
- Oracle OCP 1Z0 053 Q601Oracle
- Oracle OCP 1Z0 053 Q472(Locale)Oracle
- Oracle OCP 1Z0 053 Q525(ASM)OracleASM
- Oracle OCP 1Z0 053 Q292(NFS)OracleNFS
- Oracle OCP 1Z0 053 Q538(ASM)OracleASM
- Oracle OCP 1Z0 053 Q416Oracle
- Oracle OCP 1Z0 053 Q520Oracle