Check Real Oracle 1Z0-770 Exam Question for Free (2026) [Q58-Q79]

Check Real Oracle 1Z0-770 Exam Question for Free (2026)

Get Ready to Boost your Prepare for your 1Z0-770 Exam with 144 Questions

NEW QUESTION # 58
Choose the two correct statements about PWA.

• A. Provides a customizable offline page when users areoffline and cannot request thenetwork.
• B. Enables users to install the application on devices
• C. To download the app as PWA, one must visit the App Store
• D. An existing APEX app cannot be made a PWA

Answer: A,B

NEW QUESTION # 59
Which two are true about Oracle APEX?

• A. Is declarative. It requires no code generation.
• B. Performs the data processing in a middle-tier server
• C. Requires no additional client software. A web browser is the app development IDE.
• D. Requires developers to be proficient in Java, Python and other programming languages.

Answer: A,C

Explanation:
Explanation
Oracle APEX is a low-code development platform that enables you to build database-centric web applications using only a web browser. Oracle APEX has the following features:
Requires no additional client software. A web browser is the app development IDE: You can use any modern web browser to access the Oracle APEX development environment and build your applications.
You do not need to install or configure any additional software or tools on your client machine.
Is declarative. It requires no code generation: You can use declarative tools, visual editors, drag-and-drop components, and pre-built templates to define your application logic, user interface, security, and integration features. You do not need to write or generate any code for your applications.
The other options are incorrect because:
Performs the data processing in a middle-tier server: Oracle APEX performs the data processing in the database server. It uses SQL and PL/SQL to access and manipulate the data stored in the database. It does not rely on any middle-tier server or framework for data processing.
Requires developers to be proficient in Java, Python and other programming languages: Oracle APEX does not require developers to be proficient in Java, Python or other programming languages. It uses SQL and PL/SQL as the primarylanguages for data processing. It also supports HTML, CSS, JavaScript, and jQuery for user interface development.
Verified References: [About Oracle APEX] [Oracle APEX Architecture]

NEW QUESTION # 60
Which statement is true about the Approvals component?

• A. Unified Task List is a shared component used to configure task parameters,participants, actions, and due dates.
• B. APEX_APPROVAL is Page processes that create andact on task instances in yourpages.
• C. Task Definition is a page that shows details for a specific task, which can include metadata, history, comments, and actions.
• D. You can set up task approvers and administrators at design time or determine themdynamically at runtime based on data related to the task.

Answer: D

Explanation:
Explanation
The Approvals Component is a feature in Oracle APEX that enables you to create and manage tasks for user approval. The Approvals Component deals with all aspects of human approval in Oracle APEX, allowing you to put approval functionality into your applications. The Approvals Component creates one or more tasks for items that require approval based on a pre-configured template, known as the Task Definition. The Task Definition specifies the data source, display attributes, potential owners, business administrators, and available actions for the tasks. You can set up task approvers and administrators at design time or determine them dynamically at runtime based on data related to the task. For example, you can use a SQL query or a PL/SQL function to return the list of potential owners or business administrators for each task based on some criteria, such as department, role, or location.

NEW QUESTION # 61
Developers can use Template Options in which of the following ways?

• A. Applying different spacing and padding
• B. Displaying form fields with different alignments
• C. Rendering buttons in different styles, with and without icons
• D. All of them
• E. Applying different colors or accents

Answer: D

Explanation:
Explanation
Template options provide developers with a declarative approach to applying different styles to components on an Oracle APEX page. Developers can use template options to declaratively apply CSS modifiers to the templates they have chosen for pages, regions, reports, lists, breadcrumbs, items and buttons. Developers can use template options in all of the following ways:
Applying different colors or accents. Developers can use template options to change the color scheme or accent color of components, such as buttons, lists, or regions.
Rendering buttons in different styles, with and without icons. Developers can use template options to change the shape, size, style, and icon of buttons on a page.
Applying different spacing and padding. Developers can use template options to adjust the spacing and padding of components, such as regions, items, or reports.
Displaying form fields with different alignments. Developers can use template options to change the alignment of form fields and labels, such as left-aligned, right-aligned, or top-aligned.

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

