OCP CBT Question 504

Please solve the following question.

Examine the SQL statement to determine the employee's `JOB_GRADE` based on their `SALARY`:

EMPLOYEES Table Structure`sqlDESC EMPLOYEES;Name Null? Type----------------- -------- -------------EMPLOYEE_ID NOT NULL NUMBER(6)SALARY NUMBER(8,2)...`Desired Logic: - If salary is less than 5000, JOB_GRADE is 'A' - If salary is between 5000 and 10000, JOB_GRADE is 'B' - If salary is greater than 10000, JOB_GRADE is 'C'

sqlSELECT employee_id, salary, DECODE(TRUE, salary < 5000, 'A', salary BETWEEN 5000 AND 10000, 'B', 'C') AS job_grade FROM employees;

sqlSELECT employee_id, salary, DECODE(SIGN(salary - 5000), -1, 'A', DECODE(SIGN(salary - 10000), -1, 'B', 0, 'B', 'C')) AS job_grade FROM employees;

sqlSELECT employee_id, salary, DECODE(salary, < 5000, 'A', >= 5000 AND <= 10000, 'B', 'C') AS job_grade FROM employees;

sqlSELECT employee_id, salary, DECODE(salary < 5000, 'A', salary >= 5000 AND salary <= 10000, 'B', 'C') AS job_grade FROM employees;