1Z0-770 Dumps PDF 2024 Strategy Your Preparation Efficiently [Q30-Q49]

Rate this post

1Z0-770 Dumps PDF 2024 Strategy Your Preparation Efficiently

Latest Verified & Correct Oracle 1Z0-770 Questions

QUESTION 30
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.

QUESTION 31
You can create an APEX workspace and build APEX apps on which of the following platforms?

Oracle Autonomous Cloud

Oracle XE

Amazon RDS

Microsoft Azure

All of the above

QUESTION 32
In APEX, you can choose which three of the following Authentication methods?

Custom Authentication Scheme

No Authentication

Built-in Authentication Scheme

Authorization Scheme

QUESTION 33
Plug-ins can be used declaratively in which of the following components in APEX?

Dynamic Actions

Regions

Items

Process Type

All of them

QUESTION 34
To create a Dynamic Action, you need to specify which three of the following options?

What action or actions are performed

When the action occurs

What elements are affected by the action

Why the action is performed

QUESTION 35
Which search type in Search Configurations provides linguistic and fuzzy search capabilities?

Oracle Text

Standard

List

QUESTION 36
An application includes a report and form on the PRODUCTS table.
The form page includes page items P21 PRODUCT NAME and P21_UNIT_PRICE.
P21_UNIT_PRICE is currently displayed below P21_PRODUCT_NAME.
Now, you need to reposition the items and display P21 UNIT_PRICE next to P21_PRODUCT_NAME.
Which two statements are true?

In Page Designer, select P21_PRODUCT_NAME and then in the Property Editor, under Layout set Start New Row to Yes.

In Page Designer, use the Middle Pane, click P21 UNIT PRICE and drag the item until it is directly next to P21 PRODUCT_NAME.

In Page Designer, select P21_UNIT_PRICE and then in the Property Editor, under Layout set Start New Row to Yes.

In Page Designer, right-click P21_UNIT_PRICE and select Start New Row.

QUESTION 37
Choose the statement that is TRUE about Universal Theme.

Features a responsive design and enables developers to create web applications without extensive knowledge of HTML, CSS, or JavaScript

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

All of them

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

QUESTION 38
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.

QUESTION 39
What three are the uses of Collections in APEX?

You insert, update, and delete collection information using PL/SQL APIAPEX_COLLECTION.

Use collections to temporarily capture one or more nonscalar Values.

Collections enable you to store rows and columns in the current session into database tables

Collections can be accessed, manipulated, or processed during a user’s specific session.

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

QUESTION 41
Which is a valid Page Process type?

Execute JavaScript Code

Set Value

Send E-Mail

QUESTION 42
What three are the building blocks of Approvals Component?

Task Details Page

Automations

Task Definition

Unified Task List

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

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

Static LOV

Cascading LOV

Dynamic LOV

Popup LOV

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

APEX_USER

APP_USER

HTTP_USER

LDAP_USER

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

Particpants

All of them

Task Settings

Parameters

Actions

QUESTION 47
Which is a valid method of logging messages to the execution log in APEX automation?

apex_debug.info (‘SAL for ‘ || :ENAME || ‘ increased by 1%.’);

apex_automation.log_info(‘SAL for || :ENAME || increased by 18.’);

apex error.add error ( p_message => ‘SAL for || :ENAME || increased by 1%.’, p_display_location => apex_error.c_inline_in_notification );

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

Help Page

Modal Dialog

Normal Page

Non-Modal Dialog

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