The following statement is an example of:
CREATE TABLE Customer_t (
CustNmbr number(11,0),
CreditLimit number(6,2),
CustStart date,
CustEnd date,
PERIOD for Custperiod(CustStart,CustEnd));

A) a materialized view.
B) an application time period table.
C) a system-versioned table.
D) a dynamic view.

Question

The following statement is an example of: 
CREATE TABLE Customer_t (
CustNmbr number(11,0),
CreditLimit number(6,2),
CustStart date,
CustEnd date,
PERIOD for Custperiod(CustStart,CustEnd));

A) a materialized view.
B) an application time period table.
C) a system-versioned table.
D) a dynamic view.

Quizplus · Accepted Answer

This statement is an example of an application time period table, which uses the PERIOD FOR clause to define a time period for the validity of the data in the table.

The Following Statement Is an Example Of