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

ROW ARCHIVAL VISIBILITY controls which rows are returned by queries based on archive state, not the visibility of the ORA_ARCHIVE_STATE column itself - the statement incorrectly conflates row-level filtering with column-level visibility.

While ORA_ARCHIVE_STATE is indeed updated manually or programmatically, the option as written is truncated and does not form a complete or accurate description that distinguishes it as a true statement.

The ROW ARCHIVAL VISIBILITY session parameter defaults to ACTIVE, which causes queries to automatically exclude archived rows - those with ORA_ARCHIVE_STATE set to a value other than '0'. This default means applications see only active data without requiring any query changes after enabling row archival on a table.

The ORA_ARCHIVE_STATE column is a hidden column, meaning it is not included in SELECT * results, but it is visible and returned when explicitly listed in the SELECT clause of a query. This design allows administrative queries to inspect archive state while keeping it transparent to unmodified application queries.

Oracle Server does not automatically update ORA_ARCHIVE_STATE based on any internal criteria - updating the archive state is entirely the responsibility of the application or DBA using explicit UPDATE statements.