OCP认证051考试题库：11g-v9.02-第145题
最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！
我要咨询OCP认证051考试题库：11g-v9.02-第145题，完整题库请点击这里联系老师咨询了解
145. View the Exhibit and examine the structure of the CUSTOMERS table.
You issue the following SQL statement on the CUSTOMERS table to display the customers who are in the
same country as customers with the last name 'KING' and whose credit limit is less than the maximum 小于最大值
credit limit in countries that have customers with the last name 'KING':
SQL> SELECT cust_id,cust_last_name
FROM customers
WHERE country_id IN(SELECT country_id
FROM customers
WHERE cust_last_name ='King')
AND cust_credit_limit < (SELECT MAX(cust_credit_limit)
FROM customers
WHERE country_id IN(SELECT country_id
FROM customers
WHERE cust_last_name='King'));
Which statement is true regarding the outcome of the above query?
A. It executes and shows the required result.
B. It produces an error and the < operator should be replaced by < ALL to get the required output.
C. It produces an error and the < operator should be replaced by < ANY to get the required output.
D. It produces an error and the IN operator should be replaced by = in the WHERE clause of the main
query to get the required output.
Answer: A
试题解析：
1、首先找出the last name 'KING'所在countries
2、再找出KING所在城市的最大的cust_credit_limit
3、再找出和KING所在一样城市的客户的id和姓名，他们的cust_credit_limit要小于KING所在城市的最大的cust_credit_limit的其余的值。
值太多，去前5个。按题意，选A。
