You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema.
After a few days, you want to alter the EMPLOYEES table by executing the command:
SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);
Which statement is true about the execution of the command?
A.
It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data
Archive.
B.
It executes successfully and all metadata related to the EMPLOYEES table before altering the table
definition is purged from Flashback Data Archive.
C.
It executes successfully and continues to store metadata related to the EMPLOYEES table.
D.
It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.
Ans C