Download Latest 1Z0-770 Dumps with Authentic Real Exam QA’s [Q54-Q78]

QUESTION 54
Consider a customers report. A customer name is clicked in the report to display the Customer Details form. When the items in the form dialog are updated and the user clicks Apply Changes, the page process is executed and the items from the page are used to update and commit the underlying table in the Oracle Database. What are the two types of events that occurred in this scenario?

Page Refresh

Page Validation

Page Rendering

Page Processing

QUESTION 55
Which three are the main components of APEX workspace homepage?

Gallery

RESTful Services

SQL Workshop

App Builder

QUESTION 56
Which three statements are TRUE about Shared Components?

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

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

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

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

QUESTION 57
Which three of the following are use cases of Automations?

Deleting a database record based on an end user’s request

Monitoring log tables and raising an alert when there is an issue

Approving specific requests

Sending email alerts at a particular time of the week

QUESTION 58
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

QUESTION 59
Which three of the following statements are TRUE about Data Synchronization?

Data Synchronization enables developers to automatically sync the contents of a local table with the data from a REST service.

APEX can create the local table based on the visible columns in the REST Data Source Data Profile.

Helps in Providing efficient reporting on large data sets coming from a REST service

You must trigger Data Synchronization manually

QUESTION 60
Choose the two statements that are TRUE about the Universal Theme in APEX.

Not designed to work on tablets

Responsive UI

Easy customization

The developers must have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme.

QUESTION 61
Which client credentials are utilized for authentication during the One-Click Remote ApplicationDeployment process?

Database schema credentials

PEX Developer credentials

APEX Workspace Admin credentials

QUESTION 62
Which two are true about Oracle APEX?

Performs the data processing in a middle-tier server

Requires no additional client software. A web browser is the app development IDE.

Requires developers to be proficient in Java, Python and other programming languages.

Is declarative. It requires no code generation.

QUESTION 63
Select the three types of Facets you can create in APEX.

Range

Text Area

Checkbox Group

Input Field

QUESTION 64
In your APEX application, you want to have an orderly grid layout of information tiles. Which page type should you choose in the Create Page Wizard?

Master Detail

Cards

Interactive Grid

Unified Task List

QUESTION 65
Which two statements are true about the usage of a Remote Server in the context of REST Data Sources?

The remote server determines the base URL of the REST Data Source.

The remote server should mandatorily be an APEX instance.

Multiple REST Data Sources can reference a single remote server.

A single REST Data Source can use multiple remote servers.

QUESTION 66
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

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

Vertical(Column)

Float

Grid

Horizontal(Row)

QUESTION 68
There is a validation of type Item is numeric on the P1_SALARY item. When the page is submitted, this or message is displayed both in the notification and below the item: What will cause the validation error to appear only in the Notification area?

Setting the value Required to Yes on P1_SALARY

Removing P1_SALARY from the validation Associated Item

Setting Display Location to Inline in Notification

QUESTION 69
Which two statements are true about the Create Application Wizard?

It allows application pages to be reordered.

It allows application pages to be added or deleted.

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

It allows the application authorization to be changed

QUESTION 70
Which statement is true about creating and using a report with form?

Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination.

In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source).

The Create Application Wizard doesn’t support the creation of an interactive report and form combination.

The Create Page Wizard doesn’t support the creation of a classic report and formcombination

QUESTION 71
Which two Query Source types can be used to create a dynamic Navigation Bar List?

Select List

SQL Query

Function Returning SQL Query

Procedure

QUESTION 72
What are the three features of a calendar in APEX?

Next – Navigates to the next month.

Previous – Navigates to the previous month.

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

Reminders – Displays the reminders set by the users

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

Once you create a dynamic action, you cannot add additional true actions.

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

You can execute JavaScript code by creating a dynamic action.

If a client-side condition is defined, the true action will fire when the condition is met, and the false action will fire when it is not

QUESTION 74
Which two Plugin types can be created in Oracle APEX?

Process

Validation

Email Template

Region

QUESTION 75
Choose the two statements that are TRUE about an Interactive Report. As a developer:

You can customize the Actions menu to include or exclude certain options.

You can modify the data in the report after running the app

You can customize the pagination

You cannot modify the report source query

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

Provide a conditional SQL query

Edit the rows in the report and select a color

Rows cannot be highlighted in an Interactive report

Choose a condition in Format > Highlight

QUESTION 77
Which statement is true about creating and using an interactive grid?

For both editable and noneditable interactive grids, end users can change the report layout and create private reports.

An interactive grid supports Pivot View and Group By View features.

End users cannot rearrange columns by dragging and dropping.

QUESTION 78
What three are the result of the following QuickSQL shorthand notation do?
departments /insert 4
name /nn
location
country

Create the departments table with 4 columns

Creates an id column as a primary key

Create the departments table with 3 columns

Inserts 4 rows of random data into the departments table

Leave a Reply Cancel reply