Download 1Z0-770 Dumps (2024) - Free PDF Exam Demo [Q74-Q97]

Download 1Z0-770 Dumps (2024) - Free PDF Exam Demo

Enhance your career with 1Z0-770 PDF Dumps - True Oracle Exam Questions

To become an Oracle APEX Developer Professional, you need to pass the 1Z0-770 certification exam. 1Z0-770 exam consists of 60 multiple-choice questions that you need to answer in 105 minutes. 1Z0-770 exam is available in multiple languages, including English, Japanese, and Chinese. 1Z0-770 exam fee is $245, and you can take it either at a Pearson VUE testing center or online from your home or office. 1Z0-770 exam is a valuable credential for developers, architects, and consultants who work with Oracle APEX and want to demonstrate their expertise in this technology.

 

NEW QUESTION # 74
Which two statements that are TRUE about charts in Interactive grid?

• A. You can create multiple charts at a time in an interactive grid
• B. Once a chart is created, you can switch the view between Grid and Chart view.
• C. Once the chart is created, it cannot be reconfigured.
• D. To remove a chart, click the Remove Chart icon (X) adjacent to the chart filter

Answer: B,D

Explanation:
Explanation
You can create a chart in an interactive grid by selecting Chart in the Actions menu. You can only create one chart at a time in an interactive grid. To create a second chart, you have to reconfigure or delete the existing chart1. To remove a chart, you can click the Remove Chart icon (X) adjacent to the chart filter12. Once a chart is created, you can switch the view between Grid and Chart by clicking the toggle that appears at the top of the interactive grid

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

• A. It is a shared component used to configure task parameters, participants, actions, and due dates.
• B. It is a page that shows details for a specific task, which can include metadata, history, comments, and actions.
• 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 # 76
From SQL Workshop, you can perform which two of the following actions?

• A. Create an APEX user
• B. Delete database
• 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 # 77
What are Task definitions that exist on the application level inthe Shared Components section made up of?

• A. All of them
• B. Particpants
• C. Parameters
• D. Task Settings
• E. Actions

Answer: A

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

NEW QUESTION # 78
Which is a valid method of logging messages to the execution log in APEX automation?

• A. apex_automation.log_info('SAL for || :ENAME || increased by 18.');
• B. apex error.add error ( p_message => 'SAL for || :ENAME || increased by 1%.', p_display_location => apex_error.c_inline_in_notification );
• C. apex_debug.info ('SAL for ' || :ENAME || ' increased by 1%.');

Answer: C

Explanation:
Explanation
APEX automation is a feature that allows you to automate tasks such as data loading, data synchronization, application export and import, and REST API calls by using declarative actions or PL/SQL code blocks. You can create automation tasks by using the Database Actions interface or by using the APEX_AUTOMATION package. To log messages to the execution log in APEX automation, you can use the APEX_DEBUG package with any of its logging levels (info, warning, error, etc.). The other options are not valid methods of logging messages in APEX automation. Verified References: [Using APEX Automation - Oracle Help Center],
[APEX_DEBUG - Oracle Help Center]

NEW QUESTION # 79
Which two statements are true about the Create Application Wizard?

• A. It allows application pages to be reordered.
• B. It allows the uploading of JavaScript or CSS files required for an application.
• C. It allows the application authorization to be changed
• D. It allows application pages to be added or deleted.

Answer: A,D

Explanation:
Explanation
The Create Application Wizard is a tool that allows developers to create a new application by following a series of steps. Some of the actions that you can perform using the Create Application Wizard are:
Reorder application pages. You can use the Reorder Pages option in the Pages step to change the order of the pages in your application by dragging and dropping them.
Add or delete application pages. You can use the Add Page or Delete Page options in the Pages step to add new pages or delete existing pages from your application. You can also use the Create Page Wizard to create additional pages after creating the application. You cannot upload JavaScript or CSS files required for an application or change the application authorization using the Create Application Wizard.
You can use other features in App Builder to perform these actions, such as Shared Components > User Interface > Files and Shared Components > Security > Authentication Schemes. Verified References:
[Creating an Application Using the Create Application Wizard - Oracle Help Center], [Create Application Wizard - Oracle APEX]

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

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

Answer: C

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 # 81
Which two statements are true about the APEX MAIL API?

• A. You can send emails using the APEX MAIL package from an Oracle APEX application.
• B. You can receive emails using the APEX_MAIL package in an Oracle APEX application
• C. The APEX_MAIL package supports sending emails only to Oracle database users.
• D. You can add files as attachments to your emails using the APEX_MAIL package.

Answer: A,D

Explanation:
Explanation
The APEX_MAIL package is an API for the APEX mail system that enables developers to send emails from PL/SQL code. Some of the statements that are true about the APEX_MAIL package are:
You can add files as attachments to your emails using the APEX_MAIL package. You can use the APEX_MAIL.ADD_ATTACHMENT procedure to add one or more files as attachments to your emails.
The files can be in various formats, such as PDF, DOCX, XLSX, etc.
You can send emails using the APEX_MAIL package from an Oracle APEX application. You can use the APEX_MAIL.SEND procedure or function to send an outbound email message from your application. You can also specify various parameters for your email, such as sender, recipients, subject, body, priority, etc. The APEX_MAIL package does not support sending emails only to Oracle database users or receiving emails in an Oracle APEX application. You can send emails to any valid email address or use other tools or services to receive emails. Verified References: [APEX_MAIL - Oracle Help Center], [APEX_MAIL : Send Emails from PL/SQL - ORACLE-BASE]

