OCP 11g考试题库详解：1Z0-051-107题

OCP 11g考试题库详解：1Z0-051-107题，完整题库请点击这里联系老师咨询了解

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类型求平均数

B,MAX,MIN可以对数值和date求最大值和最小值

C,组合函数，需要分组，错误

D,AVG对数值求平均数，正确。