Select the three types of Facets you can create in APEX.
Options:
A.
Range
B.
Text Area
C.
Checkbox Group
D.
Input Field
Answer:
A, C, D
Explanation:
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 25
Choose the three types of aggregations you can apply on a column.
Options:
A.
Average
B.
Standard Deviation
C.
Sum
D.
Count
Answer:
A, C, D
Question 26
Which two tasks can you perform using App Builder?
Options:
A.
Create join queries using drag and drop.
B.
Generate data definition language (DDL) statements from the Oracle data dictionary.
C.
Import previously exported apps.
D.
Create and manage apps.
E.
Create and manage database objects.
Answer:
C, D
Explanation:
Explanation:
App Builder is the main interface of Oracle APEX that allows developers to create and manage web applications. App Builder provides various features and tools to design, develop, test, debug, deploy, and maintain applications. Some of the tasks that you can perform using App Builder are importing previously exported apps, creating new apps from scratch or from predefined templates or blueprints, editing app properties and attributes, adding pages and regions, creating shared components, running and debugging apps, exporting apps to files or workspaces, etc. You cannot create join queries using drag and drop or generate DDL statements from the Oracle data dictionary using App Builder. Verified References: [Using App Builder - Oracle Help Center], [App Builder Concepts - Oracle Help Center]
Question 27
Select the two places from where you can access the Shared Components Page?
Options:
A.
Gallery
B.
Page Designer
C.
Application homepage
D.
SQL Workshop
Answer:
B, C
Explanation:
Explanation:
You can access the Shared Components page from two places in App Builder: the Page Designer and the Application home page. In Page Designer, you can click on the Shared Components icon at the top of the page to open the Shared Components page in a new tab5. In the Application home page, you can click on the Shared Components link in the center of the page to navigate to the Shared Components page6. Gallery, SQL Workshop, and other pages do not have direct links to the Shared Components page.