An application includes a form on the EMPLOYEES table. You must limit the P1_MANAGER page item so users can select a single employee name and ID from the corresponding manager ID in the same table. Which item type can be used to display P1_MANAGER?

The requirement is to allow a user to select a single manager from a list of employees. A Popup LOV (List of Values) is the ideal item type for this scenario. It presents a user-friendly interface that allows searching and filtering a potentially large list of employees. It can be configured to display the employee's name for selection while returning the corresponding unique ID to the P1MANAGER page item, which perfectly matches the requirement.

B. A Switch is a binary control used for on/off or true/false values and cannot be used to select a value from a list of employees.
C. A Checkbox is typically used for selecting one or more values from a small, predefined list and lacks the search functionality needed for a large dataset like employees.

1. Oracle APEX App Builder User's Guide, 23.2, "Managing Page Items," Section 2.4.2, "About Page Item Types." This section describes the various item types, highlighting that Popup LOV is designed for selecting a single value from a list.

2. Oracle APEX App Builder User's Guide, 23.2, "Managing Shared Components," Section 3.3, "Creating Lists of Values." This section details how LOVs are created and used with items like Popup LOV.