View the Exhibit and examine the structure of the ORDERS table. NEW_IDRDERS is a new
table with the columns ORD_ID, ORD_DATE, CUST_ID, and ORD_TOTAL that have the
same data types and size as the corresponding columns in the ORDERS table. Evaluate
the following INSERT statement: INSERT INTO new_orders (ord_id, ord_date, cust_id,
ord_total) VALUES(SELECT order_id.order_date.customer_id.order_total FROM orders
WHERE order_date > ‘31- dec-1999’); Why would the INSERT statement fail?
A.
because column names in NEWORDERS and ORDERS tables do not match
B.
because the VALUES clause cannot be used in an INSERT with a subquery
C.
because the WHERE clause cannot be used in a subquery embedded in an INSERT
statement
D.
because the total number of columns in the NEW ORDERS table does not match the
total number of columns in the ORDERS table
Explanation: