Question 1:

*Which two approaches can be used to create custom stored procedures in SQL

Workshop?

Skipped

Using Object Browser

(Correct)

Using Quick SQL

Using Data Workshop

Using SQL scripts

(Correct)

Question 2:

Which statement is true about creating and using pages in an APEX application?

You can copy a page only from the current application.

Skipped

Modal and nonmodal dialog pages are supported only if the

current application theme contains at least one page template of

type Dialog Page.

A user cannot interact with a nonmodal dialog and content on the page.

Question 3:

Which two tools are included in SQL Workshop?

Object Browser

Skipped

(Correct)

Team Development

Gallery

Milestones

SQL Scripts

(Correct)

Skipped

Question 4:

*Which two statements are true about REST Data Source Synchronization?

If the local table is not in sync with the Data Profile, Data
Synchronization continues to work for columns present in both

the table and the Data Profile.

(Correct)

You cannot trigger Data Synchronization on a regular schedule using a

scheduler job.

The local table can only be used for Data Synchronization but you cannot

add indexes or change physical properties.

If the local table is not in sync with the Data Profile, Data Synchronization

doesn't work.

To execute REST source synchronizations on schedule, the

CREATE JOB privilege must be granted to the application's parsing (Correct)

schema.

Question 5:

*You added Access Control feature pages to your application. Which two actions

can you perform as an Administrator using the Administration page?

Add Users

Skipped

(Correct)

Create Authorization schemes

Assign roles to users

(Correct)

Skipped

Question 6:

*Which two statements are true about creating and using an interactive report?

You cannot include Form Page when creating an interactive report page

using the Create Page Wizard.

You cannot customize the Search Button Label.

You can specify an Authorization Scheme at the column level.

(Correct)

You cannot restrict users from saving private reports by using the

Authorization Scheme.

(Correct)

Question 7:

Which two statements are true about the Link Column attribute of an interactive

report?
Skipped

If you select Link Column, it is always displayed as the last column

in the report.

(Correct)

A Link Column cannot be sorted, hidden, or moved by an end user.

(Correct)

It is not possible to exclude Link Column.

It is not possible to include a custom target in Link Column.

Skipped

Question 8:

*Which client credentials are utilized for authentication during the One-Click

Remote Application Deployment process?

APEX Workspace Admin credentials

Database schema credentials

(Correct)

APEX Developer credentials

Skipped
Which two statements are true about low code application development with

Oracle APEX?

Question 9:

Using APEX, you can build mission-critical enterprise apps

(Correct)

Apps cannot natively access Oracle Database capabilities

The application definition is not stored in the database

Application Development IDE is web browser

(Correct)

Data processing is not done in the database

Skipped

Question 10:

Which two are features of the Data Load utility in Data Workshop?

Create an application from the data loaded

Omit (skip) columns when data loading

(Correct)
Load data into multiple tables at once

Omit (skip) records when loading based on a function

Load XML, JSON, XLSX files, or delimited-field text files

(Correct)

Skipped

Question 11:

*Which two statements are true about Oracle APEX?

You can build interactive reporting apps based on data from

disparate systems.

(Correct)

Processing and data manipulation is not executed in the database.

APEX eliminates middle-tier application logic.

Running an APEX app needs client software.

Application definition is not stored in the database.

(Correct)

Question 12:
*There is a page with an interactive grid region based on this statement: SELECT

EMPNO, ENAME, COMM from EMP; 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?

Set EMPNO, ENAME to "Display Only".

Skipped

In the Interactive Grid attributes, select COMM for "Allowed Row Operations

Column".

Ensure that the "Primary Key" switch is turned "On" for the

EMPNO column.

(Correct)

In the Interactive Grid attributes, turn "On" the Enabled switch,

under the Edit group.

(Correct)

Question 13:

*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: SELECT emp_name d, emp_id r

from employees ORDER BY 1; Which item type can be used to display

P5_MANAGER?
Skipped

Switch

Popup LOV

(Correct)

Check box

Skipped

Question 14:

Which statement is true about provisioning an APEX workspace?

You can create only one workspace in an APEX instance

You cannot associate an existing database schema with your workspace

A workspace is not associated with any schema

An APEX workspace is a shared work area where multiple

developers can build applications

(Correct)

Question 15:

*Examine this code entered in Quick SQL: emp_salary name vc255 salary num

commission yn/check TRUE, FALSE Which statement is true about the commission

yn column?
Skipped

It will default to TRUE.

It will restrict acceptable values to TRUE or FALSE

