OCP-1Z0-051 第168题使用子查询DELETE数据

最新推荐文章于 2022-11-03 16:54:50 发布

原创最新推荐文章于 2022-11-03 16:54:50 发布 · 4.1k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#OCP-1Z0-051 #DELETE #子查询 #subquery #11g

OCP-1Z0-051 专栏收录该内容

220 篇文章

订阅专栏

本文提供了一道关于 SQL 的练习题，要求从 SALES 表中删除与 PROMOTIONS 表中特定促销名称相关联的记录。给出了四种不同的 DELETE 语句，并解释了哪些语句是有效的。

一、原题

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

答案：BCD

二、题目翻译

看SALES和PROMOTIONS表的结构:
要从SALES表中删除行，条件为PROMOTIONS表中PROMO_NAM列的值为blowout sale或者everyday low price。
哪个DELETE语句有效?(选择所有正确的项)

三、题目解析

A选项不正确，题目要求的是PROMO_NAM列的值为blowout sale或者everyday low price，而A选项中，是用的AND,得出的结果就不是题目想要的结果。
BCD选项正确。