ocpÌâ¿â½âÎö£º1Z0-051-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 ·µ»Ø¹²Í¬ÓеÄ