071考试既是ocp11g的考试科目,又是ocp12c的考试科目,所以关注的人很多,由于071考试题多变,我们专门收集了近期的071考试原题,并对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
--------------------------------------------
OCP解析公开课时间:【每周五晚8点】
OCP解析公开课地址:https://ke.qq.com/course/326223
OCP解析群资料分享:1015267481 验证:ocp
另外,除了OCP公开课,OCM题库直播也同步进行中,OCM最新题库大爆料-【每周四晚8点】,【微信群直播】,可以联系咨询老师进群参与