Summer Sale Coupon - 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: c4sbfdisc

1z0-770 PDF

$44

$109.99

3 Months Free Update

  • Printable Format
  • Value of Money
  • 100% Pass Assurance
  • Verified Answers
  • Researched by Industry Experts
  • Based on Real Exams Scenarios
  • 100% Real Questions

1z0-770 PDF + Testing Engine

$70.4

$175.99

3 Months Free Update

  • Exam Name: Oracle APEX Cloud Developer Professional
  • Last Update: Apr 17, 2024
  • Questions and Answers: 142
  • Free Real Questions Demo
  • Recommended by Industry Experts
  • Best Economical Package
  • Immediate Access

1z0-770 Engine

$52.8

$131.99

3 Months Free Update

  • Best Testing Engine
  • One Click installation
  • Recommended by Teachers
  • Easy to use
  • 3 Modes of Learning
  • State of Art Technology
  • 100% Real Questions included

1z0-770 Practice Exam Questions with Answers Oracle APEX Cloud Developer Professional Certification

Question # 6

In a Classic Report, an end user can perform which two of the following actions?

A.

Create Control Breaks in the report

B.

Rearrange the columns in the report

C.

Filter values of a column in the report

D.

Sort the columns of the report

Full Access
Question # 7

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

A.

Single Pane Mode

B.

Two Pane Mode

C.

Three Pane Mode

D.

Four Pane Mode

Full Access
Question # 8

Which statement is true about the Link Column attribute of an interactive report?

A.

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

B.

It is not possible to exclude Link Column.

C.

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

D.

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

Full Access
Question # 9

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

A.

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

B.

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

C.

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

D.

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

Full Access
Question # 10

Which of the following options in the Developer Toolbar enables you to customize the look and

feel of the application?

A.

Quick Edit

B.

Customize

C.

Session

D.

Debug

Full Access
Question # 11

Examine this code entered in Quick SQL:

emp_salary

name vc255

salary num

commission yn/check TRUE, FALSE

Which statement is true about the commission yn column?

A.

It will default to FALSE.

B.

It will restrict acceptable values to TRUE or FALSE.

C.

It will default to TRUE.

D.

It will restrict acceptable values to Y or N.

Full Access
Question # 12

To highlight certain rows in the interactive report based on a condition, you must:

A.

Provide a conditional SQL query

B.

Edit the rows in the report and select a color

C.

Rows cannot be highlighted in an Interactive report

D.

Choose a condition in Format > Highlight

Full Access
Question # 13

The Page Designer Toolbar allows you to perform which two of the following actions?

A.

Delete the application

B.

Navigate to Shared Components

C.

Export the application

D.

Create a new page

Full Access
Question # 14

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

A.

Latitude/Longitude

B.

JSON_OBJECT

C.

GeoJSON

D.

SDO_GEOMETRY

Full Access
Question # 15

Which two statements are true about loading data from the "Create an Application From a File"

wizard?

A.

Seed data from a SQL script can be uploaded.

B.

A sample data set from the sample list can be uploaded.

C.

XML and JSON data can be pasted and loaded.

D.

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

E.

Data from remote web services can be uploaded.

Full Access
Question # 16

Choose from the following the different kinds of page components you can create in APEX.

A.

Search Page

B.

Faceted Search

C.

Interactive Grid

D.

All of them

E.

Smart Filters

Full Access
Question # 17

Select the three types of Card Layout you can create in APEX.

A.

Vertical(Column)

B.

Float

C.

Grid

D.

Horizontal(Row)

Full Access
Question # 18

Which two statements are true about the Create Application Wizard?

A.

It allows application pages to be reordered.

B.

It allows application pages to be added or deleted.

C.

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

D.

It allows the application authorization to be changed

Full Access
Question # 19

Which two of the following types can an end user save the customized Interactive report as?

A.

A Public report

B.

Cannot save the report

C.

A private report

D.

Default report

Full Access
Question # 20

What are the two primary ways to move database objects and data from one environment toanother, for a single application?

A.

Oracle SQL Developer

B.

SQL Workshop

C.

App Builder

D.

Page Designer

Full Access
Question # 21

Which two statements are true about Maps in Oracle APEX?

A.

Background maps do not require any API keys.

B.

Maps don’t support REST Data Sources

C.

Heat Map and Polygons are not supported Spatial geometry objects

D.

Maps support REST Enabled SQL

Full Access
Question # 22

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

A.

Access Control

B.

Feedback

C.

Search Page

D.

Unified Task List

Full Access
Question # 23

Which three statements are TRUE about Shared Components?

A.

Once you create a Shared Component, you can add them to any page within your APEX

application

B.

Shared components are common elements that can be displayed or applied on any page

within an application

C.

Once you create a Shared Component, you can add them to any page within an APEX

application in any workspace.

D.

