Why would the INSERT statement fail?

View the Exhibit and examine the structure of the ORDERS table. NEWJDRDERS 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?

View the Exhibit and examine the structure of the ORDERS table. NEWJDRDERS 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 the VALUES clause cannot be used in an INSERT with a subquery

B.
because the WHERE clause cannot be used in a subquery embedded in an INSERT
statement

C.
because the total number of columns in the NEW ORDERS table does not match the
total number of columns in the ORDERS table

D.
because column names in NEW_ODRDERS and ORDERS tables do not match



Leave a Reply 0

Your email address will not be published. Required fields are marked *