Sam Created a Self Join Between Two Copies of the Employees

question 39

Multiple Choice

Sam created a self join between two copies of the Employees table and then renamed one copy Managers.When he adds the LastName field from the Managers table and the LastName field from the Employees table to the query grid, which of the following statements describes the results?

• A) The datasheet lists employees with no managers.
• B) The datasheet lists managers with no employees.
• C) Employee last names are repeated many times because many employees report to the same managers.
• D) Manager last names are repeated many times because many employees report to the same managers.

---

Definitions:

Data Type

A classification identifying one of various types of data, such as integer, floating-point, Boolean, or string, which determines the operations that can be performed on the data.

Edit Record Symbol

An icon or indication used to signify that data or records can be modified or updated.

Table Record

An individual entry in a table database, consisting of fields that contain one piece of data or attribute each.

SHIFT+TAB

A keyboard shortcut typically used to navigate back through fields, menu items, or UI elements in a reverse order.