【OCP-12c】CUUG 071题库考试原题及答案解析(21)

3.choose three

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 three DELETE statements are valid?

A) 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');

B) 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');

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:ACD

上一篇:在Firefox浏览器中关闭缓存.命令


下一篇:redhat 7部署oracle 12c、18c安装乱码解决