(Correct)

It will default to FALSE.

It will restrict acceptable values to Y or N.

Skipped

Question 16:

*Which two statements are true about Faceted Search pages?

A facet's chart can be seen only in a nonmodal dialog.

Facets map to specific database columns.

(Correct)

Faceted Search supports the ability to filter columns storing multiple values

as one string.

Multiple charts are not visible in the same region.

(Correct)
Question 17:

Which two approaches can be used to create custom stored procedures in SQL

Workshop?

Skipped

Procedure Builder

Standalone SQL commands

(Correct)

Quick SQL

Data Workshop

SQL scripts

(Correct)

Question 18:

You must generate a SQL insert statement for the DEPT table in Quick SQL. Which

two statements will do that?

Skipped

dept /insert name

dept/insert 1 name

(Correct)

dept /insert 1 name

(Correct)

Skipped

Question 19:

*Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?

On the remote Oracle Database, install ORDS 19.x or later.

(Correct)

REST enable the schema in the remote Oracle Database using

ORDS. ENABLE_SCHEMA.

(Correct)

Create a database link to the remote Oracle Database in the local APEX

Schema.

Install Oracle APEX in the remote Oracle Database.

Skipped
Question 20:

Which two form types can you create in an APEX application?

Rest Data Source

Editable Interactive Grid

(Correct)

Master Detail

(Correct)

Quick Edit

Smart Filters

Question 21:

Which two preconfigured authentication schemes are supported by Oracle APEX?

Database Accounts

Skipped

(Correct)

Contribution Rights
Administration Rights

Social Sign-in

(Correct)

Reader Rights

Skipped

Question 22:

*Which two layout options are available for Page Designer under Utilities?

Three Pane Mode

(Correct)

Two Pane Mode

(Correct)

Four Pane Mode

Single Pane Mode

Skipped

Question 23:

*Which is NOT a valid Geometry Column Data Type available for maps region?
GeoJSON

SDO GEOMETRY

Latitude/Longitude

JSON_OBJECT

(Correct)

Question 24:

Which is a standard for exchanging authentication and authorization information

between different security domains, to provide cross-organization single sign-on?

Virtual Private Database (VPD)

Skipped

Sign-on System

Open ID

Security Assertion Markup Language

(Correct)

Question 25:

Which statement is true about creating and using a calendar in an APEX

The data source for your calendar can only be a local database, not an

external datasource

Skipped

Calendars in APEX are based on a table or SQL query you provide

(Correct)

You can create a calendar only by using the Create Page Wizard, not as a

region on an existing page

You can create a calendar only by using the Create Application Wizard, not

by using the Create Page Wizard

Question 26:

*Which two feature pages can you create using the Create Page Wizard?

Search Page

Skipped

Feedback

(Correct)

Unified Task List

(Correct)

Question 27:

By default, which interactive grid report type can be created by an end user?

Primary report

Skipped

Private report

(Correct)

Public report

Alternative report

Question 28:

Which two statements are true about creating and customizing Smart Filters

pages?

Skipped

The search results report can be displayed as an interactive grid.

If you create a Smart Filters page based on a table, the filters are

auto discovered using the Data Dictionary Cache.

The search results report can be displayed as an interactive report.

The suggestion chip count is only displayed for filters that support

counts, such as LOV-based filter types.

(Correct)

Skipped

Question 29:

What you can export by using the Export/Import utility?

Uploaded cascading stylesheets

Application

All the options

(Correct)

Uploaded images

Skipped

Question 30:

Which is NOT a Preconfigured Authentication Scheme?

Application Express Accounts

No Authentication

Closed Door Credential

(Correct)

Question 31:

*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?

BEGIN APEX COLLECTION.ADD_MEMBER ( p collection_name =>

'CART', P_c001=> :P2_PRODUCT_ID ); END;

Skipped

(Correct)

Assume: P2_PRODUCT_ID holds the product id of the item being added to

the cart.

BEGIN INSERT INTO CART (id, c001) values (1, P2_PRODUCT_ID); END:

BEGIN INSERT INTO APEX COLLECTION (id, name, c001) values (1, 'CART'
:: P2_PRODUCT_ID); END:

Question 32:

Which Two statements are true about using Oracle APEX Application Development

(APEX Service)?

Skipped

There is a limit on the number of applications that can be developed

It includes Oracle Database Actions (SQL Developer Web)

(Correct)

There is a limit on the number of developers using your service

There is a limit on the number of end users using your apps

