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?

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?

Accepted Answer

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 C. The valid time columns are not populated by the Oracle Server automatically.

Answer

D. The valid time columns are visible by default when the table is described.

Answer

E. Setting the session valid time using

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…

Question

Options

How the community answered

Explanation

Topics

Community Discussion