Oracle Database 12c: Installation and Administration — Question 59

Which two statements are true when row archival management is enabled? (Choose two.)

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 answers are C and D because the ROW ARCHIVAL VISIBILITY session parameter indeed defaults to showing only active rows, and the ORA_ARCHIVE_STATE column is visible when referenced in a query's select list. Options A and B are incorrect as they misrepresent the functionality of the ORA_ARCHIVE_STATE column in relation to its visibility and update mechanism, while option E inaccurately states that the column is updated automatically.