Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables.
For which situation would you use a nonequijoin query?
A.
to list the name, job_id, and manager name for all the employees
B.
to find the name, salary, and the department name of employees who are not working with
Smith
C.
to display name, salary, manager ID, and department name of all the employees, even if the
employees do not have a department ID assigned
D.
to find the number of employees working for the Administrative department and earning less
than 4000
E.
to find the tax percentage for each of the employees
Explanation:
You will use a nonequijoin query to find the tax percentage for each of the employees because
you will check range of salaries without usage of equality operations in a comparison joining data
from two tables.