[Dec 28, 2023] Pass Oracle 1Z0-770 Exam Info and Free Practice Test [Q37-Q59]

Rate this post

[Dec 28, 2023] Pass Oracle 1Z0-770 Exam Info and Free Practice Test

1Z0-770 Exam Dumps PDF Updated Dump from Test4Cram Guaranteed Success

NO.37 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.

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

Create a report as a new page in an application

Create a report when you create a new database application

Create a report from Object Browser

Create a report region on a page in an application

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

Quick SQL

Query Builder

SQL commands

Data Workshop

NO.40 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

NO.41 Which two of the following capabilities are TRUE for both Interactive Report and Interactive Grid?

End user can rearrange the report interactively using the mouse.

End user can add, modify, and refresh data directly on the report.

End user can save the report

End user can customize how and what data is displayed.

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

Gallery

RESTful Services

SQL Workshop

App Builder

NO.43 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

NO.44 Choose the three Form types that you can create using the Create Page wizard.

Interactive Grid

Interactive Report

Form

Master Detail

NO.45 An Employees App includes a form to enter and update employee details.
Examine this Exhibit.
Now you must extend the functionality of this form so that:
* If you select ‘SALESMAN’ from the select list for Job page item (P2_JOB), both the ‘Hire date’ (P2_HIREDATE) and ‘Commission’ (P2_COMM) page items and their associated labels are displayed
* If you select any other value from the select list for Job page item (P2_JOB), both the ‘Hire date’ (P2_HIREDATE) and ‘Commission’ (P2_COMM) page items and their associated labels are hidden Which two steps must be performed?

Create a dynamic action on form load.

Create a dynamic action on P2_JOB, P2_HIREDATE, and P2_COMM.

Create a dynamic action on P2_JOB.

Create a dynamic action on P2_HIREDATE and P2_COMM.

……… and enter SALESMAN for Value.

NO.46 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.

NO.47 What three are the building blocks of Approvals Component?

Task Details Page

Automations

Task Definition

Unified Task List

NO.48 Which is a valid Page Process type?

Execute JavaScript Code

Set Value

Send E-Mail

NO.49 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.

NO.50 Which two statements are true about loading data from the “Create an Application From a File” wizard?

Seed data from a SQL script can be uploaded.

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

XML and JSON data can be pasted and loaded.

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

Data from remote web services can be uploaded.

NO.51 Which two statements are true about REST Data Sources?

AREST Data Source can contain one or many Operations which are the references toa concrete external web service

Oracle APEX doesn’t provide direct integration of REST Data Sources in interactivereports

Oracle APEX supports the REST Enabled SQL Query REST Data Source type

REST Data Sources doesn’t support any authentication

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

New schemas cannot be created during workspace creation.

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

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

A workspace can be associated with only one schema.

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

NO.53 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

NO.54 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

NO.55 You can apply an authorization scheme for which three of the following components?

Specific control such as region,item or button

A page

A session

An entire application

NO.56 Which two statements are true about the generated SQL?

Creates DEPARTMENTS table with 2 columns

Inserts 10 rows of random sample data into the DEPARTMENTS table

Creates EMPLOYEES table with 4 columns

Both DEPARTMENTS and EMPLOYEES tables will have a primary key in each and a foreign key relationship linking EMPLOYEES to DEPARTMENTS.

NO.57 What are the required fields while creating a Chart in APEX?

All of them

Data Source

Value Column

Name

Label Column

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

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

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

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

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

NO.59 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

Pass Your Oracle Exam with 1Z0-770 Exam Dumps: https://www.test4cram.com/1Z0-770_real-exam-dumps.html

Leave a Reply Cancel reply