ExamQuestions.com

Register
Login
Oracle Database 12c Advanced Administration Exam Questions

Oracle

Oracle Database 12c Advanced Administration

20 / 155

Question 20:

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

Answer options:

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