70-433 · Question #78
You have a table named Employee. You document your company's organizational hierarchy by inserting the EmployeeID of each employee's manager in the ReportsTo column. You need to write a recursive…
The correct answer is B. SELECT EmployeeID. See the full explanation below for the reasoning.
Question
You have a table named Employee. You document your company's organizational hierarchy by inserting the EmployeeID of each employee's manager in the ReportsTo column. You need to write a recursive query that produces a list of employees and their manager. The query must also include the employee's level in the hierarchy. You write the following code segment. (Line numbers are included for reference only.) 01 WITH EmployeeList (EmployeeID, FullName, ManagerName, Level) 02 AS ( 03 ......... 04 ) 05 SELECT EmployeeID, FullName, ManagerName, Level 06 FROM EmployeeList; Which code segment should you insert at line 3?
Options
- ASELECT EmployeeID,
- BSELECT EmployeeID,
- CSELECT EmployeeID,
- DSELECT EmployeeID,
How the community answered
(21 responses)- A5% (1)
- B76% (16)
- C5% (1)
- D14% (3)
Community Discussion
No community discussion yet for this question.