当前位置：优技教育 >> ocp考试 >

ocp 11g认证题库大全：1Z0-051-110题

来源：优技教育更新时间：2016/8/5 14:41:39 阅读次数：872

ocp 11g认证题库大全：1Z0-051-110题，完整题库请点击这里联系老师咨询了解

110. View the Exhibit and examine the structure of the CUSTOMERS table.

Using the CUSTOMERS table, you need to generate a report that shows the average credit limit for

customers in WASHINGTON and NEW YORK.

Which SQL statement would produce the required result?

A. SELECT cust_city, AVG(cust_credit_limit)

FROM customers

WHERE cust_city IN ('WASHINGTON','NEW YORK')

GROUP BY cust_credit_limit, cust_city;

B. SELECT cust_city, AVG(cust_credit_limit)

FROM customers

WHERE cust_city IN ('WASHINGTON','NEW YORK')

GROUP BY cust_city,cust_credit_limit;

C. SELECT cust_city, AVG(cust_credit_limit)

FROM customers

WHERE cust_city IN ('WASHINGTON','NEW YORK')

GROUP BY cust_city; 按照城市来取平均值

D. SELECT cust_city, AVG(NVL(cust_credit_limit,0))

FROM customers

WHERE cust_city IN ('WASHINGTON','NEW YORK');

Answer: C

试题解析：

A答案：此处是按照cust_credit_limit, cust_city;这两个一起分组的。

B答案，与A答案一样，按照cust_credit_limit, cust_city;这两个一起分组的。

C答案，按照cust_city来分组，与题意复合

D答案：缺少group by

ORACLE授权认证机构CUUG: CUUG与ORACLE合作15年，是ORACLE金牌合作伙伴，连续多年处于行业领先；; CUUG与工信部人才交流中心合作，是工信人才指定的PostgreSQL数据库培训合作伙伴；; CUUG与阿里云、腾讯云、人大金仓、奥星贝斯等众多数据库厂商合作，开设数据库认证与培训课程；; CUUG与企业合作提供人才输送、定制化培训、技术支持服务；

北京优技教育科技有限公司

联系电话：010-59426307

课程咨询：010-59426319

联系地址：海淀区紫竹院路88号

Oracle认证 OCP认证 OCM认证