【第38题】OCP认证1Z0-071最新考试题库及答案

071考试不仅是OCP11g的考试科目，同时也是OCP 12c的考试科目，所以关心071考题的同学有很多，对此我们专门收集整理了近期071考试的原题，并对这些考题进行讲解，希望帮助广大考生顺利通过071考试。

--------------------------------------------

071考题解析-第38题、choose two

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 two DELETE statements are valid? (Choose two.)

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 (SELECT * FROM order_items i,orders o

WHERE i.order_id = o.order id AND order_status IN (0,1));

D) 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));

Answer：AC

(解析：B 和 C 语法不对，可以实验，都会报错)

-----------------------------------------------

OCP解析公开课时间：【每周五晚8点】

OCP解析公开课地址：https://ke.qq.com/course/326223

OCP解析群资料分享：1015267481 验证：ocp

另外，除了OCP公开课，OCM题库直播也同步进行中，OCM最新题库大爆料-【每周四晚8点】，【微信群直播】，可以联系咨询老师进群参与