View the Exhibit and examine the data in the DEPARTMENTS tables.
Evaluate the following SQL statement:
SELECT department_id "DEPT_ID", department_name , ‘b’
FROM departments
WHERE department__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 of the above statement? (Choose two.)
A. ORDER BY 3;
B. ORDER BY’b’;
C. ORDER BY DEPT_ID;
D. ORDER BY DEPT NAME;
|
Download Printable PDF. VALID exam to help you PASS. |
 |