OCP 1Z0 051 QUESTION NO: 52

QUESTION NO: 52 
 
View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables.
 
 Evaluate the following SQL statements:
  
 
Which statement is true regarding the above compound query?
 
SQL>SELECT prod_id FROM products 
INTERSECT 
SELECT prod_id FROM sales 
MINUS 
SELECT prod_id FROM costs; 

A. It shows products that have a cost recorded irrespective of sales 
B. It shows products that were sold and have a cost recorded 
C. It shows products that were sold but have no cost recorded 
D. It reduces an error 
Answer: C

与正式题库154重复

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