Which two statements are true when row archival management is enabled?
A.
The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
B.
The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server
based on activity tracking columns, to Indicate that a row is no longer considered active.
C.
The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL
VISIBILITY session parameter.
D.
The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
E.
The ORA_ARCHIVE_STATE column is updated manually or by a program that could
reference activity tracking columns, to indicate that a row is no longer considered active.
AD
I consider something genuinely interesting about your website so I saved to bookmarks.
http://www.bastcilkdoptb.com/
AD is correct.
Oracle provide a demo showing usage of row archival:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/ilm/row_archival/row_archival.html
Agree that AD are correct.
What about E?
B and E are exclusive options.
I know this column is not updated automatically, so it should be manual.
Any comments?