nerdexam
Oracle

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.

New Features for Storage

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)
  • A
    3% (1)
  • C
    94% (29)
  • E
    3% (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.

AThe ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session

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.

BThe ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity

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.

CThe ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.Correct

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.

DThe ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.Correct

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.

EThe ORA_ARCHIVE_STATEcolumn is updated automatically by the Oracle Server based on activity

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

#row archival#ILM#ORA_ARCHIVE_STATE#ROW ARCHIVAL VISIBILITY

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice