See the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS andITEMS tables:The PROD_ID column is the fo
Posted: Wed Jun 07, 2023 6:12 am
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?
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
- See The Exhibit 1 (458.36 KiB) Viewed 177 times
- See The Exhibit 2 (1.59 KiB) Viewed 177 times
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