Questions and Answers PDF 1/51

Thank You for your purchase

om
Oracle 1Z0-771 Exam Question & Answers
Oracle APEX Cloud Developer Professional Exam

.c
ps
m
du
am
ex
id
al
.v
w
w
// w
s:
tp
ht

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 2/51

Product Questions: 53
Version: 4.0

om
.c
ps
m
Question: 1

du
am
ex

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?
id
al
.v
w

A. Popup LOV
w
w

B. Range
//
s:

C. Date Picker
tp

D. Checkbox Group
ht

Answer: B, D

Explanation:

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 3/51

In Oracle APEX, a faceted search page allows users to filter data using facets, which are displayed as
UI components in the Faceted Search region. According to the Oracle APEX documentation, the
supported facet item types include:

Range: Used for numeric or date ranges, allowing users to filter data within a specified range (e.g.,
salary or hire date).

Checkbox Group: Used for multi-select options, enabling users to select multiple values from a list
(e.g., departments).

om
Other types like Popup LOV and Date Picker are valid item types in APEX but are not natively
supported as facet types in the Faceted Search region. Popup LOV is typically used for single-value

.c
selection in forms, and Date Picker is a standalone item type, not a facet-specific UI.

ps
Reference: Oracle APEX 23.2 Documentation - "Managing Faceted Search" under Application Builder

m
User's Guide.

du
am
ex

Question: 2
id
al

Which two SQL format options does the APEX Assistant provide when using the "Create Data Model
.v

using AI" feature?

w
w
w

A. Quick SQL
//

B. MySQL
s:
tp

C. Oracle SQL
ht

D. Oracle PL/SQL

Answer: A, C

Explanation:

The "Create Data Model using AI" feature in APEX Assistant leverages AI to generate data models

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 4/51

based on natural language input. The supported SQL format options are:

Quick SQL: A shorthand syntax for defining database objects, which APEX can convert into full DDL.

Oracle SQL: Standard SQL syntax compatible with Oracle Database for creating tables and other
objects.

MySQL is not supported as it’s specific to a different database system, and Oracle PL/SQL is a
procedural language, not a format for defining data models in this context.

Reference: Oracle APEX 23.2 Documentation - "Using APEX Assistant" under AI Features.

om
.c
ps
Question: 3

m
du
At what level does a developer enable push notifications so that end users can receive them on their
devices from an APEX application?
am
ex

A. Region
id

B. Application
al
.v

C. Page
w

D. Instance
w
// w

Answer: B
s:
tp

Explanation:
ht

Push notifications in Oracle APEX are enabled at the application level. This allows the application to
register with the Progressive Web App (PWA) framework and manage subscriptions for all end users.
Once enabled in the Application Definition under "Progressive Web App" settings, APEX handles the
subscription process, and developers can use APIs like APEX_PWA.SEND to send notifications.
Enabling at the region, page, or instance level is not supported for this feature.

Reference: Oracle APEX 23.2 Documentation - "Enabling Push Notifications" under Application
Definition Attributes.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 5/51

Question: 4

In which two formats can the GetCurrentPosition Dynamic Action in Oracle APEX return coordinates?

A. Function Body returning SQL Query

om
B. Latitude and Longitude

.c
C. GeoJSON

ps
D. State and Pincode

m
du Answer: B, C
am
ex

Explanation:
id
al

The GetCurrentPosition Dynamic Action retrieves geolocation data from the user's device. It
.v

supports:
w
w

Latitude and Longitude: Returns coordinates as separate numeric values (e.g., lat: 37.7749, lon: -
w

122.4194).
//

GeoJSON: Returns coordinates in a structured JSON format compliant with the GeoJSON standard
s:

(e.g., { "type": "Point", "coordinates": [-122.4194, 37.7749] }).

tp

Function Body returning SQL Query is a dynamic action type, not a coordinate format, and State and
ht

Pincode is unrelated to geolocation coordinates.

Reference: Oracle APEX 23.2 Documentation - "Using GetCurrentPosition Dynamic Action" under
Dynamic Actions.

Question: 5

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 6/51

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

A. Using Quick SQL

B. Using Data Workshop

C. Using SQL Scripts

D. Using Object Browser

om
Answer: C, D

.c
ps
Explanation:

m
In SQL Workshop, custom stored procedures can be created using:du
am
SQL Scripts: Allows developers to write and execute PL/SQL code directly to define stored
ex

procedures.
id

Object Browser: Provides a GUI to create and edit database objects, including stored procedures, by
al

defining their specifications and bodies.

.v

Quick SQL is for generating table DDL, not stored procedures, and Data Workshop is for
w

loading/unloading data, not creating procedures.

w

Reference: Oracle APEX 23.2 Documentation - "SQL Workshop Guide" under SQL Scripts and Object
w

Browser sections.
//
s:
tp
ht

Question: 6

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

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

B. Install ORDS 19.x or later on the remote Oracle Database.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 7/51

C. REST-enable the schema in the remote Oracle Database by using ORDS.ENABLE_SCHEMA.

D. Install Oracle APEX in the remote Oracle Database.

Answer: B, C

Explanation:

om
To use REST-enabled SQL in APEX:

.c
Install ORDS 19.x or later: Oracle REST Data Services (ORDS) must be installed and configured on the

ps
remote database.

m
REST-enable the schema: The schema on the remote database must be REST-enabled using

du
ORDS.ENABLE_SCHEMA to allow SQL execution via REST.
am
A database link is not required, and installing APEX on the remote database is unnecessary since
REST-enabled SQL connects APEX to a remote schema via ORDS.
ex

Reference: Oracle APEX 23.2 Documentation - "Using REST-Enabled SQL" under Data Sources.
id
al
.v
w

Question: 7
w
w

Which statement is true about the Data Workshop utility?

//
s:
tp

A. You cannot load data from an XLSX file with multiple worksheets.
ht

B. The wizards load and unload all types of schema objects.

C. The wizards load and unload table data only.

D. You can load or unload multiple tables at a time.

Answer: C

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 8/51

Explanation:

The Data Workshop utility in APEX is designed to load and unload table data only, not other schema
objects like procedures or views. Option A is false because XLSX files with multiple worksheets are
supported (each worksheet can be mapped to a table). Option B is incorrect as it’s limited to table
data. Option D is partially true but not the most precise answer, as "multiple tables at a time"
depends on the process, whereas C is universally accurate.

Reference: Oracle APEX 23.2 Documentation - "Using Data Workshop" under SQL Workshop.

om
.c
ps
Question: 8

m
du
Which two declarative options in Oracle APEX allow you to download BLOB/CLOB content?
am
ex

A. Download Dynamic Action

id

B. APEX_UTIL.DOWNLOAD PL/SQL API

al

C. Download Page Process

.v

D. Share Dynamic Action

w
w
w

Answer: A, C
//
s:
tp

Explanation:
ht

Declarative options for downloading BLOB/CLOB content include:

Download Dynamic Action: A built-in action type to trigger downloads of BLOB/CLOB data.

Download Page Process: A process type that declaratively handles BLOB/CLOB downloads from a
table.

APEX_UTIL.DOWNLOAD is a PL/SQL API, not a declarative option, and Share Dynamic Action is for
sharing URLs, not downloading files.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 9/51

Reference: Oracle APEX 23.2 Documentation - "Downloading Files" under Dynamic Actions and Page
Processes.

Question: 9

