OCP 1Z0 051 QUESTION NO: 44

QUESTION NO: 44 
 
See the Exhibits and examine the structures of PRODUCTS, SALES and CUSTOMERS table:

You issue the following query:
 
SQL>SELECT p.prod_id,prod_name,prod_list_price,  
quantity_sold,cust_last_name 
FROM products p NATURAL JOIN sales s NATURAL JOIN customers c 
WHERE prod_id =148; 
Which statement is true regarding the outcome of this query? 
 
Which statement is true regarding the outcome of this query?
 
 
A. It produces an error because the NATURAL join can be used only with two tables 
B. It produces an error because a column used in the NATURAL join cannot have a qualifier 
C. It produces an error because all columns used in the NATURAL join should have a qualifier 
D. It executes successfully 

Answer: B

与正式题库120重复

http://blog.csdn.net/jgmydsai/article/details/26961031