Upgrade Oracle DBA 11g to Oracle Database 12c — Question 37

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

Answer options

• A. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
• B. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.
• C. The row archival visibility session parameter defaults to all rows.
• D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
• E. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer

Correct answer: A, D

Explanation

Answer A is correct because the row archival visibility session parameter does indeed control the visibility of the ORA_ARCHIVE_STATE column. Answer D is also correct as the column is visible when included in the select list of a query. The other options are incorrect because B and E incorrectly describe how the ORA_ARCHIVE_STATE column is updated, and C inaccurately states the default behavior of the row archival visibility session parameter.