• A. Process Type
• B. All of them
• C. Dynamic Actions
• D. Regions
• E. Items

Answer: B

Explanation:
Explanation
Plug-ins can be used declaratively in all of the following components in APEX: Dynamic Actions, Regions, Items, Process Type, and Authentication and Authorization Schemes. Plug-ins are shared components that enable developers to extend the native functionality of APEX with custom components1. Plug-ins can be created or imported from the Shared Components page or the App Gallery1.

NEW QUESTION # 63
What are the three types of Master Detail Form you can create in APEX?

• A. One Below the other
• B. Stacked
• C. Two Page Drill Down
• D. Side by Side

Answer: B,C,D

Explanation:
Explanation
A master detail form is a type of form that enables users to query, insert, update, and delete values from two related tables or views. A master detail form reflects a one-to-many relationship between tables in a database.
Typically, a master detail form displays a master row and multiple detail rows. In APEX, you can create three types of master detail forms using the Create Page Wizard or the Create Application Wizard:
Stacked: A stacked master detail form contains a single page with editable interactive grids based on two related tables or views. Users select a row in the master grid to update the detail grid. Developers can create a stacked master detail with either the Create Application Wizard or the Create Page Wizard.
Side by Side: A side by side master detail form contains a single page with two editable interactive grids based on two related tables or views. Users can see and edit both the master and detail grids at the same time. Developers can create a side by side master detail with either the Create Application Wizard or the Create Page Wizard.
Two Page Drill Down: A two page drill down master detail form contains two pages based on two related tables or views. The first page is a non-editable interactive grid for the master table. Users click the Edit icon on the first page to edit details on the second page. The second page includes both a standard form for the master and an editable interactive grid for the detail. Developers can create a two page drill down master detail with only the Create Page Wizard.

NEW QUESTION # 64
The Page Designer Toolbar allows you to perform which two of the following actions?

• A. Navigate to Shared Components
• B. Create a new page
• C. Delete the application
• D. Export the application

Answer: A,B

Explanation:
Explanation
The Page Designer Toolbar allows you to perform various actions related to the development of an APEX page. Two of the actions that you can perform are:
Navigate to Shared Components: This option lets you access the shared components of your application, such as lists, breadcrumbs, navigation menus, and so on. You can edit, create, or delete shared components from this option. To access this option, click the icon that resembles a puzzle piece on the Page Designer Toolbar.
Create a new page: This option lets you create a new page for your application using the Create Page Wizard. You can choose from different page types, such as blank page, form, report, chart, calendar, and so on. To access this option, click the icon that resembles a plus sign (+) on the Page Designer Toolbar.

NEW QUESTION # 65
Which statement is true about importing an APEX application?

• A. You cannot change the application ID during the import process.
• B. You cannot import an APEX application exported from a latest APEX version to an old APEX version.
• C. The import process does not import the supporting objects defined during the export.

Answer: B

Explanation:
Explanation
As a general rule, you cannot import an application created in a newer release of APEX into an earlier version.
This is because the newer release may have features or attributes that are not supported or recognized by the older version. For example, you cannot import an application created in APEX 21.2 into APEX 19.2.
However, you can import an application created in an older release into a newer one, as long as the application is compatible with the newer release. For example, you can import an application created in APEX 18.2 into APEX 21.2, but you may need to upgrade or modify some components to use the latest features.

NEW QUESTION # 66
Which two statements are true about creating and using an interactive report?

• A. You cannot restrict users from saving private reports by using the Authorization Scheme.
• B. You cannot include Form Page when creating an interactive report page using the Create Page Wizard.
• C. You can specify an Authorization Scheme at the column level.
• D. You cannot customize the Search Button Label.

