2018年OCP 11g考試原題解析已經(jīng)講解30多次課，500多道考試原題，最終達到98%以上的考題覆蓋度及95%以上的考試通過率。

2019年OCP 11g將升級到12c，OCP 12c考試解析免費公開課也已經(jīng)開始了，歡迎大家收看!

OCP解析公開課時間：【每周五晚8點】

OCP解析公開課地址：http://ke.qq.com/course/326223

OCP解析群資料分享：1015267481 驗證：ocp

另外，除了OCP公開課，OCM題庫直播也同步進行中，OCM最新題庫大爆料-【每周四晚8點】，【微信群直播】，可以聯(lián)系咨詢老師進群參與

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

89、Which three statements are true regarding group functions? (Choose three.)

A. They can be used on columns or expressions.

B. They can be passed as an argument to another group function.

C. They can be used only with a SQL statement that has the GROUP BYclause.

D. They can be used on only one column in the SELECT clause of a SQL statement.

E. They can be used along with the single-row function in the SELECTclause of a SQL statement.

Correct Answer: ABE

Section: (none)

Explanation(函數(shù)可以用在表達式中，比如 avg(sal+100);函數(shù)可以嵌套;也可以跟單行函數(shù)

一起使用：

select substr(d.dname,1,3),avg(e.sal)

from dept d,emp e

group by d.dname;