OCP-047 delete from ( subquery)
来源:互联网 发布:网络写手兼职 编辑:程序博客网 时间:2024/06/07 05:26
252. View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS
tables.You need to remove from the ORDER_ITEMS table those rows that have
an order status of 0 or 1 in the ORDERS table.
Which DELETE statements are valid? (Choose all that apply.)
A. DELETE FROM order_items
WHERE order_id IN (SELECT order_id
FROM orders WHERE order_status in (0,1));
B. DELETE * FROM order_items
WHERE order_id IN (SELECT order_id
FROM orders WHERE order_status IN (0,1));
C. DELETE FROM order_items i
WHERE order_id = (SELECT order_id FROM orders o
WHERE i.order_id = o.order_id AND order_status IN (0,1));
tables.You need to remove from the ORDER_ITEMS table those rows that have
an order status of 0 or 1 in the ORDERS table.
Which DELETE statements are valid? (Choose all that apply.)
A. DELETE FROM order_items
WHERE order_id IN (SELECT order_id
FROM orders WHERE order_status in (0,1));
B. DELETE * FROM order_items
WHERE order_id IN (SELECT order_id
FROM orders WHERE order_status IN (0,1));
C. DELETE FROM order_items i
WHERE order_id = (SELECT order_id FROM orders o
WHERE i.order_id = o.order_id AND order_status IN (0,1));
WHERE i.order_id = o.order_id AND order_status IN (0,1));
Answer: ACD
但是D被证明是错误的
SQL> DELETE FROM (SELECT *
2 FROM order_items i, orders o
3 WHERE i.order_id = o.order_id
4 AND order_status IN (0, 1)) ;
DELETE FROM (SELECT *
FROM order_items i, orders o
WHERE i.order_id = o.order_id
AND order_status IN (0, 1))
ORA-01752: 不能从没有一个键值保存表的视图中删除
- OCP-047 delete from ( subquery)
- OCP-047 delete
- ocp-047 delete
- OCP-047insert into subquery with check option values()
- Alternative DELETE Command, Using a Subquery
- Subquery
- SQL: DELETE FROM FROM
- DELETE * FROM和DELETE FROM的区别
- delete from“表名”
- delete from PF_Annoy_Call_List
- PHP MySQL Delete From
- Delete snapshot from volume
- delete from... not exisits
- Delete from join 用法
- OCP-1Z0-051 补充题库 第31题 subquery子查询的注意事项
- 047 the steps for a correlated subquery
- Oralce中delete和delete from
- SQL DELETE FROM的用法
- Android Launcher 内存分析
- shell 版本
- research paper for one sight
- Bootstrap学习笔记
- SAP table类型
- OCP-047 delete from ( subquery)
- web聊天室及时清理离线用户(最简单的方法)
- python3 获取网页内容保存到文件
- HBase 0.94.1的编译过程
- java更改文件名
- ATPCS概述
- 有5个海盗,按照等级从5到1降序排列。
- 三星ODIN刷机包的修改
- viewcontroller的成员变量和属性在viewdidunload中的不同处理方式