1z1-770 Exam PDF [2023] Tests Free Updated Today with Correct 144 Questions [Q59-Q79]

November 4, 2023 1z1-770, Oracle 0 Comments

1z1-770 Exam PDF [2023] Tests Free Updated Today with Correct 144 Questions [Q59-Q79]

Rate this post

1z1-770 Exam PDF [2023] Tests Free Updated Today with Correct 144 Questions

Oracle 1z1-770 Exam Preparation Guide and PDF Download

Oracle APEX Developer Professional exam consists of 70 multiple-choice questions that are based on Oracle APEX version 20.x. 1z1-770 exam covers different topics such as understanding APEX architecture, creating and managing applications, working with data, security, and troubleshooting APEX applications. Oracle APEX Developer Professional certification exam is designed to evaluate the candidate’s knowledge, skills, and abilities in using Oracle APEX to design and develop web applications that meet the industry standards.

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

Search Page

Faceted Search

Interactive Grid

All of them

Smart Filters

Q60. Which statement is true about using the App Gallery?

You cannot install Sample Apps and Starter Apps directly from the Gallery.

Custom Apps are only available if your instance administrator has enabled them.

Sample Apps and Starter Apps are only available if your instance administrator has enabled them.

You can download Sample Apps and Starter Apps from Team Development to import into your workspace.

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

Oracle SQL Developer

SQL Workshop

App Builder

Page Designer

Q62. When you run an application, the APEX engine relies on which two processes?

Show Page

Run Page

Validate Page

Accept page

Q63. 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 changes?

Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute. Then, navigate to each facet and in the Property Editor, turn on client-Side Filtering.

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

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

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

Q64. What three are the key features of Data Load Definition?

The APEX_DATA_LOADING PL/SQL API is available for custom processing.

Only XML data format can be loaded to tables or collections

Column mapping occurs at design time, removing the burden on end users.

Easy workflow for end users: upload the file, verify the preview, and load data

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

Single Pane Mode

Two Pane Mode

Three Pane Mode

Four Pane Mode

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

Move the database objects

Move the images

Move the sessions data

Move the application definition and all associated files

Q67. A Page Computation can be created from which two of the following tabs?

Rendering Tree

Processing

Dynamic Actions

Shared Components

Q68. 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?

Date Picker

Range

Checkbox Group

Popup LOV

Q69. 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?

It will default to FALSE.

It will restrict acceptable values to TRUE or FALSE.

It will default to TRUE.

It will restrict acceptable values to Y or N.

Q70. Let’s say that there are two select lists on a page. Making a selection in the DEPARTMENT select list, determines which individuals display in the Employees select list. This type of LOV is called:

Popup LOV

Cascading LOV

Static LOV

Dynamic LOV

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

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

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

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

The search results report can be displayed as an interactive grid

Q72. You have defined a REST Data Source with ORDS as the REST Data Source Type. This REST Data Source is based on an AutoREST-enabled EMP table on a remote Oracle Database. This REST Data Source is beingused as source for an editable interactive grid. When a user updates an employee record in this interactive grid, which operation (HTTP Method) defined in the REST Data Source is utilized to update a record in the EMP table on the remote Oracle Database?

GET

POST

PUT

Q73. When you create a Dynamic Action, you specify the event that causes the dynamic action to fire.
Choose the categories these events are classified into.

Custom Events

Framework Events

All of them

Component Events

Browser Events

Q74. You must reference certain data from a dragged event under the Drag and Drop PL/SQL Code attribute of the Calendar component.
Examine this list:
1. The ID
2. The NEW_START_DATE
3. The NEW END DATE
How can these be referenced?

#APEX.PK_VALUE#, #APEX.NEW START_DATE# and #APEX.NEW_END_DATE#

:APEX$PK_VALUE, APEX$NEW START DATE and APEXSNEW_END_DATE

:APEX.PK_VALUE, :APEX.NEW START DATE and :APEX.NEW END DATE

#APEXSPK VALUE#, #APEX$NEW START DATE# and #APEXSNEW END DATE#

Q75. What are the three types of Master Detail Form you can create in APEX?

One Below the other

Stacked

Side by Side

Two Page Drill Down

Q76. You added Access Control feature pages to your application. Which two actions can you perform as an Administrator using the Administration page?

Assign roles to users

Create Authorization schemes

Add Users

Create new application roles

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

Delete the application

Navigate to Shared Components

Export the application

Create a new page

Q78. Which two are true when the Edit option is NOT enabled for an Interactive Grid?

The end user cannot edit the underlying data in the database

The end user can edit the underlying data in the database