NEW QUESTION # 82
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_HIREDATE and P2_COMM.
• C. Create a dynamic action on form load.
• D. ......... and enter SALESMAN for Value.
• E. Create a dynamic action on P2_JOB.

Answer: D,E

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 # 83
You can create a report in which of the three following methods?

• A. Create a report from Object Browser
• B. Create a report as a new page in an application
• C. Create a report region on a page in an application
• D. Create a report when you create a new database application

Answer: B,C,D

Explanation:
Explanation
You can create a report in any of these three methods:
Create a report as a new page in an application by using the Create Page Wizard. This wizard guides you through the steps of selecting a page type, defining attributes, selecting a source (such as SQL query or table), and adding items or buttons.
Create a report when you create a new database application by using the Create Application Wizard.
This wizard allows you to generate one or more reports based on existing tables or views in your schema. You can also create a report and form on the same table or view.
Create a report region on a page in an application by using the Page Designer. This tool allows you to drag and drop a region type (such as Classic Report, Interactive Report, or Interactive Grid) onto the page and define its attributes and source.
The other option is incorrect because:
You cannot create a report from Object Browser. Object Browser is a tool that allows you to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can only run SQL queries or scripts from this tool, not create reports.
Verified References: [Creating Database Applications] [Creating Pages] [Creating Regions] [Using Object Browser]

NEW QUESTION # 84
Which two of the following capabilities are TRUE for both Interactive Report and Interactive Grid?

• A. End user can rearrange the report interactively using the mouse.
• B. End user can add, modify, and refresh data directly on the report.
• C. End user can save the report
• D. End user can customize how and what data is displayed.

Answer: B,D

Explanation:
Explanation
An Interactive Report and an Interactive Grid are two types of regions that allow end users to customize how and what data is displayed. They have some common capabilities such as:
End users can add, modify, and refresh data directly on the report by using the Edit option. This option enables inline editing or modal dialog editing depending on the region settings.
End users can customize how and what data is displayed by using the Actions menu. This menu provides various options such as Filter, Highlight, Aggregate, Chart, Group By, Pivot, etc.
The other options are incorrect because:
End users cannot rearrange the report interactively using the mouse in an Interactive Report. This capability is only available in an Interactive Grid by using the Reorder option in the Actions menu.
End users cannot save the report in an Interactive Grid. This capability is only available in an Interactive Report by using the Save Report option in the Actions menu.
Verified References: [About Interactive Reports] [About Interactive Grids]

NEW QUESTION # 85
What are the two primary ways to move database objects and data from one environment toanother, for a single application?

• A. App Builder
• B. Oracle SQL Developer
• C. SQL Workshop
• D. Page Designer

Answer: B,C

Explanation:
Explanation
Oracle SQL Developer and SQL Workshop are two primary ways to move database objects and data from one environment to another, for a single application. Oracle SQL Developer is a graphical tool that allows you to export and import data schemas using Data Pump or SQL scripts. SQL Workshop is a component of Oracle APEX that enables you to perform tasks such as exporting and importing data, running SQL commands, and generating DDL scripts. Both tools can help you migrate your database objects and data to a different instance or workspace. References: Using SQL Developer to Migrate Your Oracle Database and Using Data Workshop to Manage Data

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

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

Answer: A,D

NEW QUESTION # 87
Which two Plugin types can be created in Oracle APEX?

• A. Region
• B. Email Template
• C. Validation
• D. Process

Answer: A,D

Explanation:
Explanation
A plugin is a component that extends the native functionality of Oracle APEX by allowing developers to create custom components using SQL, PL/SQL, HTML, CSS, and JavaScript. A plugin can be created for any of the following component types: Dynamic Action, Item, Process, Region, Report Layout, Authentication Scheme, Authorization Scheme, or Data Load Method. A process plugin is a custom process type that can be executed when a page is submitted or loaded. A region plugin is a custom region type that can display data or content on a page. Verified References: [Creating Plugins - Oracle Help Center], [Plugin Concepts - Oracle Help Center]

NEW QUESTION # 88
Choose the three different ways in which you can add a checkbox to a page.

• A. Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type.
• B. Drag and drop the checkbox item into the Layout pane
• C. Add a checkbox from the Property Editor
• D. Use the context sensitive menu in the Gallery pane.

Answer: A,B,D

