OCP认证051考试题库：11g-v9.02-第154题
最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！
我要咨询OCP认证051考试题库：11g-v9.02-第154题，完整题库请点击这里联系老师咨询了解
154. View the Exhibit and evaluate structures of the SALES, PRODUCTS, and COSTS tables.
Evaluate the following SQL statement:
SQL>SELECT prod_id FROM products
INTERSECT
SELECT prod_id FROM sales
MINUS
SELECT prod_id FROM costs;
Which statement is true regarding the above compound query?
A. It produces an error.
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 shows products that have a cost recorded irrespective of sales.
Answer: C
试题解析：
按照题意，查询出在sales表里的已经卖出去的但是不在costs表里的产品id。
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
返回第一个有，第二个表无的行
