Topic: 1z0-082 topic 1 question 119

Examine the description of the SALES table:



The SALES table has 55,000 rows.

Examine this statement:



Which two statements are true? (Choose two.)

A.
SALES1 is created with l row.
B.
SALES1 is created with no rows.
C.
SALES1 has primary KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.
D.
SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.
E.
SALES1 is created with 55,000 rows.

Re: 1z0-082 topic 1 question 119

DE is correct,
tested with two tables ports and ports1
create table ports1 (port_id,port_name,country) as select port_id,port_name, country from ports where 1=1;

Re: 1z0-082 topic 1 question 119

D E is correct

  • j_tw
  • New member
  • Offline

Re: 1z0-082 topic 1 question 119

DE
//
D - At using subquery to make table, only 'Not Null' constraint will be copied