Oracle数据库之【OCP-12c】CUUG 071题库考试原题及答案解析(21)_MongoDB_青云站长教程网
欢迎来到站长教程网!
  • 秒到短信接口 免费试用
  • 微信支付宝接口 秒结算
  • 中文网站排名|申请加入
  • 搜索引擎全站查询
  • 查询移动网站权重数据
  • 海外主机 台湾公司直销
  • MongoDB

    当前位置:主页 > 数据库 > MongoDB >

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

    时间:2019-08-03|栏目:MongoDB|点击:
  • 本文主要向大家介绍了Oracle数据库之【OCP-12c】CUUG 071题库考试原题及答案解析(21),通过具体的内容向大家展现,希望对大家学习Oracle数据库有所帮助。

    Oracle数据库之【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'));

    上一篇:MySQL数据库之解决Linux下MySQL启动错误

    栏    目:MongoDB

    下一篇:Oracle数据库之MySQL和Oracle相关

    本文标题:Oracle数据库之【OCP-12c】CUUG 071题库考试原题及答案解析(21)

    本文地址:http://www.jh-floor.com/shujuku/MongoDB/15168.html

    广告投放 | 联系我们 | 版权申明

    重要申明:本站所有的文章、图片、评论等,均由网友发表或上传并维护或收集自网络,属个人行为,与本站立场无关。

    如果侵犯了您的权利,请与我们联系,我们将在24小时内进行处理、任何非本站因素导致的法律后果,本站均不负任何责任。

    联系QQ:888888 | 邮箱:888888#qq.com(#换成@)

    Copyright © 2002-2017 青云站长教程网 版权所有 琼ICP备xxxxxxxx号