1z0-060 Exam QuestionsBrowse all questions from this exam

1z0-060 Exam - Question 13


You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.

Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

Show Answer
Correct Answer: ACE

When creating a table with the PERIOD FOR clause to enable Temporal Validity, columns for start and end times (such as employee_time_start and employee_time_end) are automatically created to store temporal data. However, these columns are not populated automatically by the Oracle Server; instead, the application or user must supply the values. Furthermore, enabling valid time flashback at the session level with procedures such as DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML) operations with respect to valid temporal data.

Discussion

1 comment
Sign in to comment
sandrodemontisOptions: CDE
Aug 31, 2020

The answer E it's truncated, but also the answer C is correct