1Z0-067 · Question #148
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…
The correct answer is C. It executes successfully and continues to store metadata related to the EMPLOYEEStable. Flashback data archives retain historical data across data definition language (DDL) changes to the database as long as the DDL change does not affect the structure of the table. The one exception to this rule is that flashback data archives do retain historical data when a…
Question
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?
Options
- AIt gives an error because DDL statements cannot be executed on a table that is enabled for
- BIt executes successfully and all metadata related to the EMPLOYEEStable before altering the
- CIt executes successfully and continues to store metadata related to the EMPLOYEEStable.
- DIt executes successfully but Flashback Data Archive is disabled for the EMPLOYEEStable.
How the community answered
(28 responses)- A4% (1)
- B11% (3)
- C82% (23)
- D4% (1)
Explanation
Flashback data archives retain historical data across data definition language (DDL) changes to the database as long as the DDL change does not affect the structure of the table. The one exception to this rule is that flashback data archives do retain historical data when a column is added to the table. https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_5009.htm
Topics
Community Discussion
No community discussion yet for this question.