nerdexam
Oracle

1Z0-063 · Question #30

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

The correct answer is B. 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. See the full explanation below for the reasoning.

Question

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

Options

  • AVisibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session
  • BThe ORA_ARCHIVE_STATE column is updated manually or by a program that can reference
  • 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

(24 responses)
  • A
    4% (1)
  • B
    83% (20)
  • C
    8% (2)
  • E
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-063 Practice