OCP认证051考试题库：11g-v9.02-第150题
最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！
我要咨询OCP认证051考试题库：11g-v9.02-第150题，完整题库请点击这里联系老师咨询了解
150. View the Exhibit and examine the data in the PROMOTIONS table.
You need to display all promo categories that do not have 'discount' in their subcategory.
Which two SQL statements give the required result? (Choose two.)
A. SELECT promo_category
FROM promotions
MINUS
SELECT promo_category
FROM promotions
WHERE promo_subcategory = 'discount';
B. SELECT promo_category
FROM promotions
INTERSECT 交集
SELECT promo_category
FROM promotions
WHERE promo_subcategory = 'discount';
C. SELECT promo_category
FROM promotions
MINUS
SELECT promo_category
FROM promotions
WHERE promo_subcategory <> 'discount';
D. SELECT promo_category
FROM promotions
INTERSECT
SELECT promo_category
FROM promotions
WHERE promo_subcategory <> 'discount';
Answer: AD
试题解析：
本题意是让找出不包含promo_subcategory = 'discount'的产品。
MINUS 返回第一个查询有，第二个查询无的
INTERSECT 返回共同有的
