Decide Fast & Get 50% Flat Discount | Limited Time Offer - Ends In 0d 00h 00m 00s Coupon code: SAVE50

Master Oracle 1Z0-770 Exam with Reliable Practice Questions

Page: 1 out of Viewing questions 1-5 out of 142 questions
Last exam update: Nov 18,2024
Upgrade to Premium
Question 1

Select the two places from where you can access the Shared Components Page?


Correct : B, C

You can access the Shared Components page from two places in App Builder: the Page Designer and the Application home page.In Page Designer, you can click on the Shared Components icon at the top of the page to open the Shared Components page in a new tab5.In the Application home page, you can click on the Shared Components link in the center of the page to navigate to the Shared Components page6. Gallery, SQL Workshop, and other pages do not have direct links to the Shared Components page.


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Question 2

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


Correct : B

Task definitions that exist on the application level in the Shared Components section are made up of all of the following: Participants, Task Settings, Parameters, and Actions.Task definitions are used to define approval workflows for data changes in interactive grids or forms5. Participants are the users or groups who can approve or reject tasks. Task Settings are the properties that control how tasks are created, assigned, and completed. Parameters are the variables that store information about tasks or data changes.Actions are the PL/SQL code blocks that execute when tasks are created, updated, or completed5.


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Question 3

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


Correct : A, B, C

Data Synchronization enables developers to automatically sync the contents of a local table with the data from a REST service.APEX invokes the REST service defined in the REST Data Source, downloads all data and synchronizes it to a local table6. Data Synchronization has several benefits, such as:

APEX can create the local table based on the visible columns in the REST Data Source Data Profile.Since the table is physically available in the database schema, developers can add indexes, change physical properties, or even add more columns6.

Data Synchronization helps in providing efficient reporting on large data sets coming from a REST service. Some REST services can return large amounts of result data that include pagination. If a reporting requirement needs larger data sets, this would lead to multiple HTTP requests and poorer response times. Also, no indexes or other database features can be used to speed up reporting queries.In this case, synchronizing the remote data to a local table and having the reports working on local tables can improve performance and user experience6.

Data Synchronization can also collect data from REST services for consumption by PL/SQL packages or other logic.If data from the REST service is replicated to local tables, developers will be able to perform all sorts of processing and also generate different types of reports6.

You do not have to trigger Data Synchronization manually, as you can also schedule it to run periodically using a DBMS_SCHEDULER expression6.


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Question 4

Choose the three requirements for creating a REST Enabled SQL Reference.


Correct : A, B, D

To create a REST Enabled SQL Reference, you need to meet the following requirements:

Install Oracle REST Data Services (ORDS) 19.x or later.ORDS is a Java application that enables developers to create, publish, and manage RESTful web services for Oracle databases1.

Activate REST Enabled SQL for the target schema on the remote database. REST Enabled SQL is a feature of ORDS that allows you to execute any SQL or PL/SQL through a REST endpoint.You need to enable this feature for the schema that contains the data you want to access2.

Configure and enable the REST Enabled SQL service feature. This is a workspace-level setting that allows you to use REST Enabled SQL references in your APEX applications.You need to specify a path prefix and a secret for the REST Enabled SQL service3.

You do not need to set up any remote database, as long as it meets the ORDS and REST Enabled SQL requirements.You can use any Oracle database or MySQL database as a remote data source2.


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500
Question 5

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


Correct : B, C, D

When you create an Access Control Page using the Create Page Wizard, three of the following Access Roles get created: Reader, Administrator, and Contributor.These roles are predefined by APEX and correspond to the authorization schemes that control the access to the application, pages, or page components1. Reader role grants read-only access to the application. Administrator role grants full access to the application, including administrative and edit privileges.Contributor role grants edit privileges to the application, but not administrative privileges2. Developer role is not a default Access Role created by the wizard, but you can create your own custom roles and assign them to users on the Application Access Control page.


Options Selected by Other Users:
Mark Question:

Start a Discussions

Submit Your Answer:
0 / 1500