See the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS andITEMS tables:The PROD_ID column is the foreign key in the SALES table, which references thePRODUCTS 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?
See The Exhibit 1 (458.36 KiB) Viewed 150 times
See The Exhibit 2 (1.59 KiB) Viewed 150 times
A. The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match
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 DEFAULT value cannot be specified in the column definition
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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!