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_categoryFROM promotionsMINUSSELECT promo_categoryFROM promotionsWHERE promo_subcategory = ‘discount’;
B. SELECT promo_categoryFROM promotionsINTERSECTSELECT promo_categoryFROM promotionsWHERE promo_subcategory = ‘discount’;
C. SELECT promo_categoryFROM promotionsMINUSSELECT promo_categoryFROM promotionsWHERE promo_subcategory <> ‘discount’;
D. SELECT promo_categoryFROM promotionsINTERSECTSELECT promo_categoryFROM promotionsWHERE promo_subcategory <> ‘discount’;
|
Download Printable PDF. VALID exam to help you PASS. |
 |