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 considered active.