Which two statements are true when row archival managem…

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

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

A.
The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session
parameter.

B.
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.

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.

E.
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.

Explanation:
http://gavinsoorma.com/2013/08/oracle-12c-new-feature-in-database-archiving/



Leave a Reply 0

Your email address will not be published. Required fields are marked *