Actual 1z1-770 Exam Recently Updated Questions with Free Demo [Q58-Q82]

4/5 - (2 votes)

Actual 1z1-770 Exam Recently Updated Questions with Free Demo

Free Oracle 1z1-770 Exam Questions Self-Assess Preparation

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

Rendering Tree

Processing

Dynamic Actions

Shared Components

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

The end user can customize the report

The end user cannot create charts

Q60. When you click a Customer Name in the Customers report, the Customer Details form dialog page is displayed. What are the events that occur in this scenario?

Page Processing

Page Rendering

Page rendering and processing

Page compilation

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

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

Q63. Which two actions can you perform using the Object Browser?

Browse database objects of the current schema.

Restore dropped database objects.

Create and run SQL scripts.

Create a lookup table based on a column in the current table.

Export and import SQL scripts.

Q64. Which three statements are TRUE about Search Configuration?

Searches can be based on Local data, APEX Lists, REST Enabled SQL Service, or REST Data Sources.

Search Configuration is a shared component defines the data source to be searched and the way results should be displayed.

One or more Search Configurations can be configured in a Search Page.

Only one Search Configuration can be used in a Search Page.

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

Latitude/Longitude

JSON_OBJECT

GeoJSON

SDO_GEOMETRY

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

Q67. The APEX engine uses which component as a key for tracking each user’s session state?

APEX_USER

APP_USER

HTTP_USER

LDAP_USER

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

Show Page

Run Page

Validate Page

Accept page

Q69. Choose the two correct statements about PWA.

Provides a customizable offline page when users areoffline and cannot request thenetwork.

To download the app as PWA, one must visit the App Store

An existing APEX app cannot be made a PWA

Enables users to install the application on devices

Q70. Which three are the main components of APEX workspace homepage?

Gallery

RESTful Services

SQL Workshop

App Builder

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

Single Pane Mode

Two Pane Mode

Three Pane Mode

Four Pane Mode

Q72. When a table or a SQL query returns many rows, an Interactive Grid is best displayed to the user with pagination. The two types of pagination available are:

Scroll

Page

Page and Scroll

No Pagination

Q73. Which three of the following statements are TRUE about saved Public Interactive Grids?

Public reports are available to all users

To enable an end user to save a public interactive grid, the user must have the required permission

Any user may save public interactive grids

Only the user who creates a public interactive grid can save, rename, or delete it

Q74. Choose from the below options the actions that can be performed when a button is clicked.

Redirect to a page in the same application

All of them

Redirect to a page in a different application

Redirect to a URL

Submit Page

Q75. When you create an Access Control Page, which three of the following Access Roles get created?

Developer

Reader

Administrator

Contributor

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

Q77. Consider a page in an APEX app where the Departments names with location is displayed on the left. Selecting a Department on the left will render details of the employees corresponding to that department on the right. Which kind of report/form is this?

Cards

Stacked Master Detail

Side by Side Master Detail

Interactive Report

Q78. Which component in SQL Workshop allows you to build queries graphically without manual SQLcoding?

Quick SQL

Query Builder

SQL commands

Data Workshop

Q79. What are the three key features of Universal Theme?

Support for single theme

Versatile UI Components