Which statement is true about the Approvals component?
Correct Answer: C
Explanation The Approvals Component is a feature in Oracle APEX that enables you to create and manage tasks for user approval. The Approvals Component deals with all aspects of human approval in Oracle APEX, allowing you to put approval functionality into your applications. The Approvals Component creates one or more tasks for items that require approval based on a pre-configured template, known as the Task Definition. The Task Definition specifies the data source, display attributes, potential owners, business administrators, and available actions for the tasks. You can set up task approvers and administrators at design time or determine them dynamically at runtime based on data related to the task. For example, you can use a SQL query or a PL/SQL function to return the list of potential owners or business administrators for each task based on some criteria, such as department, role, or location.
Question 22
Which two are valid evaluation points for Authorization Schemes?
Correct Answer: A,C
Explanation An authorization scheme is a rule that determines if a user is authorized to access a specific component or feature of an application, such as a page, region, button, item, etc. An authorization scheme can be evaluated at different points in time depending on its evaluation point attribute. The valid evaluation points for authorization schemes are: Never: The authorization scheme is never evaluated and always returns false. Once per session: The authorization scheme is evaluated only once per user session and caches the result for subsequent requests. Once per page view: The authorization scheme is evaluated once per page view and caches the result for subsequent requests within the same page view. On each new page view or partial page refresh: The authorization scheme is evaluated on each new page view or partial page refresh (for example, when using dynamic actions) and caches the result until the next page view or partial page refresh. On each request (not cached): The authorization scheme is evaluated on each request and does not cache the result. Once per user and Once per page load are not valid evaluation points for authorization schemes. Verified References: [Creating Authorization Schemes - Oracle Help Center], [Authorization Scheme Attributes - Oracle Help Center]
Question 23
To highlight certain rows in the interactive report based on a condition, you must:
Correct Answer: D
Explanation To highlight certain rows in the interactive report based on a condition, you must choose a condition in Format > Highlight. This option allows you to apply a conditional formatting rule to the report, which changes the appearance of the rows that match the condition. You can specify the condition type, expression, column, operator, and value. You can also choose the highlighting style, such as background color, text color, or icon. The other options are incorrect because: Provide a conditional SQL query: This option will not highlight certain rows in the interactive report based on a condition. It will filter the data in the report by applying a WHERE clause to the SQL query that defines the report source. Edit the rows in the report and select a color: This option will not highlight certain rows in the interactive report based on a condition. It will modify the data in the report by using inline editing or modal dialog editing. You cannot select a color for the rows in this option. Rows cannot be highlighted in an Interactive report: This option is false. Rows can be highlighted in an Interactive Report by using the Format > Highlight option. Verified References: [Customizing Interactive Reports] [Highlighting Rows Based on Conditions]
Question 24
Select the three types of Card Layout you can create in APEX.
Correct Answer: B,C,D
Explanation You can create two types of card layout in APEX: Float and Grid. Float layout displays cards in a single row that wraps to the next row when the available space is filled. Grid layout displays cards in a fixed number of columns that can be responsive to the screen size1. Vertical and Horizontal are not valid card layout types in APEX.
Question 25
I want to hide a few columns in my interactive report. To do so, which option should I choose fromthe Actions menu?
Correct Answer: C
Explanation To hide a few columns in your interactive report, you should choose Columns from the Actions menu. This option allows you to select which columns to show or hide in your report by using checkboxes. You can also reorder or resize the columns from this option. The other options are incorrect because: Filter allows you to filter the data in your report by applying one or more conditions on the columns. Data allows you to add, modify, or delete data in your report by using inline editing or modal dialog editing. Format allows you to change the appearance of your report by applying conditional formatting rules or highlighting colors. Verified References: [Customizing Interactive Reports] [Actions Menu]