An APEX e-commerce application is being used by 50 users. You have a promotional offer, and you
need to send a push notification to all the subscribed users on their devices. Which step must be

om
performed in Oracle APEX to achieve this?

.c
ps
A. Create a Dynamic Action of Send Push Notification type to send push notifications to all the

m
subscribed users.

du
B. Enable push notifications at the application level and let APEX handle the subscription and
am
delivery process automatically.

C. Create a REST Data Source to send push notifications to all the subscribed users.
ex

D. Create a PL/SQL block to fetch all the subscribed users and send push notifications by using
id

APEX_APPL_PUSH_SUBSCRIPTIONS & APEX_PWA.SEND.

al
.v
w

Answer: D
w
w

Explanation:
//
s:
tp

To send push notifications to all subscribed users, you must:

ht

Enable push notifications at the application level (a prerequisite).

Use a PL/SQL block with APEX_APPL_PUSH_SUBSCRIPTIONS to fetch subscribers and

APEX_PWA.SEND to send the notifications.

Option A is incorrect as there’s no "Send Push Notification" Dynamic Action type. Option B is
incomplete as enabling alone doesn’t send notifications. Option C is unrelated to push notifications.

Reference: Oracle APEX 23.2 Documentation - "Sending Push Notifications" under APEX_PWA
Package.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 10/51

Question: 10

What are two reasons to enable the "Used by App Builder" option while creating a Generative AI
Server?

om
A. To create a Working Copy of your application

.c
B. To create a REST-enabled database object

ps
C. To author SQL powered by Generative AI

m
D. To build applications using natural language powered by Generative AI

du
am
Answer: C, D
ex
id

Explanation:
al
.v

Enabling "Used by App Builder" for a Generative AI Server allows:

w
w

Author SQL powered by Generative AI: Integrates AI-driven SQL generation in App Builder.
w

Build applications using natural language: Enables natural language prompts to create app
//

components.
s:
tp

Options A and B are unrelated to this setting, as it’s specific to AI integration in App Builder.
ht

Reference: Oracle APEX 23.2 Documentation - "Configuring Generative AI Server" under AI Features.

Question: 11

Which two are valid evaluation points for Authorization Schemes?

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 11/51

A. Once per user

B. Once per page view

C. Never

D. Once per session

Answer: B, D

om
Explanation:

.c
ps
Authorization Schemes in APEX can be evaluated at:

m
du
Once per page view: Checks authorization each time a page is rendered.

Once per session: Checks once per user session, caching the result.
am
Once per user and Never are not valid evaluation points in the Authorization Scheme settings.
ex

Reference: Oracle APEX 23.2 Documentation - "Managing Authorization Schemes" under Security.
id
al
.v
w

Question: 12
w
// w

How many instances of a Workflow can exist in the "In Development" state?
s:
tp
ht

A. 50

B. 1

C. Unlimited

Answer: B

Explanation:

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 12/51

In Oracle APEX Workflow, only one instance of a workflow can exist in the "In Development" state at
a time. This ensures that developers work on a single draft version before publishing it. Multiple
instances are allowed in other states (e.g., "Published"), but not during development.

Reference: Oracle APEX 23.2 Documentation - "Managing Workflows" under Workflow Features.

om
Question: 13

.c
Which two tasks can be performed by using the Generate Text with AI Dynamic Action?

ps
m
du
A. Draft an email
am
B. Update the underlying database tables

C. Invoke a Workflow
ex

D. Summarize or translate text

id
al
.v

Answer: A, D
w
w
w

Explanation:
//
s:
tp

The "Generate Text with AI" Dynamic Action uses Generative AI to:
ht

Draft an email: Creates text content like emails based on prompts.

Summarize or translate text: Processes existing text to summarize or translate it.

It does not update database tables or invoke workflows, as it’s focused on text generation.

Reference: Oracle APEX 23.2 Documentation - "Using Generate Text with AI" under Dynamic Actions.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 13/51

Question: 14

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?

A. Classic Report

B. Interactive Report

om
C. Column Toggle Report

.c
D. Interactive Grid

ps
m
Answer: B

du
am
Explanation:
ex
id

When creating a faceted search page via the Create Page Wizard, the default report type is an
Interactive Report. This pairs with the faceted search region to provide a searchable, filterable, and
al

customizable report, leveraging the facets for dynamic filtering.

.v
w

Reference: Oracle APEX 23.2 Documentation - "Creating a Faceted Search Page" under Create Page
Wizard.
w
// w
s:
tp

Question: 15
ht

In your application, you want to display data in a searchable, customizable report that supports inline
editing at runtime using the mouse or keyboard. Which report type will you create?

A. Smart Filters

B. Interactive Report

C. Interactive Grid

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 14/51

D. Classic Report

Answer: C

Explanation:

An Interactive Grid is the report type that supports searchable, customizable data display with inline

om
editing at runtime using mouse or keyboard. Interactive Reports are searchable and customizable but
lack inline editing. Classic Reports are static, and Smart Filters is a component, not a report type.

.c
Reference: Oracle APEX 23.2 Documentation - "Managing Interactive Grids" under Reports.

ps
m
du
Question: 16
am
Which two tasks can be performed by the APEX Assistant when you create an application using the
ex

"Create App using Generative AI" option?

id
al

A. Create a Generative AI service.

.v
w

B. Create the application blueprint.

w

C. Add a Dashboard page.

w

D. Update the App icon with a custom image.

//
s:
tp

Answer: B, C
ht

Explanation:

The "Create App using Generative AI" feature in APEX Assistant leverages natural language
processing to automate application creation. When invoked:

Create the application blueprint: APEX Assistant generates a foundational structure (blueprint) for
the application, including pages, regions, and navigation, based on the user's natural language input

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 15/51

(e.g., "Create an app to manage employees"). This blueprint serves as the starting point, which
developers can refine.

Add a Dashboard page: The Assistant can interpret requests for specific page types, such as
dashboards, and include them in the generated app. Dashboards typically feature charts, summaries,
or key metrics, and this is a common task supported by the AI-driven creation process.

Create a Generative AI service: This is not a task performed during app creation; instead, it’s a
prerequisite configuration step done separately in the Instance Administration settings.

Update the App icon: While app icons can be customized manually post-creation, this is not an

om
automated task performed by APEX Assistant during the generative process.

This feature streamlines development by interpreting intent and building functional components,

.c
saving significant time compared to manual creation.

ps
Reference: Oracle APEX 23.2 Documentation - "Creating Applications with Generative AI" under

m
APEX Assistant.

du
am
ex

Question: 17
id
al

You need to ensure that "How may I help you today?" is the first message displayed by the AI
.v

assistant. Which attribute of the Show AI Assistant Dynamic Action should be configured in the
Property Editor to achieve this?
w
w
w

A. Welcome Message
//
s:

B. Initial Prompt
tp

C. AI Assistant Name
ht

Answer: A

Explanation:

The Show AI Assistant Dynamic Action in Oracle APEX triggers the display of the AI Assistant

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 16/51

interface. To customize the first message users see:

Welcome Message: This attribute in the Property Editor defines the initial text displayed when the AI
Assistant appears. Setting it to "How may I help you today?" ensures this exact phrase greets users,
enhancing user experience by setting a friendly tone. It’s a static, developer-defined string, distinct
from AI-generated responses.