It includes Oracle REST Data Services (ORDS)

(Correct)

Question 33:

Skipped

Which statement is true about a Progressive Web Application (PWA)?

PWA features will be rendered even in an unsecured environment

You can only create a PWA when creating a new app. You cannot make an
existing app a PWA

To make an existing app a PWA, you must verify that the Friendly URLs

attribute is off in the Application Definition, Properties section

Enabling PWA functionality in your APEX app adds a new

navigation bar entry named Install App to your application

(Correct)

Question 34:

Jenny has a form page based on ORDER_ITEMS. For certain product types, she

needs to redirect to a modal dialog page to ask for additional information, before

validating or processing the record on page submission. Which processing point

should Jenny select for the branch?

Skipped

After Processing

Processing

Before Computations

After Submit

(Correct)

Skipped
A user cannot run multiple instances of an application simultaneously in

different browser programs.

Question 35:

*Which statement is true about session state management in Oracle APEX?

Multiple number of sessions cannot exist in the database at the same time.

APEX Sessions are logically and physically distinct from Oracle

database sessions used to service page requests.

(Correct)

Skipped

Question 36:

*Which statement is true about creating and using an interactive grid?

An interactive grid supports Pivot View and Group By View features

For both editable and noneditable interactive grids, end users can

change the report layout and create private reports.

(Correct)

End users cannot rearrange columns by dragging and dropping.

*You have defined a REST Data Source with ORDS as the REST Data Source Type.

This REST Data Source is based on an AutoREST-enabled EMP table on a remote

Oracle Database. This REST Data Source is being used as source for an editable

interactive grid. When a user updates an employee record in this interactive grid,

which operation (HTTP Method) defined in the REST Data Source is utilized to

update a record in the EMP table on the remote Oracle Database?

POST

Skipped

PUT

(Correct)

GET

Skipped

Question 38:

*Which two statements are true about loading data from the "Create an Application

from a File" wizard?

CSV, XLSX, XML, TXT, or JSON files can be uploaded.

(Correct)

Data from remote web services can be uploaded.

(Correct)

XML and JSON data can be pasted and loaded.

Seed data from a SQL script can be uploaded.

Skipped

Question 39:

*Which statement is true about Unified Task List in the Approvals component?

It is a page type in the Create Page Wizard that is used to create a

summary of tasks that functions like an inbox.

(Correct)

It is a page that shows details for a specific task, which can include

metadata, history, comments, and actions.

It is a shared component used to configure task parameters, participants,

actions, and due dates.

Question 40:

*Which two statements are true about creating and managing an APEX

Workspace?
Skipped

During workspace creation, you can associate the workspace with

an existing database schema.

(Correct)

New schemas cannot be created during workspace creation.

A workspace enables multiple users to work within the same

Oracle APEX installation.

(Correct)

You can create only two workspaces in an APEX Service (APEX Application

Development) instance.

A workspace can be associated with only one schema.

Question 41:

Which pane in Page Designer allows the editing of a component's properties?

Toolbar

Skipped

Right pane

(Correct)
Left pane

Central pane

Skipped

Question 42:

*Which statement is true about importing an APEX application?

The import process does not import the supporting objects defined during

the export.

You cannot import an APEX application exported from a latest

APEX version to an old APEX version.

(Correct)

You cannot change the application ID during the import process.

Skipped

*Which two tasks can you perform using SQL Workshop?

Track and manage issues in a conversational fashion.

Question 43:

Load and unload text, DDL, and spreadsheet data.

(Correct)
Create join queries using drag and drop.

(Correct)

Install and manage Sample Apps.

Edit an application page.

Skipped

Question 44:

Which two processes takes place when the APEX engine runs Accept Page?

Save submitted values

(Correct)

Show page

Navigation to different pages

Computations and validations

(Correct)

Question 45:

Which statements are true about creating applications using Oracle APEX?

Oracle APEX application pages share a common session state and

Skipped

(Correct)

Using the Create Application Wizard, you can only create an application from

file

When creating an application from a file, you can only load data into a new

table but not to an existing table.

Once an application is created, you cannot create additional pages (Correct)

Using the Create Application Wizard, you can only create an application

based on existing tables

Skipped

Question 46:

Which two tasks can you perform by using Page Designer?

Copy an application

Import an application

Add a new region or an item

(Correct)
Create an application

Modify a button

(Correct)

Question 47:

*Which two statements are true about customizing an interactive report by an end

user?

Skipped

Mathematical computations can be added to columns.

(Correct)

