See the Exhibit and Examine the structure of SALES and PROMOTIONS tables:
Exhibit:
You want to delete rows from the SALES table, where the PROMO_NAME column in the PROMOTIONS table has either blowout sale or everyday low price as values.
Which DELETE statements are valid? (Choose all that apply.)
A. DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = ‘blowout sale’)AND promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = ‘everyday low price’);
B. DELETEFROM salesWHERE promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = ‘blowout sale’)OR promo_id = (SELECT promo_idFROM promotionsWHERE promo_name = ‘everyday low price’);
C. DELETEFROM salesWHERE promo_id IN (SELECT promo_idFROM promotionsWHERE promo_name = ‘blowout sale’OR promo_name = ‘everyday low price’);
D. D DELETEFROM salesWHERE promo_id IN (SELECT promo_idFROM promotionsWHERE promo_name IN (‘blowout sale’,’everyday low price’));
|
Download Printable PDF. VALID exam to help you PASS. |
 |