Oracle
1Z0-061 · Question #179
1Z0-061 Question #179: Real Exam Question with Answer & Explanation
The correct answer is B. SELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY. See the full explanation below for the reasoning.
Question
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?
Exhibit
Options
- ASELECT cust_city, cust_income_level, MAX(cust_credit_limit ) FROM customers GROUP BY
- BSELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY
- CSELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY
- DSELECT cust_city, cust_income_level, MAX(cust_credit_limit) FROM customers GROUP BY
Community Discussion
No community discussion yet for this question.