From the Actions menu, multiple charts can be created.

Standard Oracle functions cannot be added to columns.

A flashback query can be executed.

(Correct)

Question 48:

Skipped

Which two tasks can you perform using App Builder?

Create and manage apps.

Import previously exported apps.

(Correct)

Create and manage database objects.

(Correct)

Generate data definition language (DDL) statements from the Oracle data

dictionary.

Question 49:

*Which two statements are true about the APEX_MAIL API?

Skipped

You can add files as attachments to your emails using the

APEX_MAIL package.

(Correct)

The APEX_MAIL package supports sending emails only to Oracle database

users.

You can send emails using the APEX_MAIL package from an Oracle

APEX application.
(Correct)

You can receive emails using the APEX_MAIL package in an Oracle APEX

application.

Question 50:

*An application includes a report and form on the PRODUCTS table. The form page

includes page items P21_PRODUCT_NAME and P21_UNIT_PRICE. P21_UNIT_PRICE

is currently displayed below P21_PRODUCT_NAME. Now, you need to reposition

the items and display P21 UNIT PRICE next to P21 PRODUCT NAME. Which two

statements are true?

In Page Designer, right-click P21_UNIT_PRICE and select Start New Row.

Skipped

In Page Designer, select P21_PRODUCT_NAME and then in the Property

Editor, under Layout set Start New Row to Yes.

In Page Designer, select P21_UNIT_PRICE and the in the Property

Editor, under Layout set Start New Row to NO.

(Correct)

In Page Designer, use the Middle Pane, click P21_UNIT_PRICE and

drag the item until it is directly next to P21 PRODUCT NAME.

(Correct)
Question 51:

Which two functions can be used by an end user when pivoting an interactive

report?

Skipped

List aggregate

Median

(Correct)

Rank

Minimum

(Correct)

List aggregate

Question 52:

An application was created using the Create Application Wizard which enabled the

Access Control feature. Which two components are created when enabling the

Access Control feature?

Skipped

The configuration page to set roles of workspace users

The administrative page region with links to Access Control

feature

(Correct)

The configuration page to enable Administrators to select default theme.

The configuration page to set access level of authenticated users

The configuration page to enable end users to select various theme styles

Question 53:

Examibe these statements: create table dept ( id number generated by default on

null as identity constraint dept_id_pk primary key, name varchar2 (255 char) not

null, age number ); create table emp ( id number generated by default on null as

identity constraint emp_id_pk primary key, dept id number constraint

emp_dept_id_fk references dept on delete cascade, name varchar2 (255 char) not

null, email varchar2 (255 char) constraint emp_email_ung unique, position varchar2

(8 char) constraint emp_position_ck check (position in ('MANAGER', 'CLERK'

'ENGINEER')) ); Which Quick SQL code can generate these statements?

dept name /nn age num emp name /nn email /unique

position/check Manager, Clerk, Engineer

Skipped

(Correct)
dept name /nn age num emp name /nn email /unique position /check

Manager, Clerk, Engineer

dept name /nn age num emp name /nn email /unique position /check

Manager, Clerk, Engineer

dept name /nn age num emp name /nn email /unique position /values

Manager, Clerk, Engineer

Skipped

Question 54:

*Which is a valid Page Process type?

Set Value

Execute JavaScript Code

Send E-Mail

(Correct)

Skipped

In the Create Application Wizard, you can select a data source (that is, Local

Database, REST Enabled SQL Service, or REST Data Source).

Question 55:

*Which statement is true about creating and using a report with form?
C

The Create Application Wizard doesn't support the creation of an interactive

report and form combination.

The Create Page Wizard doesn't support the creation of a classic report and

form combination.

Both the Create Application Wizard and Create Page Wizard

support the creation of an interactive report or classic report and

form combination.

(Correct)

Question 56:

*(q3_PIC) Now you must extend the functionality of this form so that: <PIC> . If you

select 'SALESMAN' from the select list for Job page item (P2_JOB), both the 'Hire

date' (P2_HIREDATE) and 'Commission' (P2_COMM) page items and their

associated labels are displayed . If you select any other value from the select list for

Job page item (P2_JOB), both the 'Hire date' (P2 HIREDATE) and 'Commission'

(P2_COMM) page items and their associated labels are hidden Which two steps

must be performed?

Create a dynamic action on P2_HIREDATE and P2_COMM.

Skipped
Create a dynamic action on P2_JOB.

(Correct)

Specify a client-side condition of type Item = Value and enter

SALESMAN for Value.

(Correct)

