ocp 19c考題，科目082考試題(27) - order by clause

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