nerdexam
Microsoft

70-433 · Question #127

You have a table named Employees. You want to identify the supervisor to which each employee reports. You write the following query. SELECT e.EmloyeeName AS [EmployeeName], s.EmployeeName AS…

The correct answer is A. LEFT JOIN Employees s. See the full explanation below for the reasoning.

Question

You have a table named Employees. You want to identify the supervisor to which each employee reports. You write the following query. SELECT e.EmloyeeName AS [EmployeeName], s.EmployeeName AS [SuperVisorName] FROM Employees e You need to ensure that the query returns a list of all employees and their respective supervisor. Which join clause should you use to complete the query?

Options

  • ALEFT JOIN Employees s
  • BRIGHT JOIN Employees s
  • CINNER JOIN Employees s
  • DLEFT JOIN Employees s

How the community answered

(15 responses)
  • A
    80% (12)
  • B
    13% (2)
  • C
    7% (1)

Community Discussion

No community discussion yet for this question.

Full 70-433 Practice