Which statement is true regarding the above command?
A. The NEW_ORDERS table would not get created because the DEFAULT value cannot be specified in the column definition.
B. The NEW_ORDERS table would get created and only the NOT NULL constraint defined on the specified columns would be passed to the new table.
C. The NEW_ORDERS table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.
D. The NEW_ORDERS table would get created and all the constraints defined on the specified columns in the ORDERS table would be passed to the new table.
Answer:B
Which statement is true regarding the above command?
A. The NEW_ORDERS table would not get created because the DEFAULT value cannot be specified in the column definition. B. The NEW_ORDERS table would get created and only the NOT NULL constraint defined on the specified columns would be passed to the new table. C. The NEW_ORDERS table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match. D. The NEW_ORDERS table would get created and all the constraints defined on the specified columns in the ORDERS table would be passed to the new table.