【OCP 12c】最新Oracle 1Z0-071考試題庫（16題）
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢2018年OCP 11g考試原題解析已經講解30多次課，500多道考試原題，最終達到98%以上的考題覆蓋度及95%以上的考試通過率。
2019年OCP 11g將升級到12c，OCP 12c考試解析免費公開課也已經開始了，歡迎大家收看!
OCP解析公開課時間：【每周五晚8點】
OCP解析公開課地址：http://ke.qq.com/course/326223
OCP解析群資料分享：1015267481 驗證：ocp
另外，除了OCP公開課，OCM題庫直播也同步進行中，OCM最新題庫大爆料-【每周四晚8點】，【微信群直播】，可以聯系咨詢老師進群參與
-------------------------------------------------------
16.choose two
View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables.
You have a requirement from the supplies department to give a list containing PRODUCT_ID, SUPPLIER_ID, and QUANTITY_ON_HAND for all the products where in QUANTITY_ON_HAND is less than five.
Which two SQL statements can accomplish the task? (Choose two.)
A) SELECT product_id, quantity_on_hand,supplier_id
FROM product_information
NATURAL JOIN inventories AND quantity_on_hand < 5;
B) SELECT i.product_id, i.quantity_on_hand,pi.supplier_id
FROM product_information pi JOIN inventories i
ON (pi.product_id=i.product_id) AND quantity_on_hand < 5;
C) SELECT i.product_id, i.quantity_on_hand,pi.supplier_id
FROM product_information pi JOIN inventories i
USING (product_id) AND quantity_on_hand < 5;
D) SELECT i.product_id, i.quantity_on_hand,pi.supplier_id
FROM product_information pi JOIN inventories i
ON (pi.product_id=i.product_id)
WHERE quantity_on_hand < 5;
Answer：BD
(解析：AC 語法不對，執行時顯示 ORA-00933: SQL 命令未正確結束
類似的語句：
1、
select d.deptno,d.dname,e.empno,e.ename,e.sal
from emp e join dept d
on (e.deptno=d.deptno)
where sal < 3000;)
2、
select d.deptno,d.dname,e.empno,e.ename,e.sal
from emp e join dept d
on (e.deptno=d.deptno) and sal < 3000;