Answer: C,D

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

• A. APEX Workspace Admin credentials
• B. Database schema credentials
• C. PEX Developer credentials

Answer: A

Explanation:
Explanation
The One-Click Remote Application Deployment feature in Oracle APEX enables developers to deploy an application along with supporting object definitions to another workspace or to remote Oracle APEX instances. To use this feature, you need to provide the client credentials for authentication during the deployment process. The client credentials are utilized for authentication during the One-Click Remote Application Deployment process are the APEX Workspace Admin credentials. You can either specify an existing credential or create a new credential when you create a REST Enabled SQL reference in Shared Components. Optionally, you can create the credentials as empty credentials to prompt for client ID and client secret each time the REST Enabled SQL reference is used. Verified References: [Understanding One-Click Remote Application Deployment - Oracle Help Center], [Remote Deployment of your APEX App is just One Click Away! - Oracle Blogs]

NEW QUESTION # 68
Which authentication scheme type supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards?

• A. SAML Sign-In
• B. Open Door Credentials
• C. HTTP Header Variable
• D. Social Sign-In

Answer: D

Explanation:
Explanation
An authentication scheme is a rule that determines if a user is authorized to access a specific component or feature of an application, such as a page, region, button, item, etc. An authentication scheme type defines how users are authenticated when they access an application. The authentication scheme type that supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards is Social Sign-In. Social Sign-In supports authentication with Google, Facebook, and other social networks that support these standards. The other authentication scheme types do not support authentication with social networks or enterprise identity providers. They are:
HTTP Header Variable: Authenticate users externally by storing the username in a HTTP Header variable set by the web server.
SAML Sign-In: Delegates authentication to the Security Assertion Markup Language (SAML) Sign In authentication scheme.
Open Door Credentials: Enable anyone to access your application using a built-in login page that captures a user name. Verified References: [Understanding Preconfigured Authentication Schemes - Oracle Help Center], [Social Sign-In - Oracle Help Center]

NEW QUESTION # 69
Which two functions can be used by an end user when pivoting an interactive report?

• A. List aggregate
• B. Minimum
• C. Rank
• D. Median
• E. list aggregate

Answer: B,C

Explanation:
Explanation
When pivoting an interactive report, you can use different functions to aggregate or summarize the data in the pivot table. Some of the available functions are Minimum, Maximum, Average, Sum, Count, Median, and Rank. Minimum returns the smallest value in a set of values. Rank returns the rank of each value in a group of values. Verified References: 56

NEW QUESTION # 70
Which two layout options are available for Page Designer under Utilities?

• A. Two Pane Mode
• B. Three Pane Mode
• C. Four Pane Mode
• D. Single Pane Mode

Answer: A,D

Explanation:
Explanation
Page Designer is a tool that allows developers to create and edit pages in Oracle APEX using a graphical user interface. Page Designer has three main panes: Rendering, Processing, and Property Editor. You can change the layout of Page Designer under Utilities by selecting one of the following options:
Single Pane Mode - This option displays only one pane at a time. You can switch between the Rendering, Processing, and Property Editor panes by using the buttons on the toolbar or the keyboard shortcuts.
Two Pane Mode - This option displays two panes side by side. You can choose which panes to display by using the buttons on the toolbar or the keyboard shortcuts. You can also resize the panes by dragging the splitter bar between them. There is no Three Pane Mode or Four Pane Mode option for Page Designer layout. Verified References: [Managing Pages in Page Designer - Oracle Help Center], [Page Designer Layout Options - Oracle Help Center]

NEW QUESTION # 71
From SQL Workshop, you can perform which two of the following actions?

• A. Delete database
• B. Create an APEX user
• C. Create and view database objects
• D. Run SQL commands and scripts

Answer: C,D

