大数据就业实战培训 Oracle就业实战培训
071考试题库之前是比较稳定的，但随着Oracle的调整，071考试不断的增加新的考题，增加了考试的难度，所以我们专门收集整理了这些考试，并对这些考题进行解析，希望可以对考生有帮助。
每周五晚8点，我们有免费的OCP解析公开课，地址：https://ke.qq.com/course/326223 OCP题库交流群：1015267481，验证ocp
-------------------------------------------------------
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 语法不对，可以实验，都会报错)
