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