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):
|
Download Printable PDF. VALID exam to help you PASS. |
 |