Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. For which situation would you use a nonequijoin query?

Question

Exhibit

Options

• ATo find the tax percentage for each of the employees.
• BTo list the name, job id, and manager name for all the employees.
• CTo find the name, salary, and department name of employees who are not working with Smith.
• DTo find the number of employees working for the Administrative department and earning less then 4000.
• ETo display name, salary, manager ID, and department name of all the employees, even if the employees

• A
  84% (37)
• B
  9% (4)
• C
  5% (2)
• D
  2% (1)

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. Incorrect Answers B: You will use equijoin query because EMPLOYEES and DEPARTMENTS tables will be joined with equality operator. C: It will be equijoin query because EMPLOYEES and DEPARTMENTS tables will be joined with equality operator. D: You will use equijoin query because EMPLOYEES and DEPARTMENTS tables will be joined with equality operator. E: It will be equijoin query because of equality operator in join condition of two tables.

No community discussion yet for this question.