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
Starting in Oracle 12c, Oracle provides a new feature (ORA_ARCHIVE_STATE) that allow you to "logically delete" a row in a table without physically removing the row. This effectively makes deleted rows "invisible" to all SQL and DML, but they can be revealed at any time, providing a sort of "instant" rollback method.
B,D. Because the visibility on ORA_ARCHIVE_STATE column, just depend if a DBA incluide that columns on a SELECT, buy the session parameter ROW ARCHIVAL VISIBILITY just controls which rows are going to be displayed on fetch results.
upvoted 3 times
...
This section is not available anymore. Please use the main Exam Page.1z0-067 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
RodrigoEscobedo
2 years, 4 months agoJachp
4 years, 5 months ago