nerdexam
Oracle

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.

New Features for Manageability

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)
  • A
    7% (2)
  • C
    11% (3)
  • D
    78% (21)
  • E
    4% (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.

ADisable Flashback Archiving, set the column unused, and re-enable Flashback Archiving.

Disabling and re-enabling Flashback Archiving interrupts archiving continuity and introduces unnecessary service disruption, which contradicts the minimal disruption requirement.

BDisable Flashback Archiving, drop the column unused, and re-enable Flashback Archiving.

Disabling Flashback Archiving before dropping the column is the pre-12c workaround and causes archiving continuity loss - it is unnecessary in Oracle 12c.

CDisassociate the Flashback Archive using the

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.

DDrop the column using the ALTER TABLE statement.Correct

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.

EDisassociate the Flashback Archive using the

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

#Flashback Data Archive#DDL operations#column drop#ALTER TABLE

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice