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_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 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.
Explanation:
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.
A, B and E?
I would go for ABC
Thanks Vonpire!
I think maybe also ABC because regaring E:
Flashback Data Archive supports most common DDL statements, including those that alter the table definition or incur data movement. However, some DDL statements are not supported on Flashback Data Archive-enabled tables.
https://oracle-base.com/articles/12c/temporal-validity-12cr1
Options:
All – Sets the visibility of temporal data to the full table, which is the default temporal table visibility
CURRENT – Sets the visibility of temporal data to currently valid data within the valid time period at the session level
ASOF – Sets the visibility of temporal data to data valid as of the given time as defined by the timestamp
To add it does not say anything specific about DML and DDL operations only this:
ENABLE_AT_VALID_TIME Procedure
This procedure enables session level valid time flashback.
and the above options i mentioned
https://docs.oracle.com/database/121/ARPLS/d_flashb_archive.htm#ARPLS74552
ABC
ABC
A,B,C
A,B – tested
according to below C is correct:
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/ilm/temporal/temporal.html
someone tested C?
ABC