OCA DUMPS - Oracle Database 11g: SQL Fundamentals I

1z0-051

QUESTION NO:

1

See the Exhibit:

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