Oracle OCP 19c 认证1Z0-082考试题库(第27题)-CUUG内部学员版082题库解析
27、Evaluate the following SQL statement:
SQL> select cust_id, cust_last_name "Last name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30
Identify three ORDER BY clauses either one of which can complete the query.
A. ORDER BY "Last name"
B. ORDER BY 2, cust_id
C. ORDER BY CUST_NO
D. ORDER BY 2, 1
E. ORDER BY "CUST_NO"
source : cuug
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/70010796/viewspace-2856742/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- 从小白到专家 PG技术大讲堂 - Part 2：PG源代码安装
- 从小白到专家 PG 技术大讲堂 - Part 1：PG 简介
- ocp 19c考题，科目082考试题(34)
- ocp 19c考题，科目082考试题(33)
- ocp 19c考题，科目082考试题(32) -
- ocp 19c考题，科目082考试题(31) - resource_limit
- ocp 19c考题，科目082考试题(30) - default profile
- ocp 19c考题，科目082考试题(29) - about profiles
- ocp 19c考题，科目082考试题(28) - oracle profiles
- ocp 19c考题，科目082考试题(26) - order by clause
