ocp认证051考试题库：11g-v9.02-第142题
最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！
我要咨询ocp认证051考试题库：11g-v9.02-第142题，完整题库请点击这里联系老师咨询了解
142. View the Exhibit and examine the structure of the PRODUCTS table.
Evaluate the following query:
SQL> SELECT prod_name
FROM products
WHERE prod_id IN (SELECT prod_id FROM products
WHERE prod_list_price =
(SELECT MAX(prod_list_price)FROM products
WHERE prod_list_price <
(SELECT MAX(prod_list_price)FROM products)));
What would be the outcome of executing the above SQL statement?
A. It produces an error.
B. It shows the names of all products in the table.
C. It shows the names of products whose list price is the second highest in the table.
D. It shows the names of all products whose list price is less than the maximum list price.
Answer: C
试题解析：
1、首先来运行一下上面的sql语句，是可以出结果的。
2、拆分上面sql语句，首先运行子句查询出价格最高的产品的价格
3、低于价格最高的，即价格次高的产品。按题意，故选C.
