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?

Question

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?

Accepted Answer

B. because the VALUES clause cannot be used in an INSERT with a subquery

Answer

A. because column names in NEW_ORDERS and ORDERS tables do not match

Answer

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

Answer

D. because the total number of columns in the NEW_ORDERS table does not match the total number

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…

Question

Options

How the community answered

Community Discussion