大數據就業實戰培訓 Oracle就業實戰培訓
071考試題庫之前是比較穩定的，但隨著Oracle的調整，071考試不斷的增加新的考題，增加了考試的難度，所以我們專門收集整理了這些考試，并對這些考題進行解析，希望可以對考生有幫助。
每周五晚8點，我們有免費的OCP解析公開課，地址：https://ke.qq.com/course/326223 OCP題庫交流群：1015267481，驗證ocp
-------------------------------------------------------
071考試-第44題、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