Breadcrumbs, Lists, and Navigation Bar entries are examples of shared components

Full Access
Question # 24

What are the three types of List of Values(LOV) you can create on a page?

A.

Static LOV

B.

Cascading LOV

C.

Dynamic LOV

D.

Popup LOV

Full Access
Question # 25

When a button is pressed, an overlay window is positioned within the viewport. What kind ofpage mode is it?

A.

Help Page

B.

Modal Dialog

C.

Normal Page

D.

Non-Modal Dialog

Full Access
Question # 26

Choose the three requirements for creating a REST Enabled SQL Reference.

A.

Install Oracle REST Data Services (ORDS) 19.x or later.

B.

Activate REST Enabled SQL for the target schema on the remote database

C.

Set up any remote database

D.

Configure and enable the REST Enabled SQL service feature

Full Access
Question # 27

Which statement is true about Theme Styles in Oracle APEX?

A.

Theme Styles in Oracle APEX determine the layout and structure of a webpage.

B.

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

C.

You can only enable the Is Current attribute when the Theme Style has the Read Only attribute disabled.

Full Access
Question # 28

Which two statements are true about creating and customizing Smart Filters pages?

A.

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

Data Dictionary Cache.

B.

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

C.

The suggestion chip count is only displayed for filters that support counts, such as LOV-based

filter types.

D.

The search results report can be displayed as an interactive grid

Full Access
Question # 29

You can create a report in which of the three following methods?

A.

Create a report as a new page in an application

B.

Create a report when you create a new database application

C.

Create a report from Object Browser

D.

Create a report region on a page in an application

Full Access
Question # 30

Choose the three different ways in which you can add a checkbox to a page.

A.

Drag and drop the checkbox item into the Layout pane

B.

Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type.

C.

Use the context sensitive menu in the Gallery pane.

D.

Add a checkbox from the Property Editor

Full Access
Question # 31

Choose the statement that is TRUE about Universal Theme.

A.

Features a responsive design and enables developers to create web applications without

extensive knowledge of HTML, CSS, or JavaScript

B.

Universal theme is the default theme that is shipped with Oracle APEX

C.

All of them

D.

Uses a 12-column grid layout system for arranging components on a page.Ships with a variety of pre-built theme styles

Full Access
Question # 32

Examine this code used in Quick SQL:

students

name

roll no num

Quick SQL is using default settings.

Which table creation script or other output is produced?

A.

An Invalid column definition error message will be displayed.

B.

create table students (

id number generated by default on null as identity constraint students id pk primary

key,

name varchar2 (255 char) not null,

roll no number

)

;

C.

create table students (

id number generated by default on null as identity constraint students_id_pk primary

key,

name varchar2 (255 char),

roll_no number

)

;

Full Access
Question # 33

What three are the building blocks of Approvals Component?

A.

Task Details Page

B.

Automations

C.

Task Definition

D.

Unified Task List

Full Access
Question # 34

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

A.

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

B.

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

C.

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

D.

Install Oracle APEX in the remote Oracle Database.

Full Access
Question # 35

While migrating apps, once the database objects are created in the target environment, you canload the data using which of the components?

A.

Data Workshop

B.

Data Generator

C.

App Builder

D.

Quick SQL

Full Access
Question # 36

What three components must be considered whilemigrating an APEX app betweenenvironments?

A.

Move the database objects

B.

Move the images

C.

Move the sessions data

D.

Move the application definition and all associated files

Full Access
Question # 37

What are Task definitions that exist on the application level inthe Shared Components section made up of?

A.

Particpants

B.

All of them

C.

Task Settings

D.

Parameters

E.

Actions

Full Access
Question # 38

Choose the three types of aggregations you can apply on a column.

A.

Average

B.

Standard Deviation

C.

Sum

D.

Count

Full Access
Question # 39

Which two statements are true about REST Data Source Synchronization?

A.

To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.

B.

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

C.

If the local table is not in sync with the Data Profile, Data Synchronization doesn't work.

D.

You cannot trigger Data Synchronization on a regular schedule using a scheduler job.

E.

The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties

Full Access
Question # 40

What are the three features of a calendar in APEX?

A.

Next - Navigates to the next month.

B.

Previous - Navigates to the previous month.

C.

Month, Week, Day - Displays a monthly, weekly and daily view.

D.

Reminders - Displays the reminders set by the users

Full Access
Question # 41

Select the two places from where you can access the Shared Components Page?

A.

Gallery

B.

Page Designer

C.

Application homepage

D.

SQL Workshop

Full Access
Question # 42

Which two statements are true about creating and managing an APEX Workspace?

A.

New schemas cannot be created during workspace creation.

B.

During workspace creation, you can associate the workspace with an existing databaseschema.

C.

A workspace enables multiple users to work within the same Oracle APEX installation.

D.

A workspace can be associated with only one schema.

E.

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

Full Access