Examice

Exam 1z0-082 All QuestionsBrowse all questions from this exam

Go to Exam

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.)

SALES1 is created with l row.

SALES1 is created with no rows.

SALES1 has primary KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.

SALES1 has NOT NULL constraints on any selected columns which had those constraints in the SALES table.

SALES1 is created with 55,000 rows.

Correct Answer: B, D

The statement 'CREATE TABLE sales1 AS SELECT ... FROM sales WHERE 1=1;' creates a new table sales1 with the same columns as specified in the SELECT query but without any data because the WHERE clause condition '1=1' doesn't filter any rows (which essentially means 'true' for all rows). Thus, SALES1 is created with no rows. Additionally, the NOT NULL constraints on the selected columns (product_id, customer_id, quantity_sold, and price) from the SALES table are retained in the new table SALES1.

Discussion

j_twOptions: DE

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

Darkseid1231Options: DE

D E is correct

Oracle2020Options: DE

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;