You added Access Control feature pages to your application.
Which two actions can you perform as an Administrator using the Administration page? (Choose two.)
ACreate Authorization schemes
BCreate new application roles
CAdd Users
DAssign roles to users
0
Question 2
App Builder
0
Question 3
Data Modeling and Queries
0
Question 4
App Builder
0
Question 5
Administration, Security, and Deployment
0
That's the end of the Preview
This exam has 57 community-verified practice questions. Create a free account to access all questions, comments, and explanations.
Topics covered:
Application Development ConceptsData Modeling and QueriesApp BuilderShared ComponentsAdministration, Security, and Deployment
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? (Choose two.)
APopup LOV
BRange
CDate Picker
DCheckbox Group
Which two statements are true about creating and using an interactive report? (Choose two.)
AYou can specify an Authorization Scheme at the column level.
BYou cannot customize the Search Button Label.
CYou cannot restrict users from saving private reports by using the Authorization Scheme.
DYou cannot include Form Page when creating an interactive report page using the Create Page Wizard.
Which is a valid Page Process type?
ASend E-Mail
BExecute JavaScript Code
CSet Value
Which statement is true about importing an APEX application?
AThe import process does not import the supporting objects defined during the export.
BYou cannot import an APEX application exported from a latest APEX version to an old APEX version.
CYou cannot change the application ID during the import process.
Question 6
Administration, Security, and Deployment
0
Question 7
App Builder
Question 8
App Builder
Question 9
Application Development Concepts
Question 10
App Builder
Question 11
Data Modeling and Queries
Question 12
App Builder
Question 13
App Builder
Question 14
Administration, Security, and Deployment
Question 15
App Builder
Question 16
App Builder
Question 17
App Builder
Question 18
App Builder
Question 19
App Builder
Question 20
Application Development Concepts
Question 21
App Builder
Question 22
App Builder
Question 23
Application Development Concepts
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ad
Want a break from the ads?
Become a Supporter and enjoy a completely ad-free experience, plus unlock Learn Mode, Exam Mode, AstroTutor AI, and more.
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Ask AstroTutor
0
Which two statements are true about creating and managing an APEX Workspace? (Choose two.)
ADuring workspace creation, you can associate the workspace with an existing database schema.
BNew schemas cannot be created during workspace creation.
CYou can create only two workspaces in an APEX Service (APEX Application Development) instance.
DA workspace enables multiple users to work within the same Oracle APEX installation.
EA workspace can be associated with only one schema.
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?
ASide by Side
BDrill Down
CStacked
There is a page with an interactive grid region based on this statement:
In the Interactive Grid attributes, under the Edit group, the Enabled switch is turned Off.
Which are two of the actions that you must perform to make an employee's commission editable in the grid? (Choose two.)
AIn the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group.
BIn the Interactive Grid attributes, select CCMM for "Allowed Row Operations Column".
CSet EMPNO, ENAME to "Display Only".
DEnsure that the "Primary Key" switch is turned "On" for the EMPNO column.
You created a shopping cart application and added the "Add to Cart" functionality. You are using an APEX Collection named CART to temporarily store the items in the cart.
Which PL/SQL Code snippet can be used to add items (PRODUCT_ID) into this APEX collection when the user adds items to the cart?
Assume :P2_PRODUCT_ID holds the product id of the item being added to the cart.
A
B
C
Which two actions enable "hide and show" behavior of a data series in a bar chart when its corresponding legend item is clicked? (Choose two.)
ASetting the Hide and Show Behavior attribute value to No Rescaling
BSetting the Hide and Show Behavior attribute value to None
CSetting the Hide and Show Behavior attribute value to Rescale
DSetting the On Data Change attribute value to Slide to Left
Which statement is true about the Data Workshop utility?
AThe wizards load and unload all types of schema objects.
BThe wizards load and unload table data only.
CYou cannot load data from an XLSX file with multiple worksheets.
DYou can load or unload multiple tables at a time.
An application includes a form on the EMPLOYEES table.
You must limit the P5_MANAGER page item so users can select a single employee name EMP_NAME and save the corresponding employee ID EMP_ID to the database.
Examine this statement used for the List of Values definition:
Which item type can be used to display P5_MANAGER?
APopup LOV
BCheck box
CSwitch
Which two layout options are available for Page Designer under Utilities? (Choose two.)
AFour Pane Mode
BThree Pane Mode
CTwo Pane Mode
DSingle Pane Mode
Which statement is true about session state management in Oracle APEX?
AAPEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests.
BMultiple number of sessions cannot exist in the database at the same time.
CA user cannot run multiple instances of an application simultaneously in different browser programs.
Which two statements are true about creating and using dynamic actions? (Choose two.)
AYou can execute JavaScript code by creating a dynamic action.
BIf a client-side condition is defined, the true action will fire when the condition is met, and the false action will fire when it is not.
CIf no client-side condition is defined, true actions will not fire.
DOnce you create a dynamic action, you cannot add additional true actions.
Which statement is true about creating and using pages in an APEX application?
AYou can copy a page only from the current application.
BModal and nonmodal dialog pages are supported only if the current application theme contains at least one-page template of type Dialog Page.
CA user cannot interact with a nonmodal dialog and content on the page.
Which two statements are true about loading data from the "Create an Application From a File" wizard? (Choose two.)
AA sample data set from the sample list can be uploaded.
BData from remote web services can be uploaded.
CSeed data from a SQL script can be uploaded.
DXML and JSON data can be pasted and loaded.
ECSV, XLSX, XML, TXT, or JSON files can be uploaded.
Which two Plugin types can be created in Oracle APEX? (Choose two.)
AValidation
BProcess
CRegion
DEmail Template
An application includes these features:
an Employees interactive report region on a page
two page items: P6_JOB and P6_DEPTNO
P6_JOB is a select list type to display Job list of values.
P6_DEPTNO is a select list type to display Department list of values.
When the Job or Department select list values are changed, the report must be refreshed to display newly scoped employees.
Which step must be performed to implement this functionality?
ACreate a dynamic action on P6_JOB and P6_DEPTNO that uses the Show action to refresh and display the value of P6_JOB and P6_DEPTNO items.
BCreate a P6_RESET button and then create a dynamic action firing when the Reset button is clicked and uses the Set Value native action to trigger the refresh of the Employees interactive report region.
CCreate a dynamic action on P6_JOB and P6_DEPTNO that uses the Refresh native action to trigger the refresh of the Employees interactive report region.
DCreate a P6_RESET button and then create a dynamic action firing when the Reset button is clicked and uses the Refresh native action to trigger the refresh of the Employees interactive report region.
Which two callback procedures or functions apply to APEX plug-ins? (Choose two.)
AData
BKeyboard
CAJAX
DRender
EJavascript
You use the Create Page Wizard to create a faceted search page on the EMP table.
What is the default report type generated for this page?
AInteractive Grid
BInteractive Report
CColumn Toggle Report
DClassic Report
Which two statements are true about Faceted Search pages? (Choose two.)
AA facet's chart can be seen only in a nonmodal dialog.
BMultiple charts are not visible in the same region.
CFaceted Search supports the ability to filter columns storing multiple values as one string.
DFacets map to specific database columns.
Which two functions can be used by an end user when pivoting an interactive report? (Choose two.)