Oracle Database SQL 12c 1z0-071 Exam Practice Test 2

Question : 31 of 50

Marks: +1, -0

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?

ORDER BY DEPT_NAME;
ORDER BY DEPT_ID;
ORDER BY 'b';
ORDER BY 3;

Validate

Go to Question:

Prev Question

Next Question