CONSIDER THE FOLLOWING STATEMENT

5. Consider the following statement:

select last_name from employees join departmentson employees.department_id = departments.department_idwhere department_name='Executive';

and this statement:

select last_name from employees where department_id in(select department_id from departments where department_name='Executive');

What can be said about the two statements? (Choose two correct answers.)

A. The two statements should generate the same result.

B. The two statements could generate different results.

C. The first statement will always run successfully; the second statement will

fail if there are two departments with DEPARTMENT_NAME ‘Executive’.

D. Both statements will always run successfully, even if there are two

departments with DEPARTMENT_NAME ‘Executive’.