1Z0-060 · Question #188
You plan to drop the column of a table that has Flashback Archiving enabled. You want to ensure minimal service disruption. How would you do this in your Oracle 12c Database?
The correct answer is D. Drop the column using the ALTER TABLE statement. Oracle 12c allows dropping a column directly from a Flashback Data Archive-enabled table using ALTER TABLE, without any need to disable or disassociate the archive.
Question
You plan to drop the column of a table that has Flashback Archiving enabled. You want to ensure minimal service disruption. How would you do this in your Oracle 12c Database?
Options
- ADisable Flashback Archiving, set the column unused, and re-enable Flashback Archiving.
- BDisable Flashback Archiving, drop the column unused, and re-enable Flashback Archiving.
- CDisassociate the Flashback Archive using the
- DDrop the column using the ALTER TABLE statement.
- EDisassociate the Flashback Archive using the
How the community answered
(27 responses)- A7% (2)
- C11% (3)
- D78% (21)
- E4% (1)
Why each option
Oracle 12c allows dropping a column directly from a Flashback Data Archive-enabled table using ALTER TABLE, without any need to disable or disassociate the archive.
Disabling and re-enabling Flashback Archiving interrupts archiving continuity and introduces unnecessary service disruption, which contradicts the minimal disruption requirement.
Disabling Flashback Archiving before dropping the column is the pre-12c workaround and causes archiving continuity loss - it is unnecessary in Oracle 12c.
Disassociating the Flashback Archive before a column drop is not required in Oracle 12c, which natively supports DDL on FDA-enabled tables without manual disassociation.
Oracle 12c introduced support for DDL operations - including ALTER TABLE DROP COLUMN - on tables with Flashback Data Archive (FDA) enabled. The database automatically manages the FDA metadata to reflect the column removal, eliminating the need for manual archive disabling and providing minimal disruption.
Like choice C, disassociating the Flashback Archive adds unnecessary steps and potential disruption; Oracle 12c handles this internally when you use ALTER TABLE directly.
Concept tested: Oracle 12c DDL support on Flashback Data Archive-enabled tables
Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/adfns/using-oracle-flashback-technology.html
Topics
Community Discussion
No community discussion yet for this question.