Which two statements are true when row-archival management is enabled?
A.
The ORA_ARCHIVE_STATE column is updated automatically by the database based on
activity tracking columns, to indicate that a row is no longer considered active.
B.
The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a
query.
C.
The row archival visibility session parameter defaults to all rows.
D.
Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility
session parameter.
E.
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.
Looks like BE
BD
D-Set the archival visibility to ALL for the session. This will allow this session to view all rows, archived or not.
alter session set row archival visibility = all;