Create a dynamic action on P2_JOB, P2_HIREDATE, and P2_COMM.

Create a dynamic action on form load.

Question 57:

*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?

Checkbox Group

Skipped

(Correct)

Popup LOV

Range

(Correct)

Date Picker
Question 58:

Which two types of calendars are supported by App Builder?

Calendar

Skipped

(Correct)

Legacy Calendar

(Correct)

Global Calendar

Regional Calendar

Skipped

Question 59:

*You have an interactive grid component and you are enabling the Save Public

Report attribute. As what can end users save the report type?

As Private only

(Correct)

As Public only
As Private and Public only

As Primary only

Question 60:

*Which two statements are true about creating and using dynamic actions?

If no client-side condition is defined, true actions will not fire.

Skipped

If 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.

(Correct)

Once you create a dynamic action, you cannot add additional true actions.

You can execute JavaScript code by creating a dynamic action.

(Correct)

Skipped

Which statement is true about implementing security in your APEX application?

You can apply an authorization scheme to an entire application or

its components

Question 61:
(Correct)

Confirming a user's identity before allowing access to the application is

known as authorization

Authentication refers to restricting access to specific pages and

components in your application based on your privileges

Once created, you cannot change the authentication scheme associated

with an application

Question 62:

In your existing Employee Benefits application, you want to determine the most

active users, the most used pages, and the performance of pages to better

understand how your application is being utilized and areas for improvement. How

ran this be achieved?

On the Application Home page, click Create Page. In the Create Page Wizard,

select the Email Reporting feature type.

Skipped

On the Application Homo page, click Create Page. In the Create

Page Wizard, select the Activity Reporting feature typo

(Correct)

On the Application Home page, click Create Page. In the Create Page Wizard,

select the Master Detail page type.

Page button Then select the feedback feature type.

Skipped

You can unload data from the database.

Question 63:

*Which statement is true about using SQL Commands?

You can search and filter database objects.

You can design and prototype data models using a markdown-like

shorthand syntax.

In SQL Commands, you can view queries saved in Query Builder.

(Correct)

Skipped

Question 64:

Which two actions can you perform using the Object Browser?

Browse database objects of the current schema.

Create a lookup table based on a column in the current table

(Correct)

Create and run SQL scripts.

Restore dropped database objects.

Export and import SQL scripts.

Skipped

Question 65:

In which two cases, can you use classic reports?

To provide optimal reports on smart phones

To provide basic sort and search options

(Correct)

To provide options to save your customization within the application

To provide the customization option

To provide the download option

(Correct)
Skipped

Question 66:

Which statement is true about creating and using forms in an APEX application?

You can create a form only by using the Create Page Wizard. You can create a

form in Page Designer

You can create a form only by using the Create Application Wizard. You

cannot create a form in Page Designer

A Stacked Master Detail is a single page master-detail utilizing side-by-side

layout and report regions with modal edit windows

The Master Detail form enables users to insert, update, delete

values from two tables or views

(Correct)

Question 67:

Which two types of pages can you create by using the Create Page Wizard?

Interactive Grid

Skipped

(Correct)
Team Development

Utilities

Shared components

Blank Page

(Correct)

Question 68:

(q2_PIC) Which two statements are true about the Create Application Wizard?

<PIC_1_&_2)

Skipped

It allows application pages to be reordered.

(Correct)

It allows application pages to be added or deleted.

(Correct)

It allows the uploading of JavaScript or CSS files required for an application.

It allows the application authorization to be changed.

Skipped
Question 69:

Which statement is true about exporting and importing your APEX application?

Using the Export Application Wizard, you can only export the application but

not the supporting object definitions

Your application is saved as .txt file

You can export APEX application as zip file

(Correct)

You can export an APEX application from an instance running APEX 22.1 and

import into APEX 21.1 version

Question 70:

*Which statement is true about creating and using a faceted search page?

The Search Results region can be displayed as a Classic Report or

Cards.

Skipped

(Correct)

If you create a faceted search page on a view or a SQL query, the facets are

auto-discovered.
If you create a faceted search page based on a table, the facets are not auto-

discovered.

The Search Results region can be displayed as an interactive report.

Question 71:

*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?

Column Toggle Report

Skipped

Interactive Grid

Interactive Report

Classic Report

(Correct)

Skipped

Question 72:

*You require a Page Computation to execute before the page is rendered. Which

two computation points (Execution Point) will do this?

Before Header
(Correct)

After Header

(Correct)

After Page Processing

After Submit