The statement :

Select EmpName, DateOfLeaving from Employees order by DateOfLeaving desc, EmpName asc

will not return the date in ascending order as shown by the result set in the question!!

So there is only one correct answer to this question.