150.View the Exhibit and examine the data in the PROMOTIONS table.

最新推荐文章于 2016-03-23 11:25:33 发布

今年我18

最新推荐文章于 2016-03-23 11:25:33 发布

阅读量758

点赞数

CC 4.0 BY-SA版权

分类专栏： 1z0-051 文章标签： 1z0-051

本文链接：https://blog.youkuaiyun.com/dwj19830118/article/details/50845142

1z0-051 专栏收录该内容

175 篇文章

订阅专栏

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';
答案：AD
解析：这里考察的是INTERSECT和MINUS
INTERSECT：获取a表和b表的交集
MINUS：获取a表中排除b表数据的集合
题目说的是不包含discount的数据，那么
A:正确,总的数据减去包含discount的数据，剩下的也就是不包含的数据了
B:错误,总的数据与包含discount的数据的交集，也就是包含discount的数据
C:错误,总的数据减去不包含discount的数据，剩下的也就是包含的数据了
D:正确,总的数据与不包含discount的数据的交集，也就是不包含discount的数据