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对数值求平均数，正确。
精华阅读