Exam 1Z0-770

For both editable and noneditable interactive grids, end users can change the report layout and create private reports.

An interactive grid supports Pivot View and Group By View features.

End users cannot rearrange columns by dragging and dropping. 

As Primary only 

As Public only

As Private only 

As Private and public only

You can specify an Authorization Scheme at the column level.

You cannot include Form Page when creating an interactive report page using the Create Page Wizard.

You cannot customize the Search Button Label.

You cannot restrict users from saving private reports by using the Authorization Scheme.

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.

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 );

Theme Styles in Oracle APEX determine the layout and structure of a webpage.

When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.

You can only enable the Is Current attribute when the Theme Style has the Read Only attribute disabled.

GET

POST

PUT

The remote server determines the base URL of the REST Data Source. 

The remote server should mandatorily be an APEX instance

Multiple REST Data Sources can reference a single remote server. 

A single REST Data Source can use multiple remote server

To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.

If the local table is not in sync with the Data Profile, Data Synchronization continues to work for columns present in both the table and the Data Profile.

If the local table is not in sync with the Data Profile, Data Synchronization doesn't work.

You cannot trigger Data Synchronization on a regular schedule using a scheduler job.

The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties.

Interactive Report

Column Toggle Report

Classic Report

Interactive Grid

Date Picker 

Range

Checkbox Group

Popup LOV

Faceted Search supports the ability to filter columns storing multiple values as one string

Facets map to specific database columns.

Multiple charts are not visible in the same region

A facet's chart can be seen only in a nonmodal dialog. 

Join me in congratulating :P1 ENAME as the new employee of the month! 

Join me in congratulating &P1_ENAME., as the new employee of the month!

Join me in congratulating v('P1_ENAME') as the new employee of the month! 

Oracle Text

Standard

List

Refreshing the templates

Verifying the theme subscription

Subscribing the copied theme to the master theme and refreshing the theme

Copying the changes made in the master theme to the copied theme

Create join queries using drag and drop.

Generate data definition language (DDL) statements from the Oracle data dictionary

Import previously exported apps.

Create and manage apps. 

Create and manage database objects

Setting the value Required to Yes on P1_SALARY

Removing P1_SALARY from the validation Associated Item

Setting Display Location to Inline in Notification 

Process

Validation

Email Template 

Region

On the remote Oracle Database, install ORDS 19.x or later

REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA

Create a database link to the remote Oracle Database in the local APEX Schema

Install Oracle APEX in the remote Oracle Database

It is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox

It is a page that shows details for a specific task, which can include metadata, history, comments, and actions.

It is a shared component used to configure task parameters, participants, actions, and due dates

Set EMPNO, ENAME to "Display Only"

Ensure that the "Primary Key" switch is turned "On" for the EMPNO column.

In the Interactive Grid attributes, select COMM for "Allowed Row Operations Column".

In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group

Never

Once per session 

Once per page view 

Once per user

Assign roles to users

Create Authorization schemes

Add Users

Create new application roles

Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute. Then, navigate to each facet and in the Property Editor, turn on client-Side Filtering.

Navigate to each facet and then in the Property Editor, turn on client-Side Filtering. 

Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute.

Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute

Setting the on Data Change attribute value to slide to Left

 Setting the Hide and Show Behavior attribute value to Rescale

Setting the Hide and Show Behavior attribute value to None

Setting the Hide and Show Behavior attribute value to No Rescaling 

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. 

The wizards load and unload table data only

You cannot load data from an XLSX file with multiple worksheets.

The wizards load and unload all types of schema objects.

You can load or unload multiple tables at a time. 

If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache. 

The search results report can be displayed as an interactive report

The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types.

The search results report can be displayed as an interactive grid.

A user cannot run multiple instances of an application simultaneously in different browser programs.

APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests

Multiple number of sessions cannot exist in the database at the same time.

HTTP Header Variable

Social Sign-In

SAML Sign-In

Open Door Credentials 

Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination.

In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source).

The Create Application Wizard doesn't support the creation of an interactive report and form combination.

The Create Page Wizard doesn't support the creation of a classic report and form combination

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. 

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.

Application definition is not stored in the database

Processing and data manipulation is not executed in the database

Running an APEX app needs client software. 

APEX eliminates middle-tier application logic.

You can build interactive reporting apps based on data from disparate systems

Side by Side

Drill Down

Stacked

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. 

You can add files as attachments to your emails using the APEX_MAIL package.

You can send emails using the APEX MAIL package from an Oracle APEX application.

The APEX_MAIL package supports sending emails only to Oracle database users. 

You can receive emails using the APEX_MAIL package in an Oracle APEX application.

Database schema credentials

APEX Developer credentials

APEX Workspace Admin credentials

Single Pane Mode

Two Pane Mode

Three Pane Mode

Four Pane Mode

Execute JavaScript Code

Set Value

Send E-Mail

Select List

SQL Query 

Function Returning SQL Query

Procedure

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.

Latitude/Longitude

JSON_OBJECT

GeoJSON

SDO_GEOMETRY

An Invalid column definition error message will be displayed.

create table students ( id number generated by default on null as identity constraint students id pk primary key, name varchar2 (255 char) not null, roll no number ) ; 

create table students ( id number generated by default on null as identity constraint students_id_pk primary key, name varchar2 (255 char), roll_no number ) ; 

It will default to FALSE.

It will restrict acceptable values to TRUE or FALSE.

It will default to TRUE.

It will restrict acceptable values to Y or N. 

Access Control 

Feedback

Search Page

Unified Task List 

Master Detail

Cards

Interactive Grid 

Unified Task List

You can search and filter database objects

You can design and prototype data models using a markdown-like shorthand syntax

In SQL Commands, you can view queries saved in Query Builder

You can unload data from the database

Minimum

list aggregate

Median

List aggregate

Rank

A Link Column cannot be sorted, hidden, or moved by an end user

It is not possible to exclude Link Column.

If you select Link Column, it is always displayed as the last column in the report

It is not possible to include a custom target in Link Column.

You cannot import an APEX application exported from a latest APEX version to an old APEX version.

The import process does not import the supporting objects defined during the export. 

You cannot change the application ID during the import process. 

#APEX.PK_VALUE#, #APEX.NEW START_DATE# and #APEX.NEW_END_DATE#

:APEX$PK_VALUE, APEX$NEW START DATE and APEXSNEW_END_DATE 

:APEX.PK_VALUE, :APEX.NEW START DATE and :APEX.NEW END DATE

#APEXSPK VALUE#, #APEX$NEW START DATE# and #APEXSNEW END DATE#

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

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 schemas cannot be created during workspace creation.

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

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

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