大數據就業實戰培訓 Oracle就業實戰培訓
071考試題庫之前是比較穩定的，但隨著Oracle的調整，071考試不斷的增加新的考題，增加了考試的難度，所以我們專門收集整理了這些考試，并對這些考題進行解析，希望可以對考生有幫助。
每周五晚8點，我們有免費的OCP解析公開課，地址：https://ke.qq.com/course/326223 OCP題庫交流群：1015267481，驗證ocp
-------------------------------------------------------
071考試-第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
