New Year Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: simple70

Oracle Database Administration I 1z0-082 Question # 27 Topic 3 Discussion

Oracle Database Administration I 1z0-082 Question # 27 Topic 3 Discussion

1z0-082 Exam Topic 3 Question 27 Discussion:
Question #: 27
Topic #: 3

Examine this SQL statement:

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, any one of which can complete the query successfully. (Choose three.)


A.

ORDER BY “Last Name”


B.

ORDER BY 2, 1


C.

ORDER BY 2, cust_id


D.

ORDER BY CUST_NO


E.

ORDER BY “CUST_NO”


Get Premium 1z0-082 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.