OCP 1Z0 051 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); 

B  insert 对应的字段是错的（customer_id ---> order_id）
C 可以向视图里插入数据，但只能向简单视图里插入

INSERT INTO(SELECT o.order_id, o.order_date,o.order_mode,c.cust_id, o.order_totalFROM orders o, sh.customers cWHERE o.customer_id = c.cust_idAND c.cust_last_name='Roberts' AND c.cust_credit_limit=600)VALUES (1,'10-mar-2007', 'direct',(SELECT cust_idFROM sh.customersWHERE cust_last_name='Roberts' ANDcust_credit_limit=600), 1000)ORA-01776: cannot modify more than one base table through a join viewSQL> 

D insert into 表名（这里面只能跟字段列表，不能有子查询）

Answer: A