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: Which three statements are
true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?
A.
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.
B.
The valid time columns are visible by default when the table is described.
C.
The valid time columns employee_time_start and employee_time_end are automatically
created.
D.
The same statement may filter on both transaction time and valid temporal time by using
the AS OF TIMESTAMP and PERIOD FOR clauses.
E.
The valid time columns are not populated by the Oracle Server automatically.
CDE
Agree CDE
Why not A?
DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME does not work on DDL, only on DML.
Full visibility applies to DDL
see:
http://imgur.com/a/vPTpl
ACD
CDE
C,D,E
agree – C,D,E
Hi, i have passed my Oracle 1Z0-060 exam last week, score of my 1Z0-060 exam: Section 1 = 90%; Section 2 = 92% (the passing score: Section 1 = 64%; Section 2 = 65%, both sections must be passed to pass 1Z0-060 exam). All 85 questions (Section 1 = 51q; Section 2 = 34q) were multiple choice questions, most of them were easy to answer, but few questions on Core Administration and Performance Management were a little difficult.
And, I learned valid 1Z0-060 dumps here: http://www.passleader.com/1z0-060.html (recommend to get FULL VERSION 1Z0-060 VCE dumps and PDF dumps for learning).
Good Luck!
P.S. Free 1Z0-060 PDF dumps from Google Drive: https://drive.google.com/open?id=0B-ob6L_QjGLpNjQta2dQSmFJLWs
how to meditate
http://www.dYNihcArR6.com/dYNihcArR6