Oracle
1Z0-067 · Question #164
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_STATEcolumn 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
(17 responses)- A6% (1)
- B76% (13)
- C6% (1)
- E12% (2)
Community Discussion
No community discussion yet for this question.