What is the outcome of this command?

View the Exhibit and examine the output.

You executed the following command to enable Flashback Data Archive on the
EXCHANGE_RATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIVE;
What is the outcome of this command?

View the Exhibit and examine the output.

You executed the following command to enable Flashback Data Archive on the
EXCHANGE_RATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIVE;
What is the outcome of this command?

A.
The table uses the default Flashback Archive.

B.
The Flashback Archive is created on the SYSAUXtablespace.

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

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



Leave a Reply 2

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


mogukiller

mogukiller

The answer D is wrong. Flashback Archive name is not necesary where there in one by default.

Carlos Monteiro

Carlos Monteiro

answer D is correct, as it is shown in the output the Status column does not is Default so there is not default flashback archive created.