You need to list the employees in DEPARTMENT_ID 30 in a single row, ordered by
HIRE_DATE.
Examine the sample output:
Which query will provide the required output?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Explanation:
http://docs.oracle.com/cd/E11882_01/server.112/e10592/functions089.htm
Has anybody noticed that the employees are sorted in descending order?
But none of the answers is providing an option to sort them in desc order. Only in asc.
John, they are sorted by hire_date, not last_name.
Option B is correct