Explanation:
Explanation
There are three different ways in which you can add a checkbox to a page in APEX:
Drag and drop the checkbox item into the Layout pane: In Page Designer, you can drag and drop items from the Gallery pane into the Layout pane to create them on your page. To create a checkbox item, expand the Items node in the Gallery pane and drag and drop Checkbox into the Layout pane.
Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type: In Page Designer, you can right click any node in the Rendering tree andselect Create to create a new component under that node. To create a checkbox item under the Body node, right click Body and select Create > New Page Item > Checkbox.
Use the context sensitive menu in the Gallery pane: In Page Designer, you can use the context sensitive menu in the Gallery pane to create items on your page. To create a checkbox item using this method, expand the Items node in the Gallery pane and right click Checkbox. Then select Create Checkbox.

NEW QUESTION # 89
Examine this code used in Quick SQL:
students
name
roll no num
Quick SQL is using default settings.
Which table creation script or other output is produced?

• A. An Invalid column definition error message will be displayed.
• B. 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 )
  ;
• C. 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 )
  ;

Answer: B

Explanation:
Explanation
The table creation script produced by Quick SQL is:
create table emp_salary ( id number generated by default on null as identity constraint emp_salary_id_pk primary key, name varchar2 (255 char) not null, salary number, commission_yn varchar2 (1 char) check (commission_yn in ('Y','N')) default 'N' not null ); The commission_yn column will default to 'N' because of the default clause in the column definition. It will also restrict acceptable values to 'Y' or 'N' because of the check constraint. The other options are incorrect because they do not match the output of Quick SQL. Verified References: Using Quick SQLAbout Quick SQL Shorthand Syntax

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

Answer: C

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 # 91
Which two layout options are available for Page Designer under Utilities?

• A. Single Pane Mode
• B. Three Pane Mode
• C. Four Pane Mode
• D. Two 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 # 92
Which two are true about Oracle APEX?

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

Answer: A,B

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 # 93
Which statement is true about the Link Column attribute of an interactive report?

• A. It is not possible to include a custom target in Link Column
• B. If you select Link Column, it is always displayed as the last column in the report.
• C. A Link Column cannot be sorted, hidden, or moved by an end user.
• D. It is not possible to exclude Link Column.

Answer: C

Explanation:
Explanation
A Link Column is a special column type that you can define for an interactive report to create a link to another page, URL, or custom target. A Link Column is always displayed as the first column in the report, regardless of the order of the columns in the query. A Link Column cannot be sorted, hidden, or moved by an end user using the Actions menu or the column header. However, a developer can change the position and visibility of a Link Column by editing the report attributes in Page Designer.

NEW QUESTION # 94
Which two statements are true about Maps in Oracle APEX?

• A. Maps don't support REST Data Sources
• B. Background maps do not require any API keys.
• C. Maps support REST Enabled SQL
• D. Heat Map and Polygons are not supported Spatial geometry objects

Answer: B,C

Explanation:
Explanation
A map is a type of component that enables you to view and manage data based on geographic locations. A map consists of a background map and spatial geometry objects that are sourced from data in a table or from a REST Data Source. Spatial geometry objects are shapes that represent real-world features on a map, such as points, lines, polygons, or heat maps. Two of the statements that are true about maps in Oracle APEX are:
Background maps do not require any API keys. This statement is true because Oracle APEX provides several background map options that do not require any API keys or registration to use. These options include OpenStreetMap, Stamen Maps, CartoDB Maps, and Esri Maps.
Maps support REST Enabled SQL. This statement is true because Oracle APEX allows you to use REST Enabled SQL as a data source for your map regions. REST Enabled SQL is a feature of Oracle REST Data Services (ORDS) that enables you to execute SQL statements and PL/SQL blocks over HTTPS using REST endpoints.

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

• A. Range
• B. Date Picker
• C. Checkbox Group
• D. Popup LOV

Answer: A,C

Explanation:
Explanation
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]

NEW QUESTION # 96
What are the required fields while creating a Chart in APEX?

• A. Data Source
• B. All of them
• C. Name
• D. Label Column
• E. Value Column

Answer: B

Explanation:
Explanation
To create a chart in Oracle APEX, you need to provide some required fields that define the data source and appearance of the chart. You can use either the Create Page Wizard or Page Designer to create a chart. The required fields for creating a chart are:
Data Source: This field specifies the SQL query that returns the data for the chart. The query must include at least one column for the label and one column for the value of each data point. You can also include additional columns for grouping, color, or tooltip information.
Value Column: This field specifies the column from the data source query that contains the numeric values for the chart. The values are used to plot the data points on the chart and determine the size of each data point or segment.
Name: This field specifies the name of the chart region. The name is used to identify the region in Page Designer and other components, such as dynamic actions or processes.
Label Column: This field specifies the column from the data source query that contains the labels for the chart. The labels are used to display the name of each data point or segment on the chart or in the legend.

NEW QUESTION # 97
......

To prepare for the Oracle 1Z0-770 exam, candidates should have a strong understanding of web development concepts, such as HTML, CSS, and JavaScript. Candidates should also have experience in developing web applications using Oracle APEX. Oracle offers various training courses, online tutorials, and practice exams to help candidates prepare for the certification exam.

 

100% Free 1Z0-770 Files For passing the exam Quickly: https://easypass.examsreviews.com/1Z0-770-pass4sure-exam-review.html