Questions for the 1Z0-770 were updated on : Dec 01 ,2025
Which two statements are true about Maps in Oracle APEX?
A, D
Explanation:
A map is a type of component that enables you to view and manage data based on geographic
locations. A map consists of a background map and spatial geometry objects that are sourced from
data in a table or from a REST Data Source. Spatial geometry objects are shapes that represent real-
world features on a map, such as points, lines, polygons, or heat maps. Two of the statements that
are true about maps in Oracle APEX are:
Background maps do not require any API keys. This statement is true because Oracle APEX provides
several background map options that do not require any API keys or registration to use. These
options include OpenStreetMap, Stamen Maps, CartoDB Maps, and Esri Maps.
Maps support REST Enabled SQL. This statement is true because Oracle APEX allows you to use REST
Enabled SQL as a data source for your map regions. REST Enabled SQL is a feature of Oracle REST
Data Services (ORDS) that enables you to execute SQL statements and PL/SQL blocks over HTTPS
using REST endpoints.
Which statement is true about the Approvals component?
C
Explanation:
The Approvals Component is a feature in Oracle APEX that enables you to create and manage tasks
for user approval. The Approvals Component deals with all aspects of human approval in Oracle
APEX, allowing you to put approval functionality into your applications. The Approvals Component
creates one or more tasks for items that require approval based on a pre-configured template,
known as the Task Definition. The Task Definition specifies the data source, display attributes,
potential owners, business administrators, and available actions for the tasks. You can set up task
approvers and administrators at design time or determine them dynamically at runtime based on
data related to the task. For example, you can use a SQL query or a PL/SQL function to return the list
of potential owners or business administrators for each task based on some criteria, such as
department, role, or location.
You want to enable anyone to access your application using a built-in login page that captures a user
name. Which authentication scheme would you choose?
C
Explanation:
Open Door Credentials is an authentication scheme that allows anyone to access your application
using a built-in login page that captures a user name. You can use this scheme for testing purposes or
for applications that do not require secure authentication. You can select this scheme from the
Authentication Type list when creating or editing an authentication scheme. References:
[Understanding Authentication] and [Creating an Authentication Scheme]
Which two statements are true about REST Data Sources?
A, C
Explanation:
A REST Data Source is a logical representation of an external web service in Oracle APEX. It can
contain one or many Operations, which are the references to a concrete external web service
endpoint. Oracle APEX supports three types of REST Data Sources: REST Enabled SQL Query, Web
Source Module, and Generic REST Data Source. Oracle APEX provides direct integration of REST Data
Sources in interactive reports and grids, as well as other components. REST Data Sources can support
various authentication methods, such as Basic, OAuth2, or Custom. References: [Understanding REST
Data Sources] and [Creating a REST Data Source]
In your application, you want to include a master aetall containing two pages
based on two related tables or views. The first page contains an interactive
report for the master table. The second page features a standard form for the
master and interactive grids for the detail. Which master detail form will you
create?
B
Explanation:
A drill down master detail form allows you to create a master detail form that contains two pages
based on two related tables or views. The first page contains an interactive report for the master
table. The second page features a standard form for the master and interactive grids for the detail.
You can use the Create Page wizard to create a drill down master detail form. References:
Creating
Master Detail Forms
and [Creating a Drill Down Master Detail Form]
Which two statements are true about the generated SQL?
AC
Explanation:
The generated SQL script creates two tables: DEPARTMENTS and EMPLOYEES, with the specified
columns and data types. It does not insert any data into the tables, nor does it create any primary or
foreign keys. The script only creates the tables and their columns. References:
Creating a Desktop
Database Application
and
Using SQL Workshop
Which statement is true about using the App Gallery?
B
Explanation:
Custom Apps are specific to your workspace and are only available if your instance administrator has
enabled them. You can install Sample Apps and Starter Apps directly from the Gallery or download
them from GitHub. Sample Apps and Starter Apps are available with every Oracle APEX workspace.
References:
Using the App Gallery
and
Configuring the Application Gallery
What are the two primary ways to move database objects and data from one environment to
another, for a single application?
A, B
Explanation:
Oracle SQL Developer and SQL Workshop are two primary ways to move database objects and data
from one environment to another, for a single application. Oracle SQL Developer is a graphical tool
that allows you to export and import data schemas using Data Pump or SQL scripts. SQL Workshop is
a component of Oracle APEX that enables you to perform tasks such as exporting and importing data,
running SQL commands, and generating DDL scripts. Both tools can help you migrate your database
objects and data to a different instance or workspace. References:
Using SQL Developer to Migrate
Your Oracle Database
and
Using Data Workshop to Manage Data
While migrating apps, once the database objects are created in the target environment, you can load
the data using which of the components?
A
Explanation:
Data Workshop is a feature in Oracle APEX that enables you to load and unload data to and from the
database. You can use Data Workshop to copy data between Oracle databases or between an Oracle
database and external files. Data copying is accomplished by exporting and importing data, and by
unloading and loading data. While migrating apps, once the database objects are created in the
target environment, you can load the data using Data Workshop by following these steps:
Access Data Workshop by clicking Utilities and then Data Workshop in SQL Workshop.
Click Load Data.
Select a data source type, such as Text File (CSV), XML File (XML), Copy & Paste (Spreadsheet), or
Object Store Reference (Autonomous Database only).
Specify a file name or location for your data source.
Select a table name for your data destination.
Map your data columns to your table columns.
Review your data load settings and click Load Data.
What three components must be considered while migrating an APEX app between environments?
A, B, D
Explanation:
To migrate an APEX app between environments, such as from development to production, you need
to consider three components that make up an APEX app:
Database objects: These are the tables, views, procedures, functions, packages, triggers, sequences,
synonyms, and other schema objects that store or manipulate the data used by the app. You need to
move these objects from the source schema to the target schema using tools such as SQL Developer,
Data Pump Export/Import, or Data Workshop.
Images: These are the static files, such as images, CSS files, JavaScript files, or PDF files, that are used
by the app for display or download purposes. You need to move these files from the source web
server to the target web server using tools such as FTP, SCP, or File Explorer.
Application definition and all associated files: These are the metadata files that define the app
components, such as pages, regions, items, buttons, processes, validations, computations, dynamic
actions, shared components, and so on. You also need to include any supporting object definitions or
data scripts that are used to create or populate database objects for the app. You need to move these
files from the source APEX instance to the target APEX instance using tools such as App Builder
Export/Import or One-click Remote Application Deployment.
Select the two advantages of using One-click Remote Deployment.
BC
Explanation:
One-click remote application deployment is a feature in Oracle APEX that simplifies the process of
deploying an application from one APEX instance to another using REST Enabled SQL references.
REST Enabled SQL references are shared components that work with an Oracle REST Data Services
(ORDS) REST Enabled SQL Service. One-click remote application deployment can authenticate
through first party authentication (Basic Authentication), Schema Authentication (database
username and password), or OAuth 2 Client Credentials. Two of the advantages of using one-click
remote application deployment are:
Deploy the app, and explicitly install the supporting objects in one-click. This advantage allows you to
package the app definition along with the database objects, images, and seed data necessary for
your application to run correctly using the Supporting Objects functionality in APEX. You can then
export and deploy this app and install the supporting objects in one-click without having to manually
create or copy the database objects in the target system.
Directly deploy your app definition along with the objects from the source system to the target
system. This advantage allows you to avoid the intermediate step of exporting the app and its objects
from the source system into files and then importing them into the target system. You can directly
deploy your app and its objects from within your development environment to the remote
production environment without having to access your production environment.
Choose the three correct statements about Charts in APEX.
A, B, D
Explanation:
A chart is a type of component that enables users to visualize data in different ways and perform data
analysis. A chart can display data in various formats, such as bars, lines, areas, ranges, combinations,
scatters, bubbles, polars, radars, pies, donuts, funnels, and more. Oracle APEX supports charts based
on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations. Oracle JET is a modular
open source toolkit based on modern JavaScript, CSS3, and HTML5 design and development
principles. Three of the correct statements about charts in Oracle APEX are:
You can visualize data as bar, line, area, range, combination, scatter, bubble, polar, radar, pie, donut,
funnel and more. This statement is true because Oracle APEX provides a rich set of chart types that
can be used to display data in different ways and support different analysis scenarios. You can choose
from over 20 chart types when creating a chart in Oracle APEX.
Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data
Visualizations. This statement is true because Oracle APEX uses Oracle JET as the underlying
technology for rendering charts in the browser. Oracle JET provides high-performance and interactive
data visualizations that are compatible with various devices and browsers.
Each Oracle JET visualization supports animation, accessibility, responsive layout,
internationalization, test automation, and a range of inter activity features. This statement is true
because Oracle JET offers many features and capabilities that enhance the user experience and
functionality of the charts. For example:
Animation: Charts can have smooth transitions and effects when loading or updating data.
Accessibility: Charts can support keyboard navigation, screen reader compatibility, and high contrast
mode for users with disabilities.
Responsive layout: Charts can adapt to different screen sizes and orientations by resizing or
repositioning elements.
Internationalization: Charts can support different languages, date formats, number formats, and text
directions for users from different regions.
Test automation: Charts can support automated testing tools and frameworks by providing unique
identifiers for elements.
Interactivity: Charts can support user actions such as zooming, panning, filtering, selecting, drilling
down, or popping up tooltips.
Choose the three supported spatial geometry objects in Maps.
A, B, D
Explanation:
A map is a type of component that enables users to view and manage data based on geographic
locations. A map consists of a background map and spatial geometry objects that are sourced from
data in a table or from a REST data source. Spatial geometry objects are shapes that represent real-
world features on a map, such as points, lines, polygons, or heat maps. Three of the supported
spatial geometry objects in Oracle APEX are:
Polygons: A polygon is a closed shape that consists of three or more vertices connected by straight
line segments. A polygon can represent an area on a map, such as a country, a state, a city, or a
building. A polygon can have different colors, patterns, or borders to indicate different attributes or
categories of the data.
Heat map: A heat map is a type of visualization that uses color gradients to show the density or
intensity of data values in a geographic area. A heat map can represent the distribution or variation
of a numeric variable on a map, such as population, income, crime rate, or temperature.
Points: A point is a zero-dimensional shape that represents a single location on a map. A point can
have different symbols, sizes, or colors to indicate different attributes or categories of the data. A
point can also have a label or a tooltip to display additional information about the data.
What are the required fields while creating a Chart in APEX?
A
Explanation:
To create a chart in Oracle APEX, you need to provide some required fields that define the data
source and appearance of the chart. You can use either the Create Page Wizard or Page Designer to
create a chart. The required fields for creating a chart are:
Data Source: This field specifies the SQL query that returns the data for the chart. The query must
include at least one column for the label and one column for the value of each data point. You can
also include additional columns for grouping, color, or tooltip information.
Value Column: This field specifies the column from the data source query that contains the numeric
values for the chart. The values are used to plot the data points on the chart and determine the size
of each data point or segment.
Name: This field specifies the name of the chart region. The name is used to identify the region in
Page Designer and other components, such as dynamic actions or processes.
Label Column: This field specifies the column from the data source query that contains the labels for
the chart. The labels are used to display the name of each data point or segment on the chart or in
the legend.
What are the three features of a calendar in APEX?
A, B, C
Explanation:
A calendar is a type of component that enables users to view and manage data based on dates. A
calendar can display data in different views, such as monthly, weekly, daily, or list. Users can also
interact with the calendar by creating, editing, or deleting events, or by using drag and drop
functionality. Three of the features of a calendar in Oracle APEX are:
Next - Navigates to the next month. This feature allows users to move forward in time and see the
events for the following month.
Previous - Navigates to the previous month. This feature allows users to move backward in time and
see the events for the previous month.
Month, Week, Day - Displays a monthly, weekly and daily view. These features allow users to switch
between different views of the calendar and see the events for a specific month, week, or day.