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