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…

Question

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

• A
  72% (47)
• C
  8% (5)
• D
  20% (13)

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.

No community discussion yet for this question.