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?
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.
I believe that D is the correct answer, In Oracle 11g C was the correct answer but from
https://docs.oracle.com/database/121/ADFNS/adfns_flashback.htm#ADFNS640
16.9.6 DDL Statements on Tables Enabled for Flashback Data Archive
Flashback Data Archive supports only these DDL statements:
- ALTER TABLE statement that does any of the following:
-- Adds, drops, renames, or modifies a column
-- Adds, drops, or renames a constraint
-- Drops or truncates a partition or subpartition operation
This section is not available anymore. Please use the main Exam Page.1z0-060 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Blade69
3 years, 4 months agoChaudhary
5 years, 4 months ago