OCP 11g认证题库详解:1Z0-051-066题
最新学讯:近期OCP认证正在报名中,因考试人员较多请尽快报名获取最近考试时间,报名费用请联系在线老师,甲骨文官方认证,报名从速!
我要咨询OCP 11g认证题库详解:1Z0-051-066题,完整题库请点击这里联系老师咨询了解
66. View the Exhibit and examine the data in the COSTS table.
You need to generate a report that displays the IDs of all products in the COSTS table whose unit price is
at least 25% more than the unit cost. The details should be displayed in the descending order of 25% of
the unit cost.
You issue the following query:
SQL>SELECT prod_id
FROM costs
WHERE unit_price >= unit_cost * 1.25
ORDER BY unit_cost * 0.25 DESC;
Which statement is true regarding the above query?
A. It executes and produces the required result.
B. It produces an error because an expression cannot be used in the ORDER BY clause.
C. It produces an error because the DESC option cannot be used with an expression in the ORDER BY
clause.
D. It produces an error because the expression in the ORDER BY clause should also be specified in the
SELECT clause.
Answer: A
试题解析:
Order by可以只用表达式来排序
order by 可以表达式sal*10
可以列别名 sal10
可以双引号 "sal10"