Helping Hand Questions for 1z0-770

A list of values (LOV) is a definition that provides a set of display values and return values for a page item or a report column. A LOV can be created at the application level as a shared component or at the page level as a local component. There are three types of LOVs that you can create on a page:

• Static LOV: A static LOV is based on a fixed list of display values and return values that you specify when you create the LOV. A static LOV does not change unless you edit it manually.
• Cascading LOV: A cascading LOV is based on another parent LOV that determines the values of the child LOV. A cascading LOV changes dynamically depending on the selection made in the parent LOV.
• Dynamic LOV: A dynamic LOV is based on a SQL query that returns display values and return values from the database. A dynamic LOV changes dynamically depending on the data in the database.

The Access Control feature pages are a set of pages that allow developers to implement role-based access control for an application. The Access Control feature pages consist of four pages: Administration, Users, Roles, and Role Assignments. The Administration page allows administrators to perform various tasks related to managing users and roles, such as:

• Add Users: Administrators can add new users to the application by entering their username, email address, password, status, etc.
• Assign roles to users: Administrators can assign one or more roles to users by selecting them from a list of available roles.
• Edit Users: Administrators can edit user details such as username, email address, password, status, etc.
• Delete Users: Administrators can delete users from the application by selecting them from a list of existing users.
• Lock/Unlock Users: Administrators can lock or unlock users by changing their status from active to locked or vice versa. You cannot create authorization schemes or create new application roles using the Administration page. You can create authorization schemes by using Shared Components > Security > Authorization Schemes. You can create new application roles by using Shared Components > Security > Access Control > Roles. Verified References: [Using Access Control - Oracle Help Center], [Creating an Administration Page - Oracle Help Center]

Dynamic actions are a declarative way to define client-side behavior without writing JavaScript code. You can create dynamic actions on an item, button, or region of a page by specifying the event, condition, affected elements, action, and other properties. Some of the statements that are true about creating and using dynamic actions are:

• You can execute JavaScript code by creating a dynamic action. One of the supported action types is Execute JavaScript Code, which allows you to enter custom JavaScript code to run when the dynamic action fires.
• If a client-side condition is defined, the true action will fire when the condition is met, and the false action will fire when it is not. You can define a client-side condition for a dynamic action to control when it should fire based on an expression or value. You can also define different actions for the true and false branches of the condition. You can add additional true actions to a dynamic action by clicking the Add True Action button in the Property Editor. If no client-side condition is defined, true actions will fire when the event occurs. Verified References: [Oracle Application Express 18: Creating Dynamic Actions], [Dynamic Action Enhancements in APEX 21.1 - Oracle Blogs]

A Faceted Search and a Smart Filter are two types of pages that behave similarly in functionality. They both allow users to filter data based on multiple criteria and see the results in real time. They differ in the following aspects:

• A Faceted Search uses facets to filter data. A facet is a set of filters based on a column or expression. A facet can be displayed as a list, a range slider, a star rating, or a chart.
• A Smart Filter uses conditions to filter data. A condition is a logical expression that evaluates to true or false. A condition can be based on a column, an item, or a function.

The other options are incorrect because:

• A Map is a type of region that displays spatial data on an interactive map. It allows users to zoom, pan, and select features on the map.
• A Cards is a type of region that displays data in a grid of cards. Each card represents one row of data and can contain text, images, icons, or buttons.

Verified References: [About Faceted Search] [About Smart Filter] [About Maps] [About Cards]