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.
Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.

B.
The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity
tracking columns, to indicate that a row is no longer considered active.

C.
The row archival visibility session parameter defaults to all rows.

D.
The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.

E.
The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking
columns, to indicate that a row is no longer considered active.



Leave a Reply 2

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


MS

MS

ANS C,D

A – is not right.