Which two statements are true when row archival management is enabled?
A.
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 considered active.
B.
The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
C.
The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
D.
The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL
VISIBILITY session parameter.
E.
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.
B E
Not sure about C
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/ilm/row_archival/row_archival.html
B,E