ocp-047 delete
来源:互联网 发布:联想传奇电子教室软件 编辑:程序博客网 时间:2024/06/07 00:30
View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS
tables.ORDER_ID is the primary key in the ORDERS table. It is also the foreign
key in the ORDER_ITEMS table where in it is created with the ONDELETE CASCADE
option. Which DELETE statement would execute successfully?
A. DELETE order_id FROM orders WHERE order_total < 1000;
B. DELETE orders WHERE order_total < 1000;
C. DELETE FROM orders WHERE (SELECT order_id FROM order_items);
tables.ORDER_ID is the primary key in the ORDERS table. It is also the foreign
key in the ORDER_ITEMS table where in it is created with the ONDELETE CASCADE
option. Which DELETE statement would execute successfully?
A. DELETE order_id FROM orders WHERE order_total < 1000;
B. DELETE orders WHERE order_total < 1000;
C. DELETE FROM orders WHERE (SELECT order_id FROM order_items);
D.DELETE orders o, order_items I WHERE o.order_id = i.order_id;
A: 没有DELETE order_id这种语法。只能DELETE FROM或者DELETE表名
C: WHERE (SELECT ...) 语法错误。WHERE ORDER_ID IN (SELECT ...)还差不多但是多此一举。
D: 没有DELETE ....表连接这种语法。可以DELETE (SELECT ...表连接) 但也有一些限制。
0 0
- OCP-047 delete
- ocp-047 delete
- OCP-047 delete from ( subquery)
- OCP-1Z0-051 第167题 DELETE语句注意事项
- OCP-1Z0-051 第170题 DELETE的注意事项
- ocp 认证 047
- OCP-047external table
- OCP-047 Pivoting INSERT
- OCP-047 MERGE into
- OCP-047 REGEXP_INSTR()
- OCP-047 time_zone 参数
- OCP-047 CHECK
- ocp-047-13
- ocp-047-15
- ocp-047-17
- ocp-047-24
- ocp-047-23
- ocp-047-45
- 神奇的go语言(基本语法)
- Active Directory的主要还原,Active Directory系列之五
- Uva 11090 最短路径
- 部署额外域控制器,Active Directory系列之四
- USCOJ 1231 Triangles(HUST 校赛题)
- ocp-047 delete
- 用备份进行Active Directory的灾难重建:Active Directory系列之三
- windows下编译openssl源码
- 部署第一个域:Active Directory系列之二
- leetcode: Merge k Sorted Lists
- poj 2786:Pell数列
- 为什么我们需要域?Active Directory系列之一
- 灵活选择抛出异常
- 用PXE方法从裸机批量推Oracle11gR2 RAC成套环境