Free Oracle 1Z0-770 Exam Actual Questions

The questions for 1Z0-770 were last updated On Jan 17, 2025

Question No. 1

Which three statements are TRUE about Shared Components?

Show Answer Hide Answer
Question No. 2

Which two types of pages behave similarly in functionality?

Show Answer Hide Answer
Correct Answer: C, D

A Faceted Search and a Smart Filter are two types of pages that behave similarly in functionality. They both allow users to filter data based on multiple criteria and see the results in real time. They differ in the following aspects:

A Faceted Search uses facets to filter data. A facet is a set of filters based on a column or expression. A facet can be displayed as a list, a range slider, a star rating, or a chart.

A Smart Filter uses conditions to filter data. A condition is a logical expression that evaluates to true or false. A condition can be based on a column, an item, or a function.

The other options are incorrect because:

A Map is a type of region that displays spatial data on an interactive map. It allows users to zoom, pan, and select features on the map.

A Cards is a type of region that displays data in a grid of cards. Each card represents one row of data and can contain text, images, icons, or buttons.

Verified References: [About Faceted Search] [About Smart Filter] [About Maps] [About Cards]


Question No. 3

Which statement is true about Unified Task List in the Approvals component?

Show Answer Hide Answer
Correct Answer: A

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]


Question No. 4

What are the three types of Master Detail Form you can create in APEX?

Show Answer Hide Answer
Correct Answer: B, C, D

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.


Question No. 5

In a faceted search page, facets can be displayed as different UI types. Which two facet item types are supported in the faceted search region?

Show Answer Hide Answer
Correct Answer: B, C

In a faceted search page, facets can be displayed as different UI types depending on the data type and cardinality of the facet column or expression. The facet item types are the UI components that are used to render the facets in the faceted search region. The supported facet item types are Range, Checkbox Group, Radio Group, List, Star Rating, and Switch. Date Picker and Popup LOV are not valid facet item types. Verified References: [Faceted Search Attributes - Oracle Help Center], [Facet Item Types - Oracle APEX]