OCP CBT Question 655

Please solve the following question.

You need to retrieve the `first_name` and `last_name` of employees who were hired in the year 2005, sorted by their `last_name` in ascending order. Which query is correct?

sqlSELECT first_name, last_name, hire_date FROM employees;

EMPLOYEES Table Structure

Column Name	Data Type
HIRE_DATE	DATE

SELECT first_name, last_name FROM employees WHERE HIRE_DATE LIKE '%05' ORDER BY last_name ASC;

SELECT first_name, last_name FROM employees WHERE TO_CHAR(HIRE_DATE, 'YYYY') = '2005' ORDER BY last_name ASC;

SELECT first_name, last_name FROM employees WHERE HIRE_DATE BETWEEN '01-JAN-2005' AND '31-DEC-2005' ORDER BY last_name ASC;

SELECT first_name, last_name FROM employees WHERE HIRE_DATE BETWEEN TO_DATE('01-JAN-2005', 'DD-MON-YYYY') AND TO_DATE('31-DEC-2005', 'DD-MON-YYYY') ORDER BY last_name ASC;