Which two statements are true when row-archival management is enabled? (Choose two.)
Posted: Sun Jun 11, 2023 3:51 pm
Which two statements are true when row-archival management is enabled? (Choose two.)
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.
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.