nerdexam
Oracle

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.

New Features for Manageability

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)
  • A
    76% (19)
  • B
    4% (1)
  • C
    16% (4)
  • E
    4% (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.

AThe ORA_ARCHIVE_STATE column is updated manually or by a program that can referenceCorrect

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.

BVisibility of the ORA_ARCHIVE_STATE column is controlled by the ROW ARCHIVAL VISIBILITY

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.

CThe ROW ARCHIVAL VISIBILITY session parameter defaults to all rows.

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.

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

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.

EThe ORA_ARCHIVE_STATE column is updated automatically by the database based on activity

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

#row archival#ORA_ARCHIVE_STATE#ROW ARCHIVAL VISIBILITY#ILM

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice