OCP 1Z0 051 66
来源:互联网 发布:matlab2016a mac 破解 编辑:程序博客网 时间:2024/04/29 13:51
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
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.
ORDER BY 后可以跟 列名、别名、表达式、列位置(数字)
SQL> SELECT prod_id 2 FROM sh.costs 3 WHERE unit_price >= unit_cost * 1.25 4 AND rownum <= 5 5 ORDER BY unit_cost * 0.25 DESC; PROD_ID---------- 17 14 14 14 145 rows selectedAnswer: A
0 0
- OCP 1Z0 051 66
- OCP 1Z0 051 1
- OCP 1Z0 052 66
- OCP 1Z0 053 66
- OCP 1Z0 051 2
- OCP 1Z0 051 3
- OCP 1Z0 051 4
- OCP 1Z0 051 5
- OCP 1Z0 051 6
- OCP 1Z0 051 7
- OCP 1Z0 051 8
- OCP 1Z0 051 9
- OCP 1Z0 051 10
- OCP 1Z0 051 11
- OCP 1Z0 051 12
- OCP 1Z0 051 13
- OCP 1Z0 051 14
- OCP 1Z0 051 15
- Qt 数据库操作
- Windows上python开发---5.异常处理
- 用两个栈实现队列
- Android组件- 广播的静态动态有序无序与优先级
- OGG-01031
- OCP 1Z0 051 66
- Rain24日广州开唱 将用更多中文与粉丝互动
- 数据科学之机器学习17:因子分析2
- burpsuit暴力破解的方法
- 《Cortex™-A系列编程者指南(V3.0)》第12章<异常处理>笔记
- OpenCv Hog+SVM bat批处理
- redis配置文件说明
- mysql 关于range 分区 的认识
- 黑马程序员学习笔记——CounDownLatch、Exchange