Which two ORDER BY clauses can be used to sort the output?

View the Exhibit and examine the structure in the DEPARTMENTS tables. (Choose two.)

Examine this SQL statement:
SELECT department_id "DEPT_ID", department_name, ‘b’ FROM departments WHERE departments_id=90
UNION
SELECT department_id, department_name DEPT_NAME, ‘a’ FROM departments
WHERE department_id=10
Which two ORDER BY clauses can be used to sort the output?
A. ORDER BY DEPT_NAME;
B. ORDER BY DEPT_ID;
C. ORDER BY ‘b’;
D. ORDER BY 3;

Download Printable PDF. VALID exam to help you PASS.