Oracle Database 12c: Advanced Administration — Question 86

You create a default Flashback Data Archive FLA1 and 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?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because altering the EMPLOYEES table while it is enabled for Flashback Data Archive does not affect its ability to store metadata. Option A is incorrect as DDL statements can be executed on such tables, while B is wrong because metadata is not purged upon alteration. Option D is also false since Flashback Data Archive remains enabled after the change.