1Z0-770 Practice Dumps – Verified By TestKingIT Updated 144 Questions [Q71-Q93]

By adminOn October 24, 2024

Rate this post

1Z0-770 Practice Dumps – Verified By TestKingIT Updated 144 Questions

Updated 1Z0-770 Exam Dumps – PDF Questions and Testing Engine

NEW QUESTION 71
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.

NEW QUESTION 72
Which of the following are preconfigured authentication schemes?

Open Door Credentials

All of them

LDAP Directory

HTTP Header Variables

Social Sign In

NEW QUESTION 73
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

NEW QUESTION 74
Which two feature pages can you create using the Create Page Wizard?

Access Control

Feedback

Search Page

Unified Task List

NEW QUESTION 75
You have an interactive grid component and you are enabling the Save Public Report attribute. As what can end users save the report type?

As Primary only

As Public only

As Private only

As Private and public only

NEW QUESTION 76
Select the three ways in which you can create a Form in APEX.

Using the Create Page wizard

Using Shared Components

Create a Form region in Page Designer

Using the Create Application Wizard

NEW QUESTION 77
Choose the three correct options in the given friendly URL syntax:
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?

session=13766599855150 Ahr-app is the application alias.

update-employees is the PL/SQL procedure to update the employee details.

mycompany is the path-prefix which is by default the workspace name

13766599855150 is the session ID. A new ID is generated for each session.

NEW QUESTION 78
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

NEW QUESTION 79
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

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

Database schema credentials

PEX Developer credentials

APEX Workspace Admin credentials

NEW QUESTION 81
You must create a single master detail page where users can select a row in the master grid to update the detail grids.
Users must also interact with the master or the detail without leaving the page.
Which type of master detail implementation should you use?

Side by Side

Drill Down

Stacked

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

Process

Validation

Email Template

Region

NEW QUESTION 83
While migrating apps, once the database objects are created in the target environment, you canload the data using which of the components?

Data Workshop

Data Generator

App Builder

Quick SQL

NEW QUESTION 84
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.

NEW QUESTION 85
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

NEW QUESTION 86
Which two types of pages behave similarly in functionality?

Map

Cards

Faceted Search

Smart Filter

NEW QUESTION 87
Which two statements are true about a Progressive Web Application (PWA)?

To use the PWA feature, the Friendly URLS attribute in the Application Definition, Properties section must be turned Off.

Enabling the PWA functionality optimizes page loading speed on a mobile device.

Enabling the PWA functionality in your APEX app adds a new navigation bar entry named Install App to your app.

PWA features will be rendered even if the application is served in an unsecured environment.

You can create a PWA only when creating a new application with the Create Application Wizard.

NEW QUESTION 88
Choose the three Form types that you can create using the Create Page wizard.

Interactive Grid

Interactive Report

Form

Master Detail

NEW QUESTION 89
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 );

NEW QUESTION 90
Using the App Builder component, you can perform which three tasks?

Edit pages in the page designer

Run SQL scripts and commands

Install a sample App

Create a new App

NEW QUESTION 91
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

NEW QUESTION 92
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

NEW QUESTION 93
Select the two advantages of using One-click Remote Deployment.

You need to access your production environment to import the app directly.

Deploy the app, and explicitly install the supporting objects in one-click.

Directly deploy your app definition along with the objects from the source system to the target system

Simplify the process of deploying an application

New (2024) Oracle 1Z0-770 Exam Dumps: https://www.testkingit.com/Oracle/latest-1Z0-770-exam-dumps.html

1Z0-770 Practice Dumps – Verified By TestKingIT Updated 144 Questions [Q71-Q93]

Leave a Reply Cancel reply