Newly Released Oracle 1z0-770 Exam PDF

Faceted Search is a feature that allows end users to filter data by applying one or more facets. A facet is a set of filters based on a column or expression. Faceted Search supports the ability to filter columns storing multiple values as one string, such as comma-separated values or JSON arrays, by using the Split Values attribute. Facets map to specific database columns or expressions that are defined in the Data Source attribute of the faceted search region. The other statements are false because Faceted Search supports displaying multiple charts in the same region by using the Chart View attribute, and a facet’s chart can be seen either in a nonmodal dialog or inline by using the Chart Display Mode attribute. Verified References: [Creating Faceted Search Pages - Oracle Help Center], [Facet Attributes - Oracle APEX]

In a faceted search page, facets can be displayed as different UI types depending on the data type and cardinality of the facet column or expression. The facet item types are the UI components that are used to render the facets in the faceted search region. The supported facet item types are Range, Checkbox Group, Radio Group, List, Star Rating, and Switch. Date Picker and Popup LOV are not valid facet item types. Verified References: [Faceted Search Attributes - Oracle Help Center], [Facet Item Types - Oracle APEX]

A calendar is a type of component that enables users to view and manage data based on dates. A calendar can display data in different views, such as monthly, weekly, daily, or list. Users can also interact with the calendar by creating, editing, or deleting events, or by using drag and drop functionality. Three of the features of a calendar in Oracle APEX are:

• Next - Navigates to the next month. This feature allows users to move forward in time and see the events for the following month.
• Previous - Navigates to the previous month. This feature allows users to move backward in time and see the events for the previous month.
• Month, Week, Day - Displays a monthly, weekly and daily view. These features allow users to switch between different views of the calendar and see the events for a specific month, week, or day.

To extend the functionality of the form as required, you need to create a dynamic action on P2_JOB that shows or hides P2_HIREDATE and P2_COMM based on its value. The steps are as follows:

• Create a dynamic action on P2_JOB by right-clicking it in Page Designer and selecting Create Dynamic Action.
• Set Name to Show/Hide Hire Date and Commission.
• Set Event to Change.
• Set Selection Type to Item(s).
• Set Item(s) to P2_JOB.
• Set Condition Type to Equal To.
• Set Value to SALESMAN.
• Add two true actions by clicking the Add True Action button twice.
• For the first true action, set Action to Show.
• Set Affected Elements > Selection Type to Item(s).
• Set Affected Elements > Item(s) to P2_HIREDATE,P2_COMM.
• For the second true action, set Action to Show.
• Set Fire On Initialization to Yes.
• Set Affected Elements > Selection Type to jQuery Selector.
• Set Affected Elements > jQuery Selector to label[for=“P2_HIREDATE”],label[for=“P2_COMM”].
• Add two false actions by clicking the Add False Action button twice.
• For the first false action, set Action to Hide.
• Set Affected Elements > Selection Type to Item(s).
• Set Affected Elements > Item(s) to P2_HIREDATE,P2_COMM.
• For the second false action, set Action to Hide.
• Set Fire On Initialization to Yes.
• Set Affected Elements > Selection Type to jQuery Selector.
• Set Affected Elements > jQuery Selector to label[for=“P2_HIREDATE”],label[for=“P2_COMM”].

This dynamic action will show or hide both the page items and their labels depending on whether P2_JOB is equal to SALESMAN or not. Verified References: [Creating a Dynamic Action in Oracle Apex - OrclQA.Com], [Managing Dynamic Actions - Oracle Help Center]