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 customeridFROM customersWHERE cust_last_iiame=’Roberts’ ANDcredit_limit=600). 1000);
B. INSERT INTO orders (order_id.order_date.order_mode. (SELECT customer idFROM customersWHERE cust_last_iiame=’Roberts’ ANDredit_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.ordertotalFROM orders o. customers cWHERE o.customer_id = c.customeridAND c.cust_la$t_name-RoberTs’ ANDc.credit_liinit=600)VALUES (L’10-mar-2007 ‘direct’.( SELECT customer_idFROM customersWHERE cust_last_iiame=’Roberts’ ANDcredit_limit=600). 1000);
D. INSERT INTO orders (order_id.order_date.order_mode.(SELECT customer_idFROM customersWHERE cust_last_iiame=’Roberts’ ANDcredit_limit=600).order_total)VALUES(l.’10-mar-2007 ‘direct’. &customer_id. 1000):
|
Download Printable PDF. VALID exam to help you PASS. |
 |