Upgrade to Oracle Database 12c — Question 30

Which two statements are true when row archival management is enabled?

Answer options

• A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
• B. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
• C. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
• D. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
• E. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer

Correct answer: C, D

Explanation

The correct statements are C and D because the ROW ARCHIVAL VISIBILITY session parameter indeed defaults to active rows only, and the ORA_ARCHIVE_STATE column is visible when included in a query's select list. Options A and B are incorrect as they misrepresent the conditions of visibility and updating of the ORA_ARCHIVE_STATE column, while option E inaccurately states that the update is automatic.