Oracle Exam 1Z0-067 Topic 7 Question 62 Discussion

Actual exam question for Oracle's 1Z0-067 exam

Question #: 62
Topic #: 7

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?

AIt gives an error because DDL statements cannot be executed on a table that is enabled for Flashback Data Archive.

BIt executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.

CIt executes successfully and continues to store metadata related to the EMPLOYEES table.

DIt executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.

Show Suggested Answer

Suggested Answer: C

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

by Marguerita at Dec 12, 2022, 04:08 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-067 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!