Upgrade to Oracle Database 12c — Question 1

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?

Answer options

• A. Disable Flashback Archiving, set the column unused, and re-enable Flashback Archiving.
• B. Disable Flashback Archiving, drop the column unused, and re-enable Flashback Archiving.
• C. Disassociate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, drop the column, and re-associate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA procedure.
• D. Drop the column using the ALTER TABLE statement.
• E. Disassociate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, set the column unused, and re-associate the Flashback Archive using the DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA procedure.

Correct answer: D

Explanation

The correct answer is D because dropping the column using the ALTER TABLE statement is a straightforward method that does not require disabling Flashback Archiving, ensuring minimal service disruption. The other options involve additional steps that could introduce unnecessary complexity and potential downtime.