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?
A. The valid time columns employee_time_startand employee_time_endare automatically created.
A.将自动创建有效的时间列 employee_time_startand employee_time_endare
B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
B.同一语句可以使用AS OF TIMESTAMP and PERIOD FOR进行过滤 子句的时间戳和句点。
C. The valid time columns are not populated by the Oracle Server automatically.
D. The valid time columns are visible by default when the table is described.
E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.
E。使用 DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME 设置会话有效时间设置会话执行的数据操作语言(DML)、数据定义语言(DDL)和查询的可见性。
Correct Answer: ABE
时间有效期管理(Temporal Validity)以下简称 TV,TV 的功能大致上可以这样描述:在表中手动或者自动建两个时间类型的字段,一个表示有效期的开始时间,一个表示有效期的结束时间,就可以通过设置让只有在有效期内的记录才会被选择出来。
A: To implement Temporal Validity (TV), 12c offers the option to have two date columns in that table which is having TV enabled using the new clause Period For in the Create Table for the newly created tables or in the Alter Table for the existing ones. The columns that are used can be defined while creating the table itself and will be used in the Period For clause or you can skip having them in the table’s definition in the case of which, the Period For clause would be creating them internally.
E: ENABLE_AT_VALID_TIME Procedure This procedure enables session level valid time flashback.