What is the effect of this command?

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?

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 tablespace having Flashback Archive is dropped.

B.
The Flashback Data Archive FLA1 is dropped only if it is empty.

C.
The Flashback Data Archive FLA1 and historical data are dropped.

D.
The Flashback Data Archive FLA1 is dropped after moving the existing data in it to the
default Flashback Archive.



Leave a Reply 0

Your email address will not be published. Required fields are marked *