OCP CBT Question 529

Please solve the following question.

You need to display the `first_name`, `last_name`, and `department_name` for all employees. Which SQL statement achieves this?

EMPLOYEES and DEPARTMENTS Table Structures
DESCRIBE employees;
Name                           Null?    Type
------------------------------ -------- -------------
EMPLOYEE_ID                    NOT NULL NUMBER(6)
FIRST_NAME                              VARCHAR2(20)
LAST_NAME                      NOT NULL VARCHAR2(25)
DEPARTMENT_ID                           NUMBER(4)

DESCRIBE departments;
Name                           Null?    Type
------------------------------ -------- -------------
DEPARTMENT_ID                  NOT NULL NUMBER(4)
DEPARTMENT_NAME                NOT NULL VARCHAR2(30)
MANAGER_ID                              NUMBER(6)
LOCATION_ID                             NUMBER(4)

SELECT e.first_name, e.last_name, d.department_name FROM employees e, departments d WHERE e.department_id = d.department_id;

SELECT e.first_name, e.last_name, d.department_name FROM employees e JOIN departments d ON e.department_id = d.department_id;

SELECT e.first_name, e.last_name, d.department_name FROM employees e NATURAL JOIN departments d;

SELECT first_name, last_name, department_name FROM employees JOIN departments USING (department_id);