View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. There is
only one customer with the cus_last_name column having value Roberts. Which INSERT
statement should be used to add a row into the ORDERS table for the customer whose
CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?
A.
INSERT INTO orders VALUES (l.’10-mar-2007\ ‘direct’. (SELECT customerid FROM
customers WHERE cust_last_iiame=’Roberts’ AND credit_limit=600). 1000);
B.
INSERT INTO orders (order_id.order_date.order_mode. (SELECT customer id FROM
customers WHERE cust_last_iiame=’Roberts’ AND redit_limit=600).order_total)
VALUES(L’10-mar-2007′. ‘direct’, &&customer_id, 1000):
C.
INSERT INTO(SELECT o.order_id. o.order_date.o.order_modex.customer_id.
o.ordertotal FROM orders o. customers c WHERE o.customer_id = c.customerid AND
c.cust_la$t_name-RoberTs’ ANDc.credit_liinit=600) VALUES (L’10-mar-2007\ ‘direct’.(
SELECT customer_id FROM customers WHERE cust_last_iiame=’Roberts’ AND
credit_limit=600). 1000);
D.
INSERT INTO orders (order_id.order_date.order_mode. (SELECT customer_id FROM
customers WHERE cust_last_iiame=’Roberts’ AND credit_limit=600).order_total)
VALUES(l.’10-mar-2007\ ‘direct’. &customer_id. 1000):