Oracle
1Z0-063 · Question #21
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 EMPLOYEES table. See the full explanation below for the reasoning.
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 The command fails because container is not set to current); 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 EMPLOYEES table before altering the
- 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.
How the community answered
(16 responses)- A6% (1)
- B13% (2)
- C75% (12)
- D6% (1)
Community Discussion
No community discussion yet for this question.