1Z0-060 · Question #107
Which two statements are true when row archival management is enabled?
The correct answer is 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. This question tests the default behavior of Oracle In-Database Archiving, including the session parameter default and ORA_ARCHIVE_STATE column visibility rules.
Question
Which two statements are true when row archival management is enabled?
Options
- AThe ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session
- BThe ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity
- CThe ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
- DThe ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
- EThe ORA_ARCHIVE_STATEcolumn is updated automatically by the Oracle Server based on activity
How the community answered
(31 responses)- A3% (1)
- C94% (29)
- E3% (1)
Why each option
This question tests the default behavior of Oracle In-Database Archiving, including the session parameter default and ORA_ARCHIVE_STATE column visibility rules.
The ROW ARCHIVAL VISIBILITY parameter controls which rows are returned (active vs. all), not whether the ORA_ARCHIVE_STATE column itself appears in output - column visibility is governed by explicit referencing in the SELECT list.
While ORA_ARCHIVE_STATE is updated manually, the phrase 'reference activity' is misleading - the column has no automatic activity-based trigger and must be set exclusively through explicit UPDATE statements.
The ROW ARCHIVAL VISIBILITY session parameter defaults to ACTIVE, which causes the database to automatically filter query results to only rows where ORA_ARCHIVE_STATE = '0', hiding archived rows from queries unless the parameter is explicitly changed to ALL.
ORA_ARCHIVE_STATE is a hidden system column not returned by SELECT *, but it becomes fully visible and is included in the result set when it is explicitly named in the SELECT list of a query.
Oracle Server does not automatically update ORA_ARCHIVE_STATE based on any internal activity - applications or DBAs must explicitly UPDATE the column to change a row's archival state.
Concept tested: Oracle In-Database Archiving ORA_ARCHIVE_STATE visibility and defaults
Source: https://docs.oracle.com/database/121/VLDBG/GUID-4E2F5E37-8E09-4B49-BA80-7E25C66D4EFC.htm
Topics
Community Discussion
No community discussion yet for this question.