Oracle
1Z0-067 · Question #163
1Z0-067 Question #163: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-067 to reveal the answer and full explanation for question #163. The question stem and answer options stay visible for context.
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 by the Oracle Server automatically.
- DThe valid time columns are visible by default when the table is described.
- ESetting the session valid time using
Unlock 1Z0-067 to see the answer
You've previewed enough free 1Z0-067 questions. Unlock 1Z0-067 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.