1Z0-060 · Question #172
Which two statements are true when row-archival management is enabled? (Choose two.)
The correct answer is A. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query. Row-archival management requires manual updates to the ORA_ARCHIVE_STATE column, and the column only appears in query output when explicitly named in the SELECT list.
Question
Which two statements are true when row-archival management is enabled? (Choose two.)
Options
- AThe ORA_ARCHIVE_STATE column is updated manually or by a program that can reference
- BVisibility of the ORA_ARCHIVE_STATE column is controlled by the ROW ARCHIVAL VISIBILITY
- CThe ROW ARCHIVAL VISIBILITY session parameter defaults to all rows.
- DThe ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
- EThe ORA_ARCHIVE_STATE column is updated automatically by the database based on activity
How the community answered
(25 responses)- A76% (19)
- B4% (1)
- C16% (4)
- E4% (1)
Why each option
Row-archival management requires manual updates to the ORA_ARCHIVE_STATE column, and the column only appears in query output when explicitly named in the SELECT list.
The ORA_ARCHIVE_STATE column is not managed automatically by the database engine - it must be updated explicitly through application logic or manual DML statements to transition rows between active and archived states.
The ROW ARCHIVAL VISIBILITY session parameter controls which rows are returned based on their archival state (ACTIVE or ALL), not whether the ORA_ARCHIVE_STATE column itself appears in the column projection.
The ROW ARCHIVAL VISIBILITY session parameter defaults to ACTIVE, meaning only non-archived rows are returned by default - it does not default to returning all rows regardless of their archival state.
ORA_ARCHIVE_STATE behaves as a hidden column and is excluded from SELECT * results by default; it is only included in the result set when explicitly listed in the SELECT clause of a query.
The database never automatically modifies ORA_ARCHIVE_STATE based on row access or activity; all archival state transitions are entirely application-driven and require explicit column updates.
Concept tested: Oracle row-archival management ORA_ARCHIVE_STATE behavior
Source: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/vldbg/managing-data-lifecycle.html
Topics
Community Discussion
No community discussion yet for this question.