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

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

Accepted Answer

A. ORDER BY 3; C. ORDER BYDEPT_ID;

Answer

B. ORDER BY'b';

Answer

D. ORDER BY DEPTNAME;

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…

Question

Exhibit

Options

How the community answered

Community Discussion