Exit 1Z0-061 Oracle Database 12c: SQL Fundamentals
Question 4 of 5
0% complete
Q4 Multiple choice

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;

Which ORDER BY clause are valid for the above query? (Choose all that apply.)

Select all that apply.

  • A

    ORDER BY 2, 1

  • B

    ORDER BY CUST_NO

  • C

    ORDER BY 2, cust_id

  • D

    ORDER BY "CUST_NO"

  • E

    ORDER BY "Last Name"

Previous Next