Oracle Exam 1Z0-060 Topic 8 Question 53 Discussion

Actual exam question for Oracle's 1Z0-060 exam

Question #: 53
Topic #: 8

Which two statements are true when row-archival management is enabled? (Choose two.)

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

BVisibility of the ORA_ARCHIVE_STATE column is controlled by the ROW ARCHIVAL VISIBILITY session parameter.

CThe ROW ARCHIVAL VISIBILITY session parameter defaults to all rows.

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

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

Show Suggested Answer

Suggested Answer: B, D

by Timothy at Jan 07, 2023, 10:17 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-060 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!