![](https://lstatic.shangxueba.com/sxbzda/h5/images/m_q_title.png)
The EMP table contains these columns:EMPLOYEE_ID NUMBER(4)EMPNAME VARCHAR2 (25)SALARY NUMB
The EMP table contains these columns:EMPLOYEE_ID NUMBER(4)EMPNAME VARCHAR2 (25)SALARY NUMBER(9,2)HIRE_DATE DATEYou query the database with this SQL statement:SELECT empname,hire_date HIREDATE, salaryFROM EMPORDER BY hire_date;How will the results be sorted?()
A.randomly
B.ascending by date
C.descending by date
D.ascending alphabetically
E.descending alphabetically
![](https://lstatic.shangxueba.com/sxbzda/h5/images/tips_org.png)