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.)

Question

Accepted Answer

A. ORDERBY 3; C. ORDER BY DEPT_ID;

Answer

B. ORDER BY 'b';

Answer

D. ORDER BY DEPT NAME;

1Z0-047 Question #210: Real Exam Question with Answer & Explanation

Question

Exhibit

Options

Community Discussion