【12c OCP】最新OCP 12c題庫考試原題（071-44題）
最新學訊：近期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點】，【微信群直播】，可以聯系咨詢老師進群參與
-------------------------------------------------------
44、(9-12)choose all that apply
View the Exhibit and examine the details of the ORDER_ITEMS table.
Evaluate the following SQL statements:
Statement 1:
SELECT MAX(unit_price*quantity) "Maximum Order"
FROM order_items;
Statement 2:
SELECT MAX(unit_price*quantity) "Maximum Order"
FROM order_items
GROUP BY order_id;
Which statements are true regarding the output of these SQL statements? (Choose all that apply.)
A) Both statements would ignore NULL values for the UNIT_PRICE and QUANTITY columns.
B) Statement 1 would return only one row of output.
C) Both the statements would give the same output.
D) Statement 2 would return multiple rows of output.
E) Statement 1 would not return any row because the GROUP BY clause is missing.
Anser：ABD
(解析：對于 null 值，Oracle 計算的時候結果為空，但是在求最大值的時候，會忽略)
SQL> select sal*comm from emp;
SAL*COMM
----------
480000
625000
1750000
…
SQL> select max(sal*comm) from emp;
MAX(SAL*COMM)
-------------
1750000