Explanation:
Explanation
From SQL Workshop, you can perform the following actions:
Run SQL commands and scripts: You can use SQL Commands or SQL Scripts components to run individual SQL statements or PL/SQL blocks interactively or in batch mode. You can also view the results, errors, or explain plans of your commands or scripts.
Create and view database objects: You can use Object Browser component to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can also use this component to create new objects, modify existing objects, drop objects, or run object reports.
The other options are incorrect because:
Create an APEX user: You cannot use SQL Workshop to create an APEX user. You can use Workspace Administration component to create and manage users in your workspace.
Delete database: You cannot use SQL Workshop to delete database. You can only delete database objects such as tables or views from your schema.
Verified References: [About SQL Workshop] [Using SQL Commands] [Using SQL Scripts] [Using Object Browser] [Managing Workspace Users]

NEW QUESTION # 72
Which statement is true about Unified Task List in the Approvals component?

• A. It is a page that shows details for a specific task, which can include metadata, history, comments, and actions.
• B. It is a shared component used to configure task parameters, participants, actions, and due dates.
• C. It is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox.

Answer: C

Explanation:
Explanation
The Approvals component in Oracle APEX is a feature that allows developers to create approval workflows for business processes that require human intervention or decision making. The Approvals component consists of three main elements: Tasks, Task List Page, and Task Details Page. The Unified Task List is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox for end users.
The Unified Task List displays all tasks assigned to or created by an end user along with their status, priority, due date, etc. End users can filter, sort, search, view details, and perform actions on tasks from this page.
Verified References: [Using Approvals - Oracle Help Center], [Creating a Unified Task List Page - Oracle Help Center]

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

• A. Create a dynamic action on P2_JOB, P2_HIREDATE, and P2_COMM.
• B. Create a dynamic action on P2_JOB.
• C. ......... and enter SALESMAN for Value.
• D. Create a dynamic action on form load.
• E. Create a dynamic action on P2_HIREDATE and P2_COMM.

Answer: B,C

Explanation:
Explanation
To extend the functionality of the form as required, you need to create a dynamic action on P2_JOB that shows or hides P2_HIREDATE and P2_COMM based on its value. The steps are as follows:
Create a dynamic action on P2_JOB by right-clicking it in Page Designer and selecting Create Dynamic Action.
Set Name to Show/Hide Hire Date and Commission.
Set Event to Change.
Set Selection Type to Item(s).
Set Item(s) to P2_JOB.
Set Condition Type to Equal To.
Set Value to SALESMAN.
Add two true actions by clicking the Add True Action button twice.
For the first true action, set Action to Show.
Set Affected Elements > Selection Type to Item(s).
Set Affected Elements > Item(s) to P2_HIREDATE,P2_COMM.
For the second true action, set Action to Show.
Set Fire On Initialization to Yes.
Set Affected Elements > Selection Type to jQuery Selector.
Set Affected Elements > jQuery Selector to label[for="P2_HIREDATE"],label[for="P2_COMM"].
Add two false actions by clicking the Add False Action button twice.
For the first false action, set Action to Hide.
Set Affected Elements > Selection Type to Item(s).
Set Affected Elements > Item(s) to P2_HIREDATE,P2_COMM.
For the second false action, set Action to Hide.
Set Fire On Initialization to Yes.
Set Affected Elements > Selection Type to jQuery Selector.
Set Affected Elements > jQuery Selector to label[for="P2_HIREDATE"],label[for="P2_COMM"].
This dynamic action will show or hide both the page items and their labels depending on whether P2_JOB is equal to SALESMAN or not. Verified References: [Creating a Dynamic Action in Oracle Apex - OrclQA.Com], [Managing Dynamic Actions - Oracle Help Center]

NEW QUESTION # 74
In APEX, you can choose which three of the following Authentication methods?

• A. Custom Authentication Scheme
• B. Authorization Scheme
• C. Built-in Authentication Scheme
• D. No Authentication

Answer: A,C,D

