Get Oracle 1Z0-770 Exam Dumps

Answer : B

Custom Apps are specific to your workspace and are only available if your instance administrator has enabled them. You can install Sample Apps and Starter Apps directly from the Gallery or download them from GitHub. Sample Apps and Starter Apps are available with every Oracle APEX workspace. References:Using the App GalleryandConfiguring the Application Gallery

Answer : 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.

Answer : 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.

Answer : 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.

Answer : 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.