What is the outcome of this command?

Note the output of the following query:

SQL> SELECTflashback_archive_name,status FROM dba_flashback_archive;
FLASHBACK_ARCHIVE_NAMESTATUS
————————————————————–
FLA1
You executed the following command to enable Flashback Data Archive on the
EXCHANGE_RATE table:
ALTERTABLEexchange_rateFLASHBACK ARCHIVE;
What is the outcome of this command?

Note the output of the following query:

SQL> SELECTflashback_archive_name,status FROM dba_flashback_archive;
FLASHBACK_ARCHIVE_NAMESTATUS
————————————————————–
FLA1
You executed the following command to enable Flashback Data Archive on the
EXCHANGE_RATE table:
ALTERTABLEexchange_rateFLASHBACK ARCHIVE;
What is the outcome of this command?

A.
The table uses the default Flashback Data Archive.

B.
The Flashback Data Archive is created in the SYSAUX tablespace.

C.
The Flashback Data Archive is created in the same tablespace where the tables are stored.

D.
The command generates an error because no Flashback Data Archive name is specified and
there is no default Flashback Data Archive.



Leave a Reply 1

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


Sillyboy

Sillyboy

Correct answer is D.

There is no name specified for the archive in the alter table command, and from the exhibit no archive has the default status.