Oracle
1Z0-063 · Question #116
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: create table employees (empno number, salary…
The correct answer is A. The valid time columns employee_time_start and employee_time_end are automatically created. B. The same statement may filter on both transaction time and valid temporal time by using the AS E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME. See the full explanation below for the reasoning.
Question
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: create table employees (empno number, salary number, deptid number, name varchar2(100), period for employee_time); Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?
Options
- AThe valid time columns employee_time_start and employee_time_end are automatically created.
- BThe same statement may filter on both transaction time and valid temporal time by using the AS
- CThe valid time columns are not populated bythe Oracle Server automatically.
- DThe valid time columns are visible by default when the table is described.
- ESetting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME
How the community answered
(26 responses)- A81% (21)
- C8% (2)
- D12% (3)
Community Discussion
No community discussion yet for this question.