Valid 1z0-067 Dumps shared by PrepAwayExam.com for Helping Passing 1z0-067 Exam! PrepAwayExam.com now offer the newest 1z0-067 exam dumps, the PrepAwayExam.com 1z0-067 exam questions have been updated and answers have been corrected get the newest PrepAwayExam.com 1z0-067 dumps with Test Engine here:
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?
Correct Answer: C
Explanation/Reference: 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. References: https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_5009.htm