OCP CBT Question 654

Please solve the following question.

You want to retrieve the `employee_id`, `first_name`, and `salary` for the 5 highest-paid employees. Which of the following queries correctly achieves this, assuming Oracle Database 12c or later?

sqlSELECT employee_id, first_name, salaryFROM employeesORDER BY salary DESC;

EMPLOYEES Table Sample Data

EMPLOYEE_ID	FIRST_NAME	SALARY
100	Steven	24000
101	Neena	17000
102	Lex	17000
103	Alexander	9000
104	Bruce	6000
105	David	4800

SELECT employee_id, first_name, salary FROM employees WHERE ROWNUM <= 5 ORDER BY salary DESC;

SELECT employee_id, first_name, salary FROM employees ORDER BY salary DESC FETCH FIRST 5 ROWS ONLY;

SELECT employee_id, first_name, salary FROM employees OFFSET 0 ROWS FETCH FIRST 5 ROWS ONLY;

SELECT employee_id, first_name, salary FROM employees ORDER BY salary DESC LIMIT 5;