第110题-OCP认证062考试题库2019最新考题解析
最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！
我要咨询2018年的时候，OCP 11g考试题库大更新，052 053出现了很多新题，
2019年，11g即将停考的前期，Oracle又出现了一次大变动，12c出现了很多新题，比如062 063题库大更新
OCP解析公开课时间：【每周五晚8点】
OCP解析公开课地址：http://ke.qq.com/course/326223
OCP解析群资料分享：1015267481 验证：ocp
-------------------------------------------------------
QUESTION 110
You create a table with t he PERIOD FOR clause to enable the use of t he 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 t he Valid Time Temporal feature for the EMPLOYEES table?
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 OF TIMESTAMP and PERIOD FOR clauses.
C. The valid time columns are not populated by the Oracle Server automatically.
D. The valid time columns are visible by default when t he table is described.
E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets t he visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.
Correct Answer: ABE
