Examine the structure of the sales table:
Evaluate the following create table statement:
Which two statements are true about the creation of the SALES1 table?
A.
The SALES1 table is created with no rows but only a structure.
B.
The SALES1 table would have primary key and unique constraints on the specified
columns.
C.
The SALES1 table would not be created because of the invalid where clause.
D.
The SALES1 table would have not null and unique constraints on the specified columns.
E.
The SALES1 table would not be created because column-specified names in the select
and create table clauses do not match,
Below 2 are correct.
A. The SALES1 table is created with no rows but only a structure.
D.The SALES1 table would have not null and unique constraints on the specified columns.
only not null constraints are “transferred”
Exactly, only not null constraints are “transferred”
A
In addition, primary keys, unique keys, foreign keys, check constraints, partitioning criteria, indexes,
and column default values are not carried over to the new table.
create table t1(first_name varchar2(10) not null, last_name varchar2(10)unique);
create table t2 (first_name, last_name) as select first_name,last_name from t1 where 1=2;
if you check the structure of table t2 you don’t find the unique constrainte on the column last_name.
A