See the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and
ITEMS tables: 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 the CREATE TABLE command: Exhibit: 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 FOREIGN KEY constraints defined
on the specified columns would be passed to the new table
C.
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
D.
The NEW_SALES table would not get created because the column names in the
CREATE TABLE command and the SELECT clause do not match