ocp 11g考試題庫詳解：1Z0-051-107題，完整題庫請點擊這里聯(lián)系老師咨詢了解

107. View the Exhibit and examine the structure and data in the INVOICE table.

Which two SQL statements would execute successfully? (Choose two.)

A. SELECT AVG(inv_date ) 類型不一致，不能對date求平均值

FROM invoice;

B. SELECT MAX(inv_date),MIN(cust_id)

FROM invoice;

C. SELECT MAX(AVG(SYSDATE - inv_date)) 缺少group by

FROM invoice;

D. SELECT AVG( inv_date - SYSDATE), AVG(inv_amt)

FROM invoice;

Answer: BD

試題解析：

A，不能對date類型求平均數(shù)

B,MAX,MIN可以對數(shù)值和date求最大值和最小值

C,組合函數(shù)，需要分組，錯誤

D,AVG對數(shù)值求平均數(shù)，正確。