Why would the INSERT statement fail?

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?

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



Leave a Reply 0

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