ocp 11g认证题库大全：1Z0-051-110题
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
精华阅读