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 column names in NEW_ODRDERS 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 *