View the Exhibit and examine the structure of the ORDERS table.
NEW_ORDERS 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?
because column names in NEW_ORDERS and ORDERS tables do not match
because the VALUES clause cannot be used in an INSERT with a subquery
because the WHERE clause cannot be used in a subquery embedded in an INSERT statement
because the total number of columns in the NEW_ORDERS table does not match the total number of columns in the ORDERS table