Explanation:
Explanation
In Oracle APEX, you can choose from different authentication methods to establish a user's identity and control access to your application. Authentication may require a user to provide some type of credentials, such as a user name and password, or could involve the use of digital certificates or a secure key. Three of the authentication methods that you can choose in Oracle APEX are:
Custom Authentication Scheme: This method allows you to create your own authentication logic using PL/SQL code or an external web service. You can also customize the login page and session management for your application.
No Authentication (using DAD): This method adopts the current database user as the authenticated user.
This approach can be used in combination with a mod_plsql Database Access Descriptor (DAD) configuration that uses basic authentication to set the database session user.
Built-in Authentication Scheme: This method allows you to use one of the preconfigured authentication schemes that ship with Oracle APEX, such as Open Door Credentials, LDAP Directory, Social Sign-In, and so on.

NEW QUESTION # 75
Which two of the following types can an end user save the customized Interactive report as?

• A. Cannot save the report
• B. A private report
• C. Default report
• D. A Public report

Answer: B,D

NEW QUESTION # 76
Which two statements are true about creating and customizing Smart Filters pages?

• A. The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types.
• B. The search results report can be displayed as an interactive grid
• C. If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache.
• D. The search results report can be displayed as an interactive report.

Answer: A,C

Explanation:
Explanation
Smart Filters is a component that allows end users to filter data by typing keywords in a single search field.
Some of the statements that are true about creating and customizing Smart Filters pages are:
If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache. You can also manually add or remove filters as needed.
The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types. For other filter types, such as Input or Range, the count is not displayed. The search results report cannot be displayed as an interactive report or an interactive grid. The supported report types are Classic Report, Cards, Map, or Calendar. Verified References: [Managing Smart Filters - Oracle Help Center],
[Creating Smart Filters Using the Create Page Wizard - Oracle Help Center]

NEW QUESTION # 77
Which statement is true about the Data Workshop utility?

• A. The wizards load and unload table data only.
• B. The wizards load and unload all types of schema objects.
• C. You can load or unload multiple tables at a time.
• D. You cannot load data from an XLSX file with multiple worksheets.

Answer: A

Explanation:
Explanation
Data Workshop is a utility in SQL Workshop that enables developers to load and unload data to and from the database. The wizards load and unload table data only. They do not load or unload other kinds of schema objects. You can load data from an XLSX file with multiple worksheets by selecting the worksheet name in the Load Data Wizard. You can load or unload only a single table at a time using the wizards. Verified References: [Using Data Workshop - Oracle Help Center], [Loading Data - Oracle Help Center]

NEW QUESTION # 78
The Movies faceted search report is filtered only when the Apply button for a selected facet is clicked. What must be done in the Page Designer so that report filtering is automatically executed when any facet value changes?

• A. Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute.
• B. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute
• C. 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.
• D. Navigate to each facet and then in the Property Editor, turn on client-Side Filtering.

Answer: B

Explanation:
Explanation
A faceted search page is a type of page that allows end users to filter data by applying one or more facets. A facet is a set of filters based on a column or expression. By default, when end users select a facet value, they need to click on an Apply button for that facet to apply the filter to the report. To make report filtering automatically executed when any facet value changes, you need to navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute. The Batch Facet Changes attribute determines whether end users need to click on an Apply button for each facet or not. When this attribute is disabled, the report is automatically refreshed when any facet value changes. The other options are not relevant to the report filtering behavior. Verified References: [Faceted Search Attributes - Oracle Help Center], [Batch Facet Changes - Oracle APEX]

NEW QUESTION # 79
......

Use Free 1Z0-770 Exam Questions that Stimulates Actual EXAM : https://www.freepdfdump.top/1Z0-770-valid-torrent.html

Get 100% Real 1Z0-770 Free Online Practice Test: https://drive.google.com/open?id=1hAQsH2JalFnk0S20AnmR-9yxkTJ1xLkp