Prev Question
Next Question

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

Prev Question
Next Question

Leave a Reply

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