OCP-1Z0-051-2015-52题

QUESTION NO: 52

View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables.

Which statement is true regarding the above compound query?
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
Explanation:

INTERSECT Example The following statement combines the results with the INTERSECT operator, which returns only those unique rows returned by both queries

返回共同有的唯一的行

MINUS Example The following statement combines results with the MINUS operator, which returns only unique rows returned by the first query but not by the second

返回第一个有，第二个表无的行