CONSIDER THIS STATEMENT, WHICH IS INTENDED TO PROMPT FOR AN EMPLOY...

10. Consider this statement, which is intended to prompt for an employee’s name

and then find all employees who have the same job as the first employee:

select last_name,employee_id from employees where job_id =(select job_id from employees where last_name = '&Name');

What would happen if a value were given for &Name that did not match with

any row in EMPLOYEES? (Choose the best answer.)

A. The statement would fail with an error.

B. The statement would return every row in the table.

C. The statement would return no rows.

D. The statement would return all rows where JOB_ID is NULL.