Which statement is true about Unified Task List in the Approvals component?
Correct Answer: A
Explanation The Approvals component in Oracle APEX is a feature that allows developers to create approval workflows for business processes that require human intervention or decision making. The Approvals component consists of three main elements: Tasks, Task List Page, and Task Details Page. The Unified Task List is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox for end users. The Unified Task List displays all tasks assigned to or created by an end user along with their status, priority, due date, etc. End users can filter, sort, search, view details, and perform actions on tasks from this page. Verified References: [Using Approvals - Oracle Help Center], [Creating a Unified Task List Page - Oracle Help Center]
Question 17
What are the three types of List of Values(LOV) you can create on a page?
Correct Answer: A,B,C
Explanation 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.
Question 18
Which statement is true about using the App Gallery?
Correct Answer: B
Explanation Custom Apps are specific to your workspace and are only available if your instance administrator has enabled them. You can install Sample Apps and Starter Apps directly from the Gallery or download them from GitHub. Sample Apps and Starter Apps are available with every Oracle APEX workspace. References: Using the App Gallery and Configuring the Application Gallery
Question 19
You must create a single master detail page where users can select a row in the master grid to update the detail grids. Users must also interact with the master or the detail without leaving the page. Which type of master detail implementation should you use?
Correct Answer: C
Explanation A stacked master detail is a type of master detail implementation that features two editable interactive grids based on two related tables or views. Users can select a row in the master grid to update the detail grid. Users can also interact with the master or the detail without leaving the page. A stacked master detail is suitable for scenarios where you want to display and edit data from a one-to-many relationship in a single page. You can create a stacked master detail using either the Create Application Wizard or the Create Page Wizard. Verified References: [Managing Master Detail Forms - Oracle Help Center], [Creating a Single Page Master Detail Using the Create Application Wizard - Oracle Help Center]
Question 20
Choose from the below options the actions that can be performed when a button is clicked.
Correct Answer: B
Explanation A button is a component that performs an action when clicked by the user. A button can have different types, styles, icons, and labels. A button can also have different behaviors, such as submitting the page, redirecting to another page or URL, or doing nothing. A button can perform any of the following actions when clicked: Redirect to a page in the same application: This action redirects the user to another page within the same APEX application. You can specify the target page number and optionally set some attributes, such as clear cache, request, and item values. Redirect to a page in a different application: This action redirects the user to another page in a different APEX application. You can specify the target application ID and page number and optionally set some attributes, such as clear cache, request, and item values. Redirect to a URL: This action redirects the user to a custom URL that you specify. You can use any valid URL format, such as http://, https://, mailto:, or javascript:. Submit Page: This action submits the current page to the server and performs any validations, computations, processes, or branches that are defined for the page. You can also specify a request value for the button that can be used to conditionally execute some components. Defined by Dynamic Action: This action does not submit the page or redirect to another page. Instead, the button's behavior is defined by a dynamic action thatis associated with the button. A dynamic action is a declarative way of defining client-side behavior based on user actions or events.
