ocpÌâ¿âÔõô±³£º11g-051-V9.02-µÚ168Ì⣬ÍêÕûÌâ¿âÇëµã»÷ÕâÀïÁªÏµÀÏʦ×ÉѯÁ˽â

168. View the Exhibit and examine the description of SALES and PROMOTIONS tables.

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.)

delete from sales

where promo_id=(select promo_id from promotions where)

A. DELETE FROM sales

WHERE promo_id = (SELECT promo_id

FROM promotions

WHERE promo_name = 'blowout sale')

AND promo_id = (SELECT promo_id

FROM promotions

WHERE promo_name = 'everyday low price');

B. DELETE FROM sales

WHERE promo_id = (SELECT promo_id

FROM promotions

WHERE promo_name = 'blowout sale')

OR promo_id = (SELECT promo_id

FROM promotions

WHERE promo_name = 'everyday low price');

C. DELETE FROM sales

WHERE promo_id IN (SELECT promo_id

FROM promotions

WHERE promo_name = 'blowout sale'

OR promo_name = 'everyday low price');

D. DELETE FROM sales

WHERE promo_id IN (SELECT promo_id

FROM promotions

WHERE promo_name IN ('blowout sale','everyday low price'));

Answer: BCD

ÊÔÌâ½âÎö£º

ÌâÒâÒªÇ󣺴ÓSALES±íÖÐɾ³ýÐУ¬Ìõ¼þΪPROMOTIONS±íÖÐPROMO_NAMÁеÄֵΪblowout sale»òÕßeveryday low price)

BCDÕâÈý¸öÑ¡ÏîÊǵȼ۵ġ£

¶øAµÄwhereÌõ¼þÖеÄAND²»Âú×ãÌâÒâÒªÇó¡£