Initial Prompt: This attribute defines the starting input or context sent to the AI model, not the visible
message shown to users. It’s typically hidden and used to guide the AI’s behavior (e.g., "Act as a
support agent").

om
AI Assistant Name: This sets the assistant’s identity (e.g., "Alex"), displayed in the UI, but it’s not the
greeting message.

.c
This configuration is critical for branding or guiding user interaction from the outset, and it’s

ps
adjustable per dynamic action instance, offering flexibility across pages.

m
Reference: Oracle APEX 23.2 Documentation - "Show AI Assistant Dynamic Action" under Dynamic

du
Actions.
am
ex

Question: 18
id
al
.v

Which two AI Service Providers are supported by Oracle APEX?

w
w
w

A. DOC Document Generator pre-built function

//

B. OpenAI
s:
tp

C. Jarvis
ht

D. OCI Generative AI

Answer: B, D

Explanation:

Oracle APEX integrates with external AI service providers to power features like Generative AI and

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 17/51

text generation. The supported providers are:

OpenAI: A widely recognized AI provider offering models like GPT, integrated via API keys for tasks
such as text generation, summarization, or SQL authoring in APEX.

OCI Generative AI: Oracle Cloud Infrastructure’s native AI service, optimized for Oracle ecosystems,
providing secure, scalable AI capabilities directly within the OCI environment.

DOC Document Generator: This is not an AI service provider; it’s a hypothetical or misnamed option
unrelated to APEX’s AI integration.

Jarvis: While a fictional AI (e.g., from Iron Man), it’s not a real provider supported by APEX.

om
These integrations require configuration in the Instance Administration settings, including credentials

.c
and endpoints, enabling APEX to leverage cutting-edge AI for app development and runtime

ps
features.

m
Reference: Oracle APEX 23.2 Documentation - "Configuring AI Service Providers" under Instance
Administration.

du
am
ex

Question: 19
id
al

Which two Query Source types can be used to create a dynamic LOV?
.v
w
w

A. Procedure
// w

B. Function Returning SQL Query

s:

C. Select List
tp

D. SQL Query
ht

Answer: B, D

Explanation:

A dynamic List of Values (LOV) in APEX populates options based on a query source. The supported

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 18/51

types include:

Function Returning SQL Query: A PL/SQL function that returns a SQL query string (e.g., RETURN
'SELECT ename, empno FROM emp';). This offers flexibility for dynamic conditions or complex logic.

SQL Query: A direct SQL statement (e.g., SELECT ename, empno FROM emp) executed at runtime to
fetch LOV values. It’s the simplest and most common approach.

Procedure: Procedures execute logic but don’t return query results in the format required for an LOV
(they don’t produce a result set directly).

Select List: This is a UI component, not a query source type for defining an LOV.

om
Dynamic LOVs enhance user interaction by providing real-time, data-driven options, critical for forms

.c
and filters.

ps
Reference: Oracle APEX 23.2 Documentation - "Managing Lists of Values" under Shared Components.

m
du
am
Question: 20
ex
id

Which client credentials are used for authentication during the 'Check Syntax' process?
al
.v

A. Database schema credentials

w
w

B. APEX Workspace Admin credentials

w

C. APEX Developer credentials

//
s:
tp

Answer: A
ht

Explanation:

The "Check Syntax" process in APEX, typically used in SQL Workshop or when validating code,
authenticates using Database schema credentials. These are the credentials of the schema
associated with the APEX workspace (e.g., username/password of the schema like "HR"). This
ensures the process has access to parse and validate SQL or PL/SQL against the database objects in
that schema.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 19/51

APEX Workspace Admin credentials: These are for managing workspaces, not executing database-
level syntax checks.

APEX Developer credentials: These authenticate developers into the APEX IDE, not the database
runtime environment.

This design aligns with APEX’s security model, where database operations are tied to the schema,
ensuring accurate validation and error reporting (e.g., missing privileges or invalid objects).

Reference: Oracle APEX 23.2 Documentation - "SQL Workshop Guide" under SQL Commands.

om
.c
Question: 21

ps
m
Which step is mandatory to make an existing Oracle APEX application Progressive Web App (PWA)

du
enabled?
am
ex

A. Enable the PWA flag in the Application Definition.

id

B. Verify that Friendly URLs are turned on in the Application Definition.

al

C. Add custom JavaScript to support offline functionality.

.v

D. Enable RESTful Web Services in the application.

w
w
w

Answer: A
//
s:
tp

Explanation:
ht

To enable an existing APEX application as a Progressive Web App (PWA), the mandatory step is:

Enable the PWA flag in the Application Definition: In the Application Definition attributes under
"Progressive Web App," setting "Enable PWA" to "Yes" activates PWA features like installability, push
notifications, and service worker generation. This is the foundational step, after which optional
customizations (e.g., icons, manifest) can be added.

Friendly URLs: While recommended for modern apps, they’re not required for PWA functionality.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 20/51

Custom JavaScript: Optional for offline capabilities, but not mandatory for basic PWA enablement.

RESTful Web Services: Unrelated to PWA features.

This step transforms the app into a PWA, enhancing user experience on mobile and desktop devices
with native-like behavior.

Reference: Oracle APEX 23.2 Documentation - "Enabling Progressive Web Apps" under Application
Definition.

om
Question: 22

.c
ps
You have an Interactive Grid component and you are enabling the Save Report functionality. As what

m
can end users save the report type?

du
am
A. As Private and Primary only
ex

B. As Private and Public only

id

C. As Primary
al
.v
w

Answer: B
w
w

Explanation:
//
s:
tp

In an Interactive Grid, the "Save Report" functionality allows end users to save customizations (e.g.,
ht

filters, column order). The available options are:

Private: Saved for the individual user only, visible only to them.

Public: Saved and shared with all users of the application, if permitted by the developer.

Primary: This is a developer-defined default report, not an end-user save option. End users cannot
overwrite the Primary report; they can only save as Private or Public (if enabled via the "Allow Public
Reports" attribute).

This flexibility empowers users to personalize grids while allowing shared configurations, enhancing

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 21/51

collaboration and usability.

Reference: Oracle APEX 23.2 Documentation - "Managing Interactive Grids" under Save Report
Settings.

Question: 23

om
Which search type in keywords do they represent in Oracle Text?

.c
ps
A. Standard

m
B. List

du
C. Oracle Text
am
ex

Answer: C
id
al

Explanation:
.v
w
w

In Oracle APEX, when configuring search functionality (e.g., in reports or faceted search), "Oracle
w

Text" refers to a specific search type leveraging the Oracle Text engine. This is a powerful full-text
search capability built into Oracle Database, supporting keyword-based searches, fuzzy matching,
//
s:

and indexing.
tp

Standard: A basic SQL-based search (e.g., LIKE), not tied to Oracle Text.
ht

List: Not a search type; it might refer to a UI component or LOV, not a search mechanism.

Oracle Text: Explicitly uses the CONTAINS operator and text indexes (e.g., CONTEXT or CTXCAT) for
advanced search features, ideal for large datasets or complex queries.

This choice impacts performance and accuracy, especially in text-heavy applications.

Reference: Oracle APEX 23.2 Documentation - "Using Oracle Text in APEX" under Search
Configuration.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 22/51

Question: 24

Which two statements are true about faceted search pages?

A. Faceted Search supports the ability to filter columns storing multiple values.

B. Multiple charts are not visible in the same region.

om
C. A facet’s chart can be seen only in a nonmodal dialog.

.c
D. Facets map to specific database columns.

ps
m
du
am Answer: A, D

Explanation:
ex
id

Faceted search pages in APEX provide dynamic filtering. The true statements are:
al

Faceted Search supports the ability to filter columns storing multiple values: Facets can handle multi-
.v

value columns (e.g., comma-separated lists or JSON arrays) using appropriate SQL (e.g., INSTR or
w

JSON_TABLE), enabling complex filtering scenarios like tags or categories.

w
w

Facets map to specific database columns: Each facet is tied to a column in the underlying query (e.g.,
DEPTNO or JOB), ensuring data-driven filtering.
//
s:

Multiple charts are not visible in the same region: False; multiple facets can display charts within the
tp

same region, depending on settings.

ht

A facet’s chart can be seen only in a nonmodal dialog: False; charts can appear inline or in dialogs,
configurable via facet attributes.

This functionality makes faceted search ideal for exploratory data analysis.

Reference: Oracle APEX 23.2 Documentation - "Managing Faceted Search" under Regions.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 23/51

Question: 25

The Movies faceted search report is filtered only when the Apply button for a selected facet is
clicked. What must be done in the Page Designer so that report filtering is automatically executed
when any facet value is selected?

A. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute.

B. Navigate to the faceted search region Attributes, and turn off the Show Facet Name attribute.

om
C. Navigate to each facet and then in the Property Editor, turn on Client-Side Filtering.

.c
ps
m
Answer: A

Explanation:
du
am
ex

By default, faceted search can "batch" changes, requiring an "Apply" button click to filter the report.
id

To enable automatic filtering:

al

Disable the Batch Facet Changes attribute: In Page Designer, under the Faceted Search region’s
.v

Attributes, setting "Batch Facet Changes" to "No" ensures the report refreshes immediately when a
w

facet value is selected, improving responsiveness. This triggers an AJAX call to update the report
w

without a manual submit.

w

Show Facet Name: This controls facet label visibility, unrelated to filtering behavior.
//
s:

Client-Side Filtering: This applies to Interactive Reports/Grids, not faceted search regions, and isn’t
tp

the correct solution here.

ht

This adjustment enhances the user experience by providing instant feedback.

Reference: Oracle APEX 23.2 Documentation - "Faceted Search Attributes" under Region Properties.

Question: 26

Which two actions does the Create Application Wizard allow?

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 24/51

A. Uploading JavaScript or CSS files required for an application.

B. Adding or deleting application pages.

C. Changing the application authorization.

D. Reordering application pages.

om
Answer: B, D

.c
Explanation:

ps
m
du
The Create Application Wizard streamlines app creation with:

Adding or deleting application pages: Allows users to define initial pages (e.g., Home, Reports) and
am
remove unwanted ones during the wizard process.
ex

Reordering application pages: Provides drag-and-drop or list-based reordering of pages to set the
navigation sequence.
id
al

Uploading JavaScript or CSS: This occurs post-creation in Shared Components, not within the wizard.
.v

Changing the application authorization: Authorization schemes are set after creation, not during the
w

wizard.
w

This wizard is a time-saver for rapid prototyping, offering a guided yet flexible setup.
// w

Reference: Oracle APEX 23.2 Documentation - "Create Application Wizard" under App Creation.
s:
tp
ht

Question: 27

Which statement is true about the Link Column attributes of an Interactive Report?

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

B. It is not possible to exclude Link Column.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 25/51

C. If you select Link Column, it is always displayed as the last column in the report.

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

Answer: B

Explanation:

om
The Link Column in an Interactive Report adds a clickable link to each row. The true statement is:

.c
It is not possible to exclude Link Column: Once defined in the report attributes, the Link Column is

ps
mandatory and cannot be hidden or excluded via end-user controls (e.g., Column Management). It’s
always rendered unless removed by the developer.

m
du
Custom target: False; custom targets (e.g., URLs, pages) can be defined.
am
Always last column: False; its position is configurable.

Cannot be sorted/hidden/moved: False; end users can sort or move it, though hiding is restricted.
ex

This behavior ensures consistent navigation in reports.

id
al

Reference: Oracle APEX 23.2 Documentation - "Interactive Report Link Column" under Report
.v

Attributes.
w
w
// w

Question: 28
s:
tp

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

A. After you create a dynamic action, you cannot add more true actions.

B. If a client-side condition is defined, the true action will fire when the condition is met.

C. You can execute JavaScript code by creating a dynamic action.

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

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 26/51

Answer: B, C

Explanation:

Dynamic Actions in APEX enable responsive behavior:

If a client-side condition is defined, the true action will fire when the condition is met: A condition
(e.g., this.browserEvent === 'click') ensures the true action (e.g., Show, Hide) executes only when
true, enhancing precision in event handling.

om
You can execute JavaScript code by creating a dynamic action: The "Execute JavaScript Code" action

.c
type allows custom scripts (e.g., alert('Clicked!');), extending functionality beyond declarative

ps
options.

m
Cannot add more true actions: False; multiple true actions can be added post-creation.

du
No condition, true actions won’t fire: False; without a condition, true actions fire unconditionally on
am
the event.

Dynamic Actions are a cornerstone of interactive UIs in APEX.

ex

Reference: Oracle APEX 23.2 Documentation - "Managing Dynamic Actions" under Page Designer.
id
al
.v
w

Question: 29
w
// w

Which is NOT an available Geometry Column data type for the map region?
s:
tp
ht

A. GeoJSON

B. SDO_GEOMETRY

C. JSON OBJECT

D. Latitude/Longitude

Answer: C

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 27/51

Explanation:

The Map Region in APEX supports spatial data via:

GeoJSON: A JSON-based standard for geographic data (e.g., points, polygons).

SDO_GEOMETRY: Oracle’s native spatial data type for storing geometry (e.g., SDO_GEOMETRY(2001,
4326, SDO_POINT_TYPE(-122, 37, NULL), NULL, NULL)).

Latitude/Longitude: Separate columns for lat/long coordinates, mapped to points.

om
JSON OBJECT: Not a supported geometry type; while JSON can store data, it’s not a specific spatial
format recognized by the Map Region without GeoJSON structure.

.c
ps
This ensures compatibility with Oracle Spatial and common GIS standards.

m
Reference: Oracle APEX 23.2 Documentation - "Managing Map Regions" under Regions.

du
am
ex

Question: 30
id
al

Which two statements are true about Oracle APEX?

.v
w
w

A. APEX eliminates middle tier application logic.

w

B. Running an APEX app needs client software.

//
s:

C. You can build interactive reporting apps based on data from disparate systems.
tp

D. Application definition is not stored in the database.

ht

Answer: A, C

Explanation:

Key truths about Oracle APEX:

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 28/51

APEX eliminates middle tier application logic: APEX runs entirely within the Oracle Database, using
PL/SQL and SQL for logic, bypassing traditional middle-tier servers (e.g., Java EE). This simplifies
architecture and boosts performance.

You can build interactive reporting apps based on data from disparate systems: Via REST Data
Sources, database links, or ORDS, APEX integrates data from external systems, enabling unified
reporting (e.g., combining on-premises and cloud data).

Needs client software: False; APEX is web-based, requiring only a browser.

Application definition not stored in database: False; definitions are stored as metadata in the

om
database (e.g., APEX_APPLICATIONS).

This reflects APEX’s database-centric, low-code philosophy.

.c
ps
Reference: Oracle APEX 23.2 Documentation - "About Oracle APEX" under Introduction.

m
du
am
ex

Question: 31
id
al

An application includes a form on the EMPLOYEES table. You must limit the P1_MANAGER page item
so users can select a single employee name and ID from the corresponding manager ID in the same
.v

table. Which item type can be used to display P1_MANAGER?

w
w
w

A. Popup LOV
//
s:

B. Switch
tp

C. Checkbox
ht

Answer: A

Explanation:

The requirement is to allow users to pick a single employee (name and ID) from a list tied to the
MANAGER_ID column in the EMPLOYEES table, implying a dynamic, searchable selection:

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 29/51

A . Popup LOV: This item type displays a popup window with a searchable list of values, sourced from
a SQL query (e.g., SELECT ename, empno FROM employees WHERE empno IN (SELECT DISTINCT
manager_id FROM employees)). It returns a single value (e.g., EMPNO) while displaying the name,
perfectly meeting the need for a single selection from a related dataset.

B . Switch: A toggle (Yes/No), unsuitable for selecting from a list of employees.

C . Checkbox: Allows multiple selections, conflicting with the "single employee" requirement.

Practical note: Popup LOVs enhance usability with filtering and pagination, ideal for large employee
lists, and support returning the ID while showing the name.

om
Reference: Oracle APEX 23.2 Documentation - "Managing Page Items" under Item Types.

.c
ps
m
Question: 32

du
am
You must create a single master detail page where users can select a row in the master region and
see the corresponding details in the detail region. Users must also interact with the master or the
ex

detail without leaving the page. Which type of master detail implementation should you use?
id
al

A. Drill Down
.v
w

B. Stacked
w

C. Side by Side
// w
s:

Answer: C
tp
ht

Explanation:

Master-detail pages in APEX link a master dataset (e.g., list of orders) to its details (e.g., order items).
The requirements demand:

C . Side by Side: This layout places the master region (e.g., an Interactive Report) and detail region
(e.g., a Form or Grid) horizontally on the same page. Selecting a master row updates the detail region
via AJAX, allowing interaction with both regions without navigation. It’s ideal for workflows needing

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 30/51

simultaneous visibility (e.g., editing details while browsing masters).

A . Drill Down: Master links to a separate detail page, requiring navigation, which violates the
"without leaving the page" condition.

B . Stacked: Master and detail are vertically stacked, but interaction is less fluid than side-by-side due
to scrolling, though still on one page. Side-by-side is preferred for its clarity and accessibility.

Pitfall: Ensure the detail region’s "Server-side Condition" uses the master’s selected key (e.g., P1_ID).

Reference: Oracle APEX 23.2 Documentation - "Creating Master Detail Pages" under Create Page
Wizard.

om
.c
ps
Question: 33

m
du
Which two statements are true about creating and managing an APEX Workspace?
am
ex

A. During workspace creation, you can associate the workspace with an existing database schema.
id

B. New schemas cannot be created during workspace creation.

al
.v

C. A workspace can be associated with only one schema.

w

D. You can create only two workspaces in an APEX Service (APEX Application Development) instance.
w
// w

Answer: A, B
s:
tp

Explanation:
ht

APEX Workspaces define development environments tied to database schemas:

A . During workspace creation, you can associate the workspace with an existing database schema: In
the Workspace creation wizard (via Instance Administration), you select an existing schema (e.g.,
"HR") to link, enabling access to its objects. This is a standard step, ensuring immediate usability.

B . New schemas cannot be created during workspace creation: APEX doesn’t provide a UI to create
schemas here; schemas must pre-exist in the database, created via SQL (e.g., CREATE USER).

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 31/51

C . A workspace can be associated with only one schema: False; a workspace can associate with
multiple schemas post-creation via "Manage Workspace to Schema Assignments."

D . You can create only two workspaces: False; the limit depends on the APEX instance configuration
(e.g., cloud service tier), not a fixed number like two.

Use case: Associating existing schemas is key for leveraging pre-built databases.

Reference: Oracle APEX 23.2 Documentation - "Managing Workspaces" under Instance

Administration.

om
.c
Question: 34

ps
m
Which two actions are performed by using the Object Browser?

du
am
A. Restore dropped database objects.
ex

B. Browse database objects of the current schema.

id

C. Create and run SQL scripts.

al
.v

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

w
w

Answer: B, D
// w
s:

Explanation:
tp
ht

Object Browser in SQL Workshop is a GUI for managing schema objects:

B . Browse database objects of the current schema: Displays tables, views, procedures, etc., in a tree
view, allowing inspection of definitions (e.g., columns, constraints) and data previews.

D . Create a lookup table based on a column in the current table: From a table’s column (e.g.,
DEPTNO), you can generate a lookup table (e.g., DEPT_LOOKUP) with unique values, automating
reference table creation.

A . Restore dropped objects: Not supported; this requires DBA tools (e.g., FLASHBACK TABLE).

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 32/51

C . Create and run SQL scripts: This is a SQL Scripts feature, not Object Browser.

Practical tip: Use "Create Lookup Table" to normalize data efficiently.

Reference: Oracle APEX 23.2 Documentation - "Using Object Browser" under SQL Workshop.

Question: 35

om
Which two statements are true about the APEX_MAIL API?

.c
ps
A. You can add files as attachments to your emails using the APEX_MAIL package.

m
du
B. You can receive emails using the APEX_MAIL package in an Oracle APEX application.

C. You can send emails using the APEX_MAIL package from an Oracle APEX application.
am
D. The APEX_MAIL package supports sending emails only to Oracle database users.
ex
id
al

Answer: A, C
.v
w

Explanation:
w
// w

The APEX_MAIL API facilitates email functionality:

s:

A . You can add files as attachments: Using APEX_MAIL.ADD_ATTACHMENT (e.g.,

tp

APEX_MAIL.ADD_ATTACHMENT(p_mail_id, p_attachment, p_filename)), you can attach BLOBs (e.g.,

ht

PDFs) to emails.

C . You can send emails: APEX_MAIL.SEND (e.g., APEX_MAIL.SEND(p_to => 'user@example.com',

p_body => 'Hello')) sends emails from APEX, leveraging the configured mail server.

B . You can receive emails: False; APEX_MAIL is send-only; receiving requires custom integration
(e.g., IMAP).

D . Only to Oracle database users: False; emails can go to any valid address, not just database users.

Pitfall: Ensure the mail queue is processed (APEX_MAIL.PUSH_QUEUE) for timely delivery.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 33/51

Reference: Oracle APEX 23.2 Documentation - "APEX_MAIL Package" under API Reference.

Question: 36

You have defined a REST Data Source with ORDS as the REST Data Source Type. The Source is being
used as source for an editable Interactive Grid. When a user updates an employee record in this
Interactive Grid, which operation is performed on the Database?

om
.c
ps
A. POST

m
B. GET

C. PUT
du
am
ex

Answer: C
id
al

Explanation:
.v
w
w

An editable Interactive Grid synced with a REST Data Source (ORDS) maps CRUD operations to HTTP
w

methods:
//
s:

C . PUT: Updates an existing resource. When a user edits a row (e.g., changes SALARY), the grid sends
a PUT request to the ORDS endpoint (e.g., /employees/101), updating the corresponding record.
tp
ht

A . POST: Creates new records, used for inserts, not updates.

B . GET: Retrieves data, used for initial grid population, not updates.

Technical note: ORDS maps PUT to an update operation on the underlying table, requiring the REST
endpoint to support this method.

Reference: Oracle APEX 23.2 Documentation - "Using REST Data Sources" under Data Sources.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 34/51

Question: 37

Which Process type do you use to run multiple processes in the background in APEX?

A. Execute Code

B. Execute Server-side Code

C. Execute JavaScript Code

om
D. Execution Chain

.c
ps
Answer: D

m
Explanation:
du
am
ex

To run multiple processes in the background:

id

D . Execution Chain: This process type allows chaining multiple processes (e.g., PL/SQL, REST calls) to
al

execute sequentially or conditionally in the background, managed via the Process Chain framework.
.v

It’s ideal for complex, asynchronous tasks (e.g., batch updates).

w

A . Execute Code: Not a process type in APEX; likely a misnomer.

w
w

B . Execute Server-side Code: Runs a single PL/SQL block synchronously, not multiple background
tasks.
//
s:

C . Execute JavaScript Code: Client-side, not suited for background server processes.
tp

Use case: Chain processes like data validation, logging, and email sending without blocking the UI.
ht

Reference: Oracle APEX 23.2 Documentation - "Managing Execution Chains" under Processes.

Question: 38

Which two layout modes are available for Page Designer under Utilities?

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 35/51

A. Two Pane

B. Three Pane

C. Four Pane

D. Single Pane

om
Answer: A, B

.c
Explanation:

ps
m
du
Page Designer’s layout modes under Utilities adjust the workspace:

A . Two Pane: Splits into two vertical sections (e.g., tree and properties), ideal for focused editing.
am
B . Three Pane: Adds a third section (e.g., tree, grid, properties), offering a balanced view for complex
ex

pages.
id

C . Four Pane: Not available; APEX limits to three for usability.

al

D . Single Pane: Not an option; the minimum is two panes.

.v
w

Developers toggle these via the Utilities menu to optimize screen real estate based on task
w

complexity.
w

Reference: Oracle APEX 23.2 Documentation - "Page Designer Layout" under Utilities.
//
s:
tp
ht

Question: 39

Which three data types are supported by Oracle APEX Workflow parameters and item types?

A. Image

B. NUMBER

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 36/51

C. CLOB

D. VARCHAR

Answer: B, C, D

Explanation:

om
Workflow parameters and page items in APEX support:

.c
B . NUMBER: For numeric values (e.g., 123.45), used in calculations or IDs.

ps
C . CLOB: For large text (e.g., descriptions), stored as character large objects.

m
du
D . VARCHAR: For variable-length strings (e.g., EMPLOYEE_NAME), capped at 4000 characters in most
cases.
am
A . Image: Not a supported data type for parameters or items; images are handled as BLOBs or file
uploads, not directly as a Workflow parameter type.
ex

These types align with Oracle Database, ensuring robust data handling in workflows.
id
al

Reference: Oracle APEX 23.2 Documentation - "Workflow Parameters" under Workflow Features.
.v
w
w
w

Question: 40
//
s:
tp

Which statement is true about Theme Styles in Oracle APEX?

ht

A. Theme Styles control the layout of a webpage.

B. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime
environment.

C. The "Is Current" attribute of a Theme Style depends on the "Read Only" attribute.

Answer: B

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 37/51

Explanation:

Theme Styles define visual aspects (e.g., colors, fonts) in APEX:

B . When the Is Public attribute is enabled: Setting "Is Public" to "Yes" allows end users to select from
available Theme Styles at runtime (e.g., via a UI switcher), enhancing customization.

A . Control the layout: False; layout is managed by templates and regions, not Theme Styles, which

om
focus on aesthetics.

C . "Is Current" depends on "Read Only": False; "Is Current" marks the active style, independent of

.c
"Read Only" (which locks editing).

ps
Practical note: Public styles require multiple defined styles in Shared Components.

m
du
Reference: Oracle APEX 23.2 Documentation - "Managing Theme Styles" under Themes.
am
ex

Question: 41
id
al
.v

You must use a Static Content region type to display messages about the employee of the month.
Which text, when placed in this region, will display the message correctly?
w
w
w

A. Join me in congratulating: P1_ENAME as the new employee of the month!

//
s:

B. Join me in congratulating: &P1_ENAME. as the new employee of the month!

tp

C. Join me in congratulating V('P1_ENAME') as the new employee of the month!

ht

D. Join me in congratulating & P1_ENAME. as the new employee of the month!

Answer: B

Explanation:

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 38/51

Static Content regions display fixed text with substitution:

B . &P1_ENAME.: The &ITEM_NAME. syntax substitutes the value of P1_ENAME at runtime (e.g.,
"Join me in congratulating: John as..."), correctly rendering the item’s value. The dot ensures proper
parsing.

A . P1_ENAME: Treated as literal text, not substituted.

C . V('P1_ENAME'): A PL/SQL function, invalid in static content; it’s for server-side code.

D . & P1_ENAME.: Space before P1_ENAME breaks substitution syntax.

om
Pitfall: Ensure P1_ENAME is populated (e.g., via a page process) to avoid blank output.

Reference: Oracle APEX 23.2 Documentation - "Using Substitution Strings" under Regions.

.c
ps
m
Question: 42
du
am
You created a custom theme for an application. Examine these requirements: (Assuming
ex

requirements mandate syncing changes). Which solution guarantees that any changes to the master
id

theme are reflected in the copied theme?

al
.v

A. Subscribing the copied theme to the master theme and refreshing the theme.
w
w

B. Refreshing the templates.

w

C. Copying the changes made in the master theme to the copied theme.
//
s:

D. Verifying the theme subscription.

tp
ht

Answer: A

Explanation:

Theme subscription links a copied theme to its master:

A . Subscribing and refreshing: Subscribing the copied theme (in Shared Components > Themes) to

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 39/51

the master ensures it inherits updates. "Refresh Theme" (via Theme Roller or Utilities) syncs changes
(e.g., CSS, templates) from the master, guaranteeing consistency.

B . Refreshing templates: Only updates individual templates, not the entire theme.

C . Copying changes: Manual, error-prone, and not guaranteed.

D . Verifying subscription: Confirms the link but doesn’t sync changes.

Use case: Ideal for maintaining branded consistency across apps.

Reference: Oracle APEX 23.2 Documentation - "Subscribing Themes" under Themes.

om
.c
ps
Question: 43

m
du
What do you achieve by performing the "Refresh Working Copy" task?
am
ex

A. Merge the Working Copy changes with the Main application.

id

B. Update the changes from one Working Copy to another.

al

C. Get the latest updates from the Main application.

.v
w
w

Answer: C
// w
s:

Explanation:
tp
ht

Working Copies in APEX allow safe experimentation:

C . Get the latest updates from the Main application: "Refresh Working Copy" (in App Builder >
Working Copies) pulls changes from the Main application into the Working Copy, ensuring it reflects
the latest state (e.g., new pages, fixes) without overwriting Working Copy changes.

A . Merge with Main: Merging is a separate "Merge Working Copy" task.

B . Update between Working Copies: Not supported; refreshing is Main-to-Working only.

Practical note: Use this to sync collaborative development efforts.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 40/51

Reference: Oracle APEX 23.2 Documentation - "Managing Working Copies" under App Builder.

Question: 44

There is a validation of type Item is Numeric on the P1_SALARY item. When the page is submitted,
this error message is displayed both as a notification and inline with the item. What will cause the
validation error to appear only in the Notification area?

om
.c
ps
A. Removing P1_SALARY from the validation Associated Item.

m
B. Setting Value Required to Yes on P1_SALARY.

C. Setting Display Location to Inline in Notification

du
am
ex

Answer: C
id
al

Explanation:
.v
w
w

Validation errors in APEX default to both inline (next to the item) and notification (top of page):
w

C . Setting Display Location to Inline in Notification: In the validation’s properties, changing "Display
//
s:

Location" to "Inline in Notification" ensures the error appears only in the notification area,
suppressing inline display. This centralizes feedback for a cleaner UI.
tp
ht

A . Removing Associated Item: Breaks the validation’s link to P1_SALARY, stopping it entirely.

B . Value Required: Adds a separate check, unrelated to display location.

Pitfall: Test with non-numeric input (e.g., "abc") to confirm behavior.

Reference: Oracle APEX 23.2 Documentation - "Managing Validations" under Page Processing.

Question: 45

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 41/51

Which component of the Push Notifications feature stores the messages that are ready to be sent?

A. Queue

B. Application

C. Subscription

om
Answer: A

.c
Explanation:

ps
m
du
Push Notifications in Oracle APEX enable real-time messaging to users’ devices via Progressive Web
App (PWA) capabilities. The component responsible for storing messages is:
am
A . Queue: The Push Notification Queue (managed internally by APEX and accessible via APIs like
APEX_PWA.PUSH_QUEUE) temporarily holds messages scheduled for delivery. When a notification is
ex

created (e.g., via APEX_PWA.SEND), it’s added to this queue, awaiting processing by the APEX mail
id

system or an external push service. The queue ensures reliable delivery, even if the user is offline
al

temporarily, as messages are dispatched once connectivity is restored.

.v

B . Application: The application defines the PWA settings and logic but doesn’t store messages; it’s
w

the container, not the storage mechanism.

w

C . Subscription: Represents user device registrations (stored in APEX_APPL_PUSH_SUBSCRIPTIONS),

w

not the messages themselves. Subscriptions link devices to the app for delivery, not queuing.
//
s:

Technical Insight: The queue is a database-backed structure, leveraging Oracle’s job scheduling (e.g.,
tp

DBMS_SCHEDULER) to process entries. For example, calling APEX_PWA.SEND(p_message => 'Promo

Alert!') adds an entry to the queue, which is then pushed to subscribed devices.
ht

Use Case: A retail app queues a "Sale starts now!" message for 1,000 users, ensuring orderly delivery
without overwhelming the server.

Pitfall: If the queue isn’t periodically pushed (e.g., via APEX_PWA.PUSH_QUEUE), messages may
delay.

Reference: Oracle APEX 23.2 Documentation - "Managing Push Notifications" under APEX_PWA
Package.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 42/51

Question: 46

Which three statements are true about Data Workshops in Oracle APEX?

A. You can load or unload multiple tables at a time.

B. You can load or unload a single table at a time.

om
C. You can unload data from a new or existing table.

.c
D. You can load data into a new or existing table.

ps
m
du
am Answer: B, C, D

Explanation:
ex
id

Data Workshop in SQL Workshop is a powerful tool for importing/exporting table data:
al

B . You can load or unload a single table at a time: The wizard focuses on one table per operation. For
.v

loading, you upload a file (e.g., CSV) and map it to a single table; for unloading, you select one table
w

to export (e.g., EMP to CSV). This granularity ensures precision and simplicity.
w
w

C . You can unload data from a new or existing table: Unloading (exporting) works on any table in the
schema, whether newly created (e.g., via Quick SQL) or pre-existing (e.g., DEPT). The "Unload"
//
s:

option generates a file (e.g., CSV, JSON) from the table’s data.
tp

D . You can load data into a new or existing table: Loading supports creating a new table from the
ht

uploaded file (e.g., CSV defines NEW_EMP) or appending/overwriting an existing one (e.g., EMP).
The wizard prompts for table creation or selection.

A . You can load or unload multiple tables at a time: False; Data Workshop processes one table per
wizard run. Multiple tables require separate operations or custom SQL scripts.

Technical Insight: Loading uses APEX_DATA_LOADING internally, parsing files into rows, while
unloading leverages APEX_DATA_EXPORT. For example, uploading emp.csv with "Create New Table"
generates a table with inferred columns.

Use Case: Migrating EMP data from a legacy system (CSV) into APEX, then exporting it later for

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 43/51

analysis.

Pitfall: Multi-table operations need SQL Scripts or external tools like SQL Developer.

Reference: Oracle APEX 23.2 Documentation - "Using Data Workshop" under SQL Workshop.

Question: 47

om
Which two Plugin types can be created in Oracle APEX?

.c
ps
A. Validation

m
du
B. Email Template

C. Process
am
D. Region
ex
id
al

Answer: C, D
.v
w

Explanation:
w
// w

Plugins extend APEX’s functionality beyond built-in components:

s:

C . Process: A Process plugin executes custom server-side logic (e.g., PL/SQL) during page processing
tp

or AJAX calls. Example: A plugin to sync data with an external API after form submission. It’s defined
ht

with execution points and parameters.

D . Region: A Region plugin creates custom UI areas (e.g., a dynamic chart or carousel). Example: A
plugin rendering a custom dashboard. It supports attributes, templates, and refresh events.

A . Validation: While validations are customizable, they’re not a plugin type; they’re declarative or
PL/SQL-based within APEX.

B . Email Template: Email formatting is handled via APEX_MAIL or templates in Shared Components,
not as plugins.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 44/51

Technical Insight: Plugins are created in Shared Components > Plug-ins, requiring PL/SQL for logic,
JavaScript/CSS for UI, and a render function. For instance, a Region plugin might use
apex_plugin.t_region to define its output.

Use Case: A Process plugin to log audit trails or a Region plugin for a unique data visualization.

Pitfall: Developing plugins requires advanced skills; test thoroughly to avoid runtime errors.

Reference: Oracle APEX 23.2 Documentation - "Creating Plug-ins" under Shared Components.

om
Question: 48

.c
ps
Which statement is true about importing an existing application into your workspace?

m
du
am
A. You cannot change the application ID during the import process.

B. The import process does not import the supporting objects defined during the export.
ex

C. You cannot import an APEX application exported from the latest APEX version to an old APEX
id

version.
al
.v
w

Answer: C
w
w

Explanation:
//
s:
tp

Importing an APEX application involves transferring its definition (exported as a .sql file):
ht

C . You cannot import an APEX application exported from the latest APEX version to an old APEX
version: APEX enforces backward compatibility limits. An app exported from 23.2 (latest features like
AI Assistants) can’t import into 19.2, as older versions lack support for newer metadata (e.g.,
APEX_AI tables). The import wizard checks the version and rejects incompatible files.

A . You cannot change the application ID: False; the import wizard prompts for a new ID if there’s a
conflict or if you choose to override.

B . Supporting objects not imported: False; if included in the export (via "Include Supporting
Objects"), they’re imported (e.g., tables, triggers), unless skipped explicitly.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 45/51

Technical Insight: Export files contain a version check (e.g., apex_version := '23.2';), causing rejection
if the target instance’s APEX_VERSION is lower.

Use Case: Moving an app from a dev instance (23.2) to prod (23.2) works, but not to an outdated test
instance (19.1).

Pitfall: Always match versions or upgrade the target instance first.

Reference: Oracle APEX 23.2 Documentation - "Importing Applications" under App Builder.

om
Question: 49

.c
ps
Which API can be used to send Push Notifications immediately in Oracle APEX?

m
du
am
A. APEX_PWA.HAS_PUSH_SUBSCRIPTION

B. APEX_PWA.PUSH_QUEUE
ex

C. APEX_PWA.PURGE_QUEUE
id
al
.v

Answer: B
w
w
w

Explanation:
//
s:
tp

The APEX_PWA package manages Push Notifications:

ht

B . APEX_PWA.PUSH_QUEUE: This procedure forces immediate processing of the Push Notification

queue, sending queued messages (added via APEX_PWA.SEND) to subscribed devices without
waiting for the default scheduler (e.g., every 5 minutes). Example: APEX_PWA.PUSH_QUEUE;
ensures a "Meeting now!" alert goes out instantly.

A . APEX_PWA.HAS_PUSH_SUBSCRIPTION: Checks if a user has an active subscription (returns

BOOLEAN), not for sending.

C . APEX_PWA.PURGE_QUEUE: Clears the queue, discarding unsent messages, not sending them.

Technical Insight: PUSH_QUEUE triggers a job to contact the push service (e.g., Firebase), using

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 46/51

VAPID keys from the PWA configuration.

Use Case: Urgent alerts (e.g., system outage) need immediate delivery, bypassing delays.

Pitfall: Overuse can strain the server; use judiciously for time-sensitive messages.

Reference: Oracle APEX 23.2 Documentation - "APEX_PWA Package" under API Reference.

om
Question: 50

.c
Which is a valid method of logging messages to the execution log in APEX applications?

ps
m
du
A. apex_automation.log_info ('SAL for ' || :ENAME || ' increased by 19.');

B. apex_debug.info ('SAL for :ENAME ||' increased by 19.');

am
C. apex_error.add_error ('SAL for ' || :ENAME || ' increased by 19.');
ex
id
al

Answer: A
.v
w

Explanation:
w
// w

Logging in APEX tracks runtime activity:

s:

A . apex_automation.log_info: Correctly logs an informational message to the execution log for

tp

automation tasks (e.g., workflows). The syntax || :ENAME || concatenates the item value (e.g.,
ht

"JOHN") into "SAL for JOHN increased by 19." It’s stored in APEX_AUTOMATION_LOG, viewable in
Monitoring.

B . apex_debug.info: Logs to debug output, but the syntax is flawed (:ENAME || isn’t concatenated
properly; should be 'SAL for ' || :ENAME || ...). It’s valid only when debugging is enabled (e.g.,
APEX_DEBUG.ENABLE).

C . apex_error.add_error: Adds an error to the error stack for user display, not a log message.

Technical Insight: log_info is non-intrusive, unlike apex_debug, which requires debug mode, or
apex_error, which signals failure.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 47/51

Use Case: Logging salary updates in a scheduled job without debug overhead.

Pitfall: Ensure :ENAME is in scope (e.g., page item).

Reference: Oracle APEX 23.2 Documentation - "APEX_AUTOMATION Package" under API Reference.

Question: 51

om
Which three Theme Components are available out-of-the-box with the Universal Theme?

.c
ps
A. Calendar

m
du
B. Comments

C. Badge
am
D. REST Data Sources
ex
id
al

Answer: A, B, C
.v
w

Explanation:
w
// w

The Universal Theme (Theme 42) provides pre-built components:

s:

A . Calendar: A region type for date-based displays (e.g., events), styled with Universal Theme
tp

templates (e.g., FullCalendar integration).

ht

B . Comments: A region type for user feedback or notes, with built-in styling and moderation options.

C . Badge: A UI component for displaying counts or statuses (e.g., "5 New"), often in navigation or
lists, styled via CSS classes.

D . REST Data Sources: A data feature, not a theme component; it’s a Shared Component, not a UI
element tied to Universal Theme.

Technical Insight: These components leverage Universal Theme’s CSS (e.g., t-Badge, t-Calendar) and
JavaScript for interactivity, reducing custom coding.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 48/51

Use Case: A dashboard with a Calendar for schedules, Comments for feedback, and Badges for
unread alerts.

Pitfall: Customizing requires Theme Roller or CSS overrides.

Reference: Oracle APEX 23.2 Documentation - "Universal Theme Components" under Themes.

om
Question: 52

.c
ps
What happens when you regenerate credentials for Push Notifications in Oracle APEX?

m
du
A. Existing Push Subscriptions for the application will be invalidated.
am
B. A new notification server must be created.
ex

C. Push Notifications will be disabled for the application.

id
al

Answer: A
.v
w
w

Explanation:
// w
s:

Regenerating Push Notification credentials updates the VAPID keys (public/private pair) in the PWA
tp

settings:
ht

A . Existing Push Subscriptions invalidated: Subscriptions (in APEX_APPL_PUSH_SUBSCRIPTIONS) are

tied to the old keys. New keys break this link, requiring users to re-subscribe (e.g., via browser
prompts), as the push service (e.g., Firebase) can’t authenticate old subscriptions.

B . New notification server: False; the server configuration remains; only credentials change.

C . Disabled for the app: False; notifications remain enabled but won’t work for old subscriptions
until re-established.

Technical Insight: Regeneration updates APEX_PWA_VAPID_PUBLIC_KEY and

APEX_PWA_VAPID_PRIVATE_KEY, triggering a subscription refresh cycle.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 49/51

Use Case: Security breach requires key rotation.

Pitfall: Users must re-opt-in, potentially losing some subscribers.

Reference: Oracle APEX 23.2 Documentation - "Configuring Push Notifications" under Application
Definition.

Question: 53

om
.c
Which statement is true about Theme Styles?

ps
m
A. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime

du
environment.
am
B. Theme Styles control the layout of a webpage.

C. The "Is Current" attribute of a Theme Style depends on the "Read Only" attribute.
ex
id
al

Answer: A
.v
w

Explanation:
w
// w

Theme Styles define visual themes in APEX:

s:
tp

A . When the Is Public attribute is enabled: Setting "Is Public" to "Yes" in Shared Components >
Theme Styles allows runtime selection (e.g., via a dropdown in the app UI), letting users switch
ht

between styles (e.g., "Vita" to "Vita - Dark").

B . Control layout: False; layout is managed by templates and regions; Theme Styles handle colors,
fonts, etc.

C . "Is Current" depends on "Read Only": False; "Is Current" marks the default style, independent of
"Read Only" (which locks editing).

Technical Insight: Public styles require multiple defined styles and a UI component (e.g., Dynamic
Action) to expose the switcher.

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 50/51

Use Case: Offering light/dark mode options to users.

Pitfall: Without a switcher, "Is Public" has no visible effect.

Reference: Oracle APEX 23.2 Documentation - "Managing Theme Styles" under Themes.

om
.c
ps
m
du
am
ex
id
al
.v
w
w
// w
s:
tp
ht

https://www.validexamdumps.com/1Z0-771.html
Questions and Answers PDF 51/51

Thank you for your visit.

To try more exams, please visit below link
https://www.validexamdumps.com/1Z0-771.html

om
.c
ps
m
du
am
ex
id
al
.v
w
w
// w
s:
tp
ht

https://www.validexamdumps.com/1Z0-771.html