Amazon
Avaya
Checkpoint
Cisco®
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL®
Juniper
Microsoft
MuleSoft
Okta
Oracle
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. Oracle
  3. 1Z0-771

Oracle 1Z0-771 Exam (page: 1)
Oracle APEX Cloud Developer Professional
Updated on: 11-Nov-2025

Viewing Page 1 of 8
1Z0-771 PDF 53 Questions

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?

  1. Popup LOV
  2. Range
  3. Date Picker
  4. Checkbox Group

Answer(s): B,D

Explanation:

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

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 selection in forms, and Date Picker is a standalone item type, not a facet-specific UI.


Reference:

Oracle APEX 23.2 Documentation - "Managing Faceted Search" under Application Builder User's Guide.



Which two SQL format options does the APEX Assistant provide when using the "Create Data Model using AI" feature?

  1. Quick SQL
  2. MySQL
  3. Oracle SQL
  4. Oracle PL/SQL

Answer(s): A,C

Explanation:

The "Create Data Model using AI" feature in APEX Assistant leverages AI to generate data models 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.



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

  1. Region
  2. Application
  3. Page
  4. Instance

Answer(s): B

Explanation:

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.



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

  1. Function Body returning SQL Query
  2. Latitude and Longitude
  3. GeoJSON
  4. State and Pincode

Answer(s): B,C

Explanation:

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

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

GeoJSON: Returns coordinates in a structured JSON format compliant with the GeoJSON standard (e.g., { "type": "Point", "coordinates": [-122.4194, 37.7749] }).

Function Body returning SQL Query is a dynamic action type, not a coordinate format, and State and Pincode is unrelated to geolocation coordinates.


Reference:

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



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

  1. Using Quick SQL
  2. Using Data Workshop
  3. Using SQL Scripts
  4. Using Object Browser

Answer(s): C,D

Explanation:

In SQL Workshop, custom stored procedures can be created using:

SQL Scripts: Allows developers to write and execute PL/SQL code directly to define stored procedures.

Object Browser: Provides a GUI to create and edit database objects, including stored procedures, by defining their specifications and bodies.

Quick SQL is for generating table DDL, not stored procedures, and Data Workshop is for loading/unloading data, not creating procedures.


Reference:

Oracle APEX 23.2 Documentation - "SQL Workshop Guide" under SQL Scripts and Object Browser sections.



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

  1. Create a database link to the remote Oracle Database in the local APEX schema.
  2. Install ORDS 19.x or later on the remote Oracle Database.
  3. REST-enable the schema in the remote Oracle Database by using ORDS.ENABLE_SCHEMA.
  4. Install Oracle APEX in the remote Oracle Database.

Answer(s): B,C

Explanation:

To use REST-enabled SQL in APEX:

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

REST-enable the schema: The schema on the remote database must be REST-enabled using ORDS.ENABLE_SCHEMA to allow SQL execution via REST.

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.


Reference:

Oracle APEX 23.2 Documentation - "Using REST-Enabled SQL" under Data Sources.



Which statement is true about the Data Workshop utility?

  1. You cannot load data from an XLSX file with multiple worksheets.
  2. The wizards load and unload all types of schema objects.
  3. The wizards load and unload table data only.
  4. You can load or unload multiple tables at a time.

Answer(s): C

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.



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

  1. Download Dynamic Action
  2. APEX_UTIL.DOWNLOAD PL/SQL API
  3. Download Page Process
  4. Share Dynamic Action

Answer(s): A,C

Explanation:

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.


Reference:

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



Viewing Page 1 of 8



Share your comments for Oracle 1Z0-771 exam with other users:

SuckerPumch88 4/25/2022 10:24:00 AM

the questions are exactly the same in real exam. just make sure not to answer all them correct or else they suspect you are cheating.
UNITED STATES


soheib 7/24/2023 7:05:00 PM

question: 78 the right answer i think is d not a
Anonymous


srija 8/14/2023 8:53:00 AM

very helpful
EUROPEAN UNION


Thembelani 5/30/2023 2:17:00 AM

i am writing this exam tomorrow and have dumps
Anonymous


Anita 10/1/2023 4:11:00 PM

can i have the icdl excel exam
Anonymous


Ben 9/9/2023 7:35:00 AM

please upload it
Anonymous


anonymous 9/20/2023 11:27:00 PM

hye when will post again the past year question for this h13-311_v3 part since i have to for my test tommorow…thank you very much
Anonymous


Randall 9/28/2023 8:25:00 PM

on question 22, option b-once per session is also valid.
Anonymous


Tshegofatso 8/28/2023 11:51:00 AM

this website is very helpful
SOUTH AFRICA


philly 9/18/2023 2:40:00 PM

its my first time exam
SOUTH AFRICA


Beexam 9/4/2023 9:06:00 PM

correct answers are device configuration-enable the automatic installation of webview2 runtime. & policy management- prevent users from submitting feedback.
NEW ZEALAND


RAWI 7/9/2023 4:54:00 AM

is this dump still valid? today is 9-july-2023
SWEDEN


Annie 6/7/2023 3:46:00 AM

i need this exam.. please upload these are really helpful
PAKISTAN


Shubhra Rathi 8/26/2023 1:08:00 PM

please upload the oracle 1z0-1059-22 dumps
Anonymous


Shiji 10/15/2023 1:34:00 PM

very good questions
INDIA


Rita Rony 11/27/2023 1:36:00 PM

nice, first step to exams
Anonymous


Aloke Paul 9/11/2023 6:53:00 AM

is this valid for chfiv9 as well... as i am reker 3rd time...
CHINA


Calbert Francis 1/15/2024 8:19:00 PM

great exam for people taking 220-1101
UNITED STATES


Ayushi Baria 11/7/2023 7:44:00 AM

this is very helpfull for me
Anonymous


alma 8/25/2023 1:20:00 PM

just started preparing for the exam
UNITED KINGDOM


CW 7/10/2023 6:46:00 PM

these are the type of questions i need.
UNITED STATES


Nobody 8/30/2023 9:54:00 PM

does this actually work? are they the exam questions and answers word for word?
Anonymous


Salah 7/23/2023 9:46:00 AM

thanks for providing these questions
Anonymous


Ritu 9/15/2023 5:55:00 AM

interesting
CANADA


Ron 5/30/2023 8:33:00 AM

these dumps are pretty good.
Anonymous


Sowl 8/10/2023 6:22:00 PM

good questions
UNITED STATES


Blessious Phiri 8/15/2023 2:02:00 PM

dbua is used for upgrading oracle database
Anonymous


Richard 10/24/2023 6:12:00 AM

i am thrilled to say that i passed my amazon web services mls-c01 exam, thanks to study materials. they were comprehensive and well-structured, making my preparation efficient.
Anonymous


Janjua 5/22/2023 3:31:00 PM

please upload latest ibm ace c1000-056 dumps
GERMANY


Matt 12/30/2023 11:18:00 AM

if only explanations were provided...
FRANCE


Rasha 6/29/2023 8:23:00 PM

yes .. i need the dump if you can help me
Anonymous


Anonymous 7/25/2023 8:05:00 AM

good morning, could you please upload this exam again?
SPAIN


AJ 9/24/2023 9:32:00 AM

hi please upload sre foundation and practitioner exam questions
Anonymous


peter parker 8/10/2023 10:59:00 AM

the exam is listed as 80 questions with a pass mark of 70%, how is your 50 questions related?
Anonymous