Oracle
1Z0-060 · Question #223
1Z0-060 Question #223: Real Exam Question with Answer & Explanation
The correct answer is A: Both Transaction Time and Temporal Validity time dimensions may be used as filters in the same. Oracle 12c In-Database Archiving and Temporal Validity are distinct features with separate time dimension semantics and database-enforced visibility behaviors.
Question
Which three statements are true about the use of the In-Database Archiving and Temporal Validity features of Oracle Database 12c? (Choose three.)
Options
- ABoth Transaction Time and Temporal Validity time dimensions may be used as filters in the same
- BTemporal Validity spans the time between a row insert and a subsequent update or delete for the
- CIn-Database Archiving is based on application-managed setting of the life-cycle state.
- DTemporal Validity time is based on the times specified by the application.
- EInactive rows that have been archived are always invisible.
Explanation
Oracle 12c In-Database Archiving and Temporal Validity are distinct features with separate time dimension semantics and database-enforced visibility behaviors.
Common mistakes.
- B. The period from row insert to a subsequent update or delete describes Transaction Time, which is system-managed; Temporal Validity is an application-specified valid-time period that is independent of when DML operations occur.
- C. In-Database Archiving visibility is enforced by the database through the ROW ARCHIVAL VISIBILITY session parameter and the ORA_ARCHIVE_STATE column, making it a database-controlled feature rather than a purely application-managed lifecycle mechanism.
Concept tested. Oracle 12c Temporal Validity and In-Database Archiving time dimensions
Community Discussion
No community discussion yet for this question.