OCP-1Z0-051 第168题 使用子查询DELETE数据
来源:互联网 发布:单片机密码锁编程 编辑:程序博客网 时间:2024/06/05 04:23
一、原题
二、题目翻译
三、题目解析
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
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语句有效?(选择所有正确的项)
要从SALES表中删除行,条件为PROMOTIONS表中PROMO_NAM列的值为blowout sale或者everyday low price。
哪个DELETE语句有效?(选择所有正确的项)
三、题目解析
A选项不正确,题目要求的是PROMO_NAM列的值为blowout sale或者everyday low price,而A选项中,是用的AND,得出的结果就不是题目想要的结果。
BCD选项正确。
BCD选项正确。
1 0
- OCP-1Z0-051 第168题 使用子查询DELETE数据
- OCP-1Z0-051 第169题 使用子查询DELETE数据
- OCP-1Z0-051 第165题 使用子查询update多列数据
- OCP-1Z0-051 第135题 子查询注意事项
- OCP-1Z0-051 第145题 子查询嵌套
- OCP-1Z0-051 第136题 子查询的使用
- OCP-1Z0-051 第140题 子查询中使用GROUP BY注意事项
- OCP-1Z0-051 第148题 子查询和ANY,ALL的使用
- OCP-1Z0-051 第159题 insert语句中使用子查询
- OCP-1Z0-051 第160题 insert中使用子查询
- OCP-1Z0-051 第164题 UPDATE语句中使用子查询
- OCP-1Z0-051 第166题 使用子查询update表中的多列
- OCP-1Z0-051 补充题库 第8题 子查询的使用范围
- OCP-1Z0-051 第8题 子查询和多表关联查询和情况
- OCP-1Z0-051 补充题库 第5题 主查询和子查询的注意事项
- OCP-1Z0-051 第167题 DELETE语句注意事项
- OCP-1Z0-051 第170题 DELETE的注意事项
- OCP-1Z0-051 第133题 子查询的用法
- EncapsulationTest
- 简述php关于网页元素抓取方面的技术
- hdu-1247 Hat’s Words
- C语言中返回字符串函数的四种实现方法
- oracle的体系结构
- OCP-1Z0-051 第168题 使用子查询DELETE数据
- (10)JS之按下不同的按钮显示不同的颜色
- Java能扮演嵌入式开发主角吗?
- 12.4日期类
- JAVA之类的构造与对象初始化
- 写给准备参加秋招的学弟学妹们~一定要来看哦~
- 【Espruino】NO.04 让灯自由闪动
- Java用于嵌入式系统的十大优点和五个局限
- Android修炼之道—自定义控件 (300喵喵币)