A user wants to create two copies of the following table:
CREATE TABLE table_1(
column1 INTEGER NOT NULL
, column2 INTEGER NOT NULL
, column3 DATE FORMAT 'YYYY-MM-DD'
, column4 INTEGER DEFAULT 1000
, FOREIGN KEY (column2) REFERENCES WITH NO CHECK OPTION Parent_table1(column1))
PRIMARY INDEX (column1)
PARTITION BY RANGE_N(column3
BETWEEN DATE '2009-01-01' AND DATE '2011-12-31' EACH INTERVAL '1' DAY);
COLLECT STATISTICS ON table_1 INDEX (column1);
COLLECT STATISTICS ON table_1 COLUMN PARTITION;
CREATE TABLE table_2 AS table_1 WITH DATA AND STATISTICS;
CREATE TABLE table_3 AS (SELECT * FROM table_1) WITH DATA AND STATISTICS;
Which two statements are true about these two CREATE TABLE AS statements? (Choose two.)
- table_3 will not be partitioned.
- table_3 will have the DEFAULT column attribute from table_1.
- table_2 will have the referential integrity column from table_1.
- table_2 will have statistics on the system-derived PARTITION column from table_1.
Reveal Solution
Next Question