A Page Computation can be created from which two of the following tabs?
Correct Answer: A,B
Explanation A Page Computation can be created from two tabs in Page Designer: Rendering Tree and Processing. In the Rendering Tree tab, you can create a Pre-Rendering Computation or a Post-Rendering Computation by right-clicking on these nodes under your page node. In the Processing tab, you can create an After Submit Computation by right-clicking on this node under your page node. Dynamic Actions and Shared Components are not tabs in Page Designer, but sections in Application Builder where you can create other types of components for your application
Question 12
Let's say that there are two select lists on a page. Making a selection in the DEPARTMENT select list, determines which individuals display in the Employees select list. This type of LOV is called:
Correct Answer: B
Explanation A cascading LOV is a type of list of values (LOV) that depends on another parent LOV to determine its values. For example, if there are two select lists on a page, one for DEPARTMENT and one for EMPLOYEES, you can create a cascading LOV for EMPLOYEES that only shows the employees who belong to the selected department in the DEPARTMENT select list. To create a cascading LOV, you need to specify the parent item name and use bind variables in the SQL query for the child item.
Question 13
Developers can use Template Options in which of the following ways?
Correct Answer: A
Explanation Template options provide developers with a declarative approach to applying different styles to components on an Oracle APEX page. Developers can use template options to declaratively apply CSS modifiers to the templates they have chosen for pages, regions, reports, lists, breadcrumbs, items and buttons. Developers can use template options in all of the following ways: Applying different colors or accents. Developers can use template options to change the color scheme or accent color of components, such as buttons, lists, or regions. Rendering buttons in different styles, with and without icons. Developers can use template options to change the shape, size, style, and icon of buttons on a page. Applying different spacing and padding. Developers can use template options to adjust the spacing and padding of components, such as regions, items, or reports. Displaying form fields with different alignments. Developers can use template options to change the alignment of form fields and labels, such as left-aligned, right-aligned, or top-aligned.
Question 14
Which two statements are true about creating and customizing Smart Filters pages?
Correct Answer: A,C
Explanation Smart Filters is a component that allows end users to filter data by typing keywords in a single search field. Some of the statements that are true about creating and customizing Smart Filters pages are: If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache. You can also manually add or remove filters as needed. The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types. For other filter types, such as Input or Range, the count is not displayed. The search results report cannot be displayed as an interactive report or an interactive grid. The supported report types are Classic Report, Cards, Map, or Calendar. Verified References: [Managing Smart Filters - Oracle Help Center], [Creating Smart Filters Using the Create Page Wizard - Oracle Help Center]
Question 15
Which three of the following are use cases of Automations?
Correct Answer: B,C,D
Explanation Automations are a sequential set of PL/SQL actions that are triggered by query results. They are used to monitor data and then perform the appropriate action2. Some use cases of automations are: Monitoring log tables and raising an alert when there is an issue. For example, an automation can query a log table for any errors and send an email notification to the administrator if any errors are found2. Approving specific requests. For example, an automation can query a table for any pending requests and approve them automatically based on some criteria2. Sending email alerts at a particular time of the week. For example, an automation can query a table for any overdue tasks and send a reminder email to the assignees every Monday2. Deleting a database record based on an end user's request is not a use case of automations, as it does not involve querying data and triggering actions based on the query results. This can be achieved by using a PL/SQL process or a dynamic action on the page where the user requests the deletion34.
