OCP CBT Question 497

Please solve the following question.

Examine the following SQL statement and the `EMPLOYEES` table structure:

EMPLOYEES Table Structure`sqlDESC EMPLOYEES;Name Null? Type----------------- -------- -------------EMPLOYEE_ID NOT NULL NUMBER(6)FIRST_NAME VARCHAR2(20)LAST_NAME NOT NULL VARCHAR2(25)EMAIL NOT NULL VARCHAR2(25)PHONE_NUMBER VARCHAR2(20)HIRE_DATE NOT NULL DATEJOB_ID NOT NULL VARCHAR2(10)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(2,2)MANAGER_ID NUMBER(6)DEPARTMENT_ID NUMBER(4)`Which SQL statement will correctly display the employee's `HIRE_DATE` in the format 'DD-MON-YY'?

SELECT TO_CHAR(HIRE_DATE, 'DD-MON-YY') FROM EMPLOYEES;

SELECT HIRE_DATE FROM EMPLOYEES WHERE HIRE_DATE = '15-JAN-05';

SELECT TO_DATE(HIRE_DATE, 'DD-MON-YY') FROM EMPLOYEES;

SELECT CONVERT(HIRE_DATE, 'DD-MON-YY') FROM EMPLOYEES;