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

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 闪回数据归档。

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

 

参考： http://blog.csdn.net/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 does not 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.

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