Free 1Z0-071 Web TestEngine Demo

Q10 Single choice

The PROD_ID column is the foreign key in the SALES table.Which references the PRODUCTS table.

Similarly,the CUST_ID and TIME_ID columns are Also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.

Evaluate the following CREATE TABLE command:

CREATE TABLE new_sales(prod_id, I cust_id, order_date DEFAULT SYSDATE)

AS SELECT I prod_id,cust_id,time_id FROM sales.

Which statement is true regarding the above command?

A
The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.
B
The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.
C
The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause I do not match.
D
The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table

1Z0-071 Web TestEngine demo