You have an interactive grid component and you are enabling the Save Public Report attribute. As what can end users save the report type?
Correct Answer: D
Explanation When you enable the Save Public Report attribute for an interactive grid, end users can save their report preferences as either private or public reports. Private reports are only visible to the user who created them, while public reports are visible to all users who have access to the interactive grid. You can also specify an authorization scheme to control who can save public reports. Verified References: Managing Interactive Grids - Oracle Help Center, [Interactive Grid Attributes - Oracle Help Center]
Question 32
In a faceted search page, facets can be displayed as different UI types. Which two facet item types are supported in the faceted search region?
Correct Answer: B,C
Explanation 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]
Question 33
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 34
Select the three types of Facets you can create in APEX.
Correct Answer: A,C,D
Explanation A facet is a type of component that provides a set of display values and return values for a faceted search region or a smart filters region. A facet can be based on either static values or dynamic values from a list of values (LOV). A facet can also have different display styles depending on its type and settings. Three of the types of facets that you can create in APEX are: Range: A range facet displays numeric values in either buckets or sliders that users can select or adjust to filter the search results. A range facet can have either static values or dynamic values based on an LOV or SQL query. Checkbox Group: A checkbox group facet displays multiple options that users can select or deselect to filter the search results. A checkbox group facet can have either static values or dynamic values based on an LOV or SQL query. Input Field: An input field facet displays a text field that users can enter text to filter the search results. An input field facet does not have any values but uses an operator to compare the user input with the data.
Question 35
Which two statements are true about loading data from the "Create an Application From a File" wizard?
Correct Answer: B,D
Explanation The "Create an Application From a File" wizard is a tool that allows developers to create an application based on an existing spreadsheet file or sample data set. Some of the statements that are true about loading data from this wizard are: A sample data set from the sample list can be uploaded. You can use the Sample Data Sets option to select a predefined data set from a list of available samples, such as Employees, Products, Projects, etc. CSV, XLSX, XML, TXT, or JSON files can be uploaded. You can use the Upload a File option to upload a spreadsheet file in one of these formats and create an application based on its data. You cannot upload seed data from a SQL script, paste and load XML and JSON data, or upload data from remote web services using this wizard. You can use other features in App Builder or SQL Workshop to perform these actions, such as SQL Scripts, RESTful Services, etc. VerifiedReferences: [Creating an Application From a File - Oracle Help Center], [Creating an Application Based on Sample Data Sets - Oracle Help Center]