View the Exhibit and examine the data in the employees table:

You want to display all the employee names and their corresponding manager names. Evaluate the following query:

Which join option can be used in the blank in the above query to get the required output?

Question

View the Exhibit and examine the data in the employees table:

You want to display all the employee names and their corresponding manager names. Evaluate the following query:

Which join option can be used in the blank in the above query to get the required output?

Accepted Answer

C. LEFT OUTER JOIN

Answer

A. INNER JOIN

Answer

B. FULL OUTER JOIN

Answer

D. RIGHT OUTER JOIN

View the Exhibit and examine the data in the employees table: You want to display all the employee names and their corresponding manager names. Evaluate the following query: Which join option can be…