Which statement is true about the execution of the command?

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?

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.



Leave a Reply 2

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


yogui

yogui

C

Flashback Data Archive supports only these DDL statements:

ALTER TABLE statement that does any of the following:

Adds, drops, renames, or modifies a column
Adds, drops, or renames a constraint
Drops or truncates a partition or subpartition operation