ocp 11g考試題庫詳解：1Z0-051-111題
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢ocp 11g考試題庫詳解：1Z0-051-111題，完整題庫請點擊這里聯系老師咨詢了解
111. View the Exhibit and examine the structure of the CUSTOMERS table.
Which statement would display the highest credit limit available in each income level in each city in the
CUSTOMERS table?
A. SELECT cust_city, cust_income_level, MAX(cust_credit_limit )
FROM customers
GROUP BY cust_city, cust_income_level, cust_credit_limit;
B. SELECT cust_city, cust_income_level, MAX(cust_credit_limit)
FROM customers
GROUP BY cust_city, cust_income_level; 分組先按照city再按照income level
C. SELECT cust_city, cust_income_level, MAX(cust_credit_limit)
FROM customers
GROUP BY cust_credit_limit, cust_income_level, cust_city ; 順序錯了
D. SELECT cust_city, cust_income_level, MAX(cust_credit_limit)
FROM customers
GROUP BY cust_city, cust_income_level, MAX(cust_credit_limit);
Answer: B
試題解析：
按照題意，先按照每個城市后按照每個城市中的收入水平來分組查看最高的credit limit
故在group by時應為 group by cust_city, cust_income_level;
A答案，沒有涉及到cust_credit_limit的分組。
B答案與題意相符，正確，數據太多，取前5行。
C答案，沒有涉及cust_credit_limit分組，且cust_income_level, cust_city 順序錯了，應為group by cust_city, cust_income_level;
D答案，語法錯誤
