View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables. The PROD_ID column is the foreign key in the SALES table referencing the PRODUCTS table. The CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively. Examine this command:

CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE) AS SELECT prod_id, cust_id, time_id FROM sales; Which statement is true?

Question

View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables. The PROD_ID column is the foreign key in the SALES table referencing the PRODUCTS table. The CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively. Examine this command:

CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE) AS SELECT prod_id, cust_id, time_id FROM sales; Which statement is true?

Accepted Answer

D. The NEW_SALES table would get created and all the NOT NULL constraints defined on the

Answer

A. The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the

Answer

B. The NEW_SALES table would not get created because the column names in the CREATE

Answer

C. The NEW_SALES table would not get created because the DEFAULT value cannot be specified

View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables. The PROD_ID column is the foreign key in the SALES table referencing the PRODUCTS table. The CUST_ID…

Question

Exhibit

Options

How the community answered

Community Discussion