ocpÌâ¿â½âÎö£º1Z0-051-V9.02-µÚ160Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

160. View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.

There is only one customer with the cust_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 (1,'10-mar-2007', 'direct',

(SELECT customer_id

FROM customers

WHERE cust_last_name='Roberts' AND

credit_limit=600), 1000);

B. INSERT INTO orders (order_id,order_date,order_mode,

(SELECT customer_id

FROM customers

WHERE cust_last_name='Roberts' AND

credit_limit=600),order_total)

VALUES(1,'10-mar-2007', 'direct', &&customer_id, 1000);

C. INSERT INTO(SELECT o.order_id, o.order_date,o.order_mode,c.customer_id, o.order_total

FROM orders o, customers c

WHERE o.customer_id = c.customer_id

AND c.cust_last_name='Roberts' ANDc.credit_limit=600 )

VALUES (1,'10-mar-2007', 'direct',(SELECT customer_id

FROM customers

WHERE cust_last_name='Roberts' AND

credit_limit=600), 1000);

D. INSERT INTO orders (order_id,order_date,order_mode,

(SELECT customer_id

FROM customers

WHERE cust_last_name='Roberts' AND

credit_limit=600),order_total)

VALUES(1,'10-mar-2007', 'direct', &customer_id, 1000);

Answer: A

ÊÔÌâ½âÎö£º

Ö»ÓÐÒ»¸öcustomerµÄcust_last_nameÁеÄÖµÊÇRoberts¡£

ÌâÒâÎÊÄÄÒ»¸öINSERTÓï¾äÄܱ»ÓÃÓÚ¸øORDERSÌí¼ÓÒ»ÐУ¬customerµÄcust_last_nameΪRoberts£¬²¢ÇÒCREDIT_LIMITΪ600£¬Ö»ÓÐAÕýÈ·

BCDÓï·¨´íÎó¡£