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.