Oracle 1z1-770 Real Exam Questions Guaranteed Updated Dump from Test4Sure
Verified Pass 1z1-770 Exam in First Attempt Guaranteed
Oracle 1Z0-770 exam consists of 60 multiple-choice questions and must be completed within 105 minutes. 1z1-770 exam is available in English and Japanese and can be taken at any Pearson VUE testing center worldwide. 1z1-770 exam can also be taken online from a candidate's home or office using a remote proctoring service.
Oracle 1Z0-770 certification exam is designed to test the knowledge and skills of Oracle Application Express (APEX) developers. Oracle APEX Developer Professional certification is intended for experienced developers who have a deep understanding of APEX and its various components. 1z1-770 exam covers a wide range of topics, including APEX architecture, security, performance tuning, and development techniques.
Oracle 1Z0-770 (Oracle APEX Developer Professional) Exam is a certification exam for individuals seeking to become a professional Oracle APEX developer. Oracle APEX (Application Express) is a web application development platform that is built on top of the Oracle database, which allows developers to create and deploy web applications quickly and easily. 1z1-770 exam is designed to test an individual’s knowledge and expertise in Oracle APEX development.
NEW QUESTION # 79
Select the two advantages of using One-click Remote Deployment.
- A. Simplify the process of deploying an application
- B. Deploy the app, and explicitly install the supporting objects in one-click.
- C. Directly deploy your app definition along with the objects from the source system to the target system
- D. You need to access your production environment to import the app directly.
Answer: B,C
Explanation:
Explanation
One-click remote application deployment is a feature in Oracle APEX that simplifies the process of deploying an application from one APEX instance to another using REST Enabled SQL references. REST Enabled SQL references are shared components that work with an Oracle REST Data Services (ORDS) REST Enabled SQL Service. One-click remote application deployment can authenticate through first party authentication (Basic Authentication), Schema Authentication (database username and password), or OAuth 2 Client Credentials.
Two of the advantages of using one-click remote application deployment are:
Deploy the app, and explicitly install the supporting objects in one-click. This advantage allows you to package the app definition along with the database objects, images, and seed data necessary for your application to run correctly using the Supporting Objects functionality in APEX. You can then export and deploy this app and install the supporting objects in one-click without having to manually create or copy the database objects in the target system.
Directly deploy your app definition along with the objects from the source system to the target system.
This advantage allows you to avoid the intermediate step of exporting the app and its objects from the source system into files and then importing them into the target system. You can directly deploy your app and its objects from within your development environment to the remote production environment without having to access your production environment.
NEW QUESTION # 80
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 type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox.
- C. It is a page that shows details for a specific task, which can include metadata, history, comments, and actions.
Answer: B
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 # 81
Which two statements are true about creating and using an interactive report?
- A. You cannot customize the Search Button Label.
- B. You can specify an Authorization Scheme at the column level.
- C. You cannot restrict users from saving private reports by using the Authorization Scheme.
- D. You cannot include Form Page when creating an interactive report page using the Create Page Wizard.
Answer: A,B
NEW QUESTION # 82
In your APEX application, you want to have an orderly grid layout of information tiles. Which page type should you choose in the Create Page Wizard?
- A. Cards
- B. Interactive Grid
- C. Master Detail
- D. Unified Task List
Answer: A
Explanation:
Explanation
Cards are a page type that display information in a grid layout of tiles. Each card can contain an image, a title, a subtitle, and an optional link. Cards are suitable for presenting summary or overview information in an attractive and compact way1 Verified References: 1: Understanding Page Types, Features, and Settings - Oracle Help Center
NEW QUESTION # 83
Consider a customers report. A customer name is clicked in the report to display the Customer Details form. When the items in the form dialog are updated and the user clicks Apply Changes, the page process is executed and the items from the page are used to update and commit the underlying table in the Oracle Database. What are the two types of events that occurred in this scenario?
- A. Page Refresh
- B. Page Rendering
- C. Page Validation
- D. Page Processing
Answer: C,D
Explanation:
Explanation
When the customer name is clicked in the report, the Customer Details form dialog page is displayed. This is a page rendering event, which means the page is generated and sent to the browser. When the items in the form dialog are updated and the user clicks Apply Changes, the page process is executed and the items from the page are used to update and commit the underlying table in the Oracle Database. This is a page processing event, which means the page is submitted to the server and processed by APEX. Page validation is also a part of page processing, but it is not a separate event. Page refresh is not an event, but an action that can be triggered by a dynamic action or a process
NEW QUESTION # 84
Choose the three correct statements about Charts in APEX.
- A. Each Oracle JET visualization supports animation, accessibility, responsive layout,internationalization, test automation, and a range of inter activity features.
- B. Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations.
- C. You can create charts without using Oracle JET
- D. You can visualize data as bar, line, area, range, combination, scatter, bubble, polar, radar, pie, donut, funnel and more
Answer: A,B,D
Explanation:
Explanation
A chart is a type of component that enables users to visualize data in different ways and perform data analysis.
A chart can display data in various formats, such as bars, lines, areas, ranges, combinations, scatters, bubbles, polars, radars, pies, donuts, funnels, and more. Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations. Oracle JET is a modular open source toolkit based on modern JavaScript, CSS3, and HTML5 design and development principles. Three of the correct statements about charts in Oracle APEX are:
You can visualize data as bar, line, area, range, combination, scatter, bubble, polar, radar, pie, donut, funnel and more. This statement is true because Oracle APEX provides a rich set of chart types that can be used to display data in different ways and support different analysis scenarios. You can choose from over 20 chart types when creating a chart in Oracle APEX.
Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations. This statement is true because Oracle APEX uses Oracle JET as the underlying technology for rendering charts in the browser. Oracle JET provides high-performance and interactive data visualizations that are compatible with various devices and browsers.
Each Oracle JET visualization supports animation, accessibility, responsive layout, internationalization, test automation, and a range of inter activity features. This statement is true because Oracle JET offers many features and capabilities that enhance the user experience and functionality of the charts. For example:
Animation: Charts can have smooth transitions and effects when loading or updating data.
Accessibility: Charts can support keyboard navigation, screen reader compatibility, and high contrast mode for users with disabilities.
Responsive layout: Charts can adapt to different screen sizes and orientations by resizing or repositioning elements.
Internationalization: Charts can support different languages, date formats, number formats, and text directions for users from different regions.
Test automation: Charts can support automated testing tools and frameworks by providing unique identifiers for elements.
Interactivity: Charts can support user actions such as zooming, panning, filtering, selecting, drilling down, or popping up tooltips.
NEW QUESTION # 85
Which statement is true about session state management in Oracle APEX?
- A. A user cannot run multiple instances of an application simultaneously in different browser programs.
- B. APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests.
- C. Multiple number of sessions cannot exist in the database at the same time
Answer: B
Explanation:
Explanation
Session state management is a feature that enables developers to store and retrieve values for a user as the user navigates between different application pages. A session is a logical construct that establishes persistence (or stateful behavior) across page views. Each session is assigned a unique identifier (or session ID). The statement that is true about session state management in Oracle APEX is:
APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests. APEX Sessions are stored in memory within an Application Express engine process while Oracle database sessions are stored in memory within an Oracle database process. The other statements are false because:
A user can run multiple instances of an application simultaneously in different browser programs by using different session IDs.
Multiple number of sessions can exist in the database at the same time for different users or applications.
Verified References: [Understanding Session State Management - Oracle Help Center], [What Is a Session? - Oracle Help Center]
NEW QUESTION # 86
You can apply an authorization scheme for which three of the following components?
- A. A page
- B. An entire application
- C. A session
- D. Specific control such as region,item or button
Answer: A,B,D
Explanation:
Explanation
You can apply an authorization scheme for the following components in APEX:
A specific control such as a region, item, or button. You can select an authorization scheme from the Authorization Scheme list on the attributes page of the control. This will control the rendering and processing of the control based on the user privileges12.
A page. You can select an authorization scheme from the Authorization Scheme list on the Security page of the page definition. This will control the access to the page based on the user privileges12.
An entire application. You can select an authorization scheme from the Authorization Scheme list on the Security Attributes page of the application definition. This will control the access to the entire application based on the user privileges12.
You cannot apply an authorization scheme for a session, as a session is not a component in APEX. A session is a stateful connection between a browser and the APEX engine that persists across multiple requests and responses3. You can control session security by using session state protection, session expiration, and session isolation4.
NEW QUESTION # 87
Select the three ways in which you can create a Form in APEX.
- A. Using the Create Page wizard
- B. Using Shared Components
- C. Create a Form region in Page Designer
- D. Using the Create Application Wizard
Answer: A,C,D
Explanation:
Explanation
A form is a type of component that is part of an HTML form and can accept user input or display output.
There are many types of forms that can be created in APEX, such as forms on tables, forms on procedures, forms on web sources, and so on. Each type of form has different properties and attributes that affect its appearance and functionality. Three of the ways in which you can create a form in APEX are:
Using the Create Page wizard: This method allows you to create a new page with a form component using a guided wizard. You can choose from different types of forms, such as report with form, editable interactive grid, single page master detail, two page master detail, form on table, form on procedure, and so on. You can also specify various options for your form, such as data source, display style, validations, processes, and branches.
Create a Form region in Page Designer: This method allows you to create a complex form region that includes multiple form items and processes on an existing page. You can use the Create Form Region wizard in Page Designer to create a form region based on a table, view, procedure, web source module, or SQL query. You can also customize your form region by adding or modifying items, buttons, validations, computations, processes, and dynamic actions.
Using the Create Application Wizard: This method allows you to create a new application that contains one or more forms using a guided wizard. You can choose from different types of applications, such as database application, web source application, blueprint application, or from scratch application. You can also specify various options for your application and forms, such as name, icon, theme style, features, data source, navigation menu entry, and so on.
NEW QUESTION # 88
Which two statements are true about creating and using dynamic actions?
- A. 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
- B. You can execute JavaScript code by creating a dynamic action.
- C. Once you create a dynamic action, you cannot add additional true actions.
- D. If no client-side condition is defined, true actions will not fire.
Answer: A,B
Explanation:
Explanation
Dynamic actions are a declarative way to define client-side behavior without writing JavaScript code. You can create dynamic actions on an item, button, or region of a page by specifying the event, condition, affected elements, action, and other properties. Some of the statements that are true about creating and using dynamic actions are:
You can execute JavaScript code by creating a dynamic action. One of the supported action types is Execute JavaScript Code, which allows you to enter custom JavaScript code to run when the dynamic action fires.
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. You can define a client-side condition for a dynamic action to control when it should fire based on an expression or value. You can also define different actions for the true and false branches of the condition. You can add additional true actions to a dynamic action by clicking the Add True Action button in the Property Editor. If no client-side condition is defined, true actions will fire when the event occurs. Verified References: [Oracle Application Express 18: Creating Dynamic Actions], [Dynamic Action Enhancements in APEX 21.1 - Oracle Blogs]
NEW QUESTION # 89
A Page Computation can be created from which two of the following tabs?
- A. Rendering Tree
- B. Processing
- C. Dynamic Actions
- D. Shared Components
Answer: A,B
Explanation:
Explanation
A Page Computation can be created from two tabs in Page Designer: Rendering Tree and Processing. In the Rendering Tree tab, you can create a Pre-Rendering Computation or a Post-Rendering Computation by right-clicking on these nodes under your page node. In the Processing tab, you can create an After Submit Computation by right-clicking on this node under your page node. Dynamic Actions and Shared Components are not tabs in Page Designer, but sections in Application Builder where you can create other types of components for your application
NEW QUESTION # 90
Which two of the following capabilities are TRUE for both Interactive Report and Interactive Grid?
- A. End user can save the report
- B. End user can customize how and what data is displayed.
- C. End user can add, modify, and refresh data directly on the report.
- D. End user can rearrange the report interactively using the mouse.
Answer: B,C
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 # 91
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 each facet and then in the Property Editor, turn on client-Side Filtering.
- C. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute
- D. 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.
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 # 92
Choose from the following the different kinds of page components you can create in APEX.
- A. Interactive Grid
- B. All of them
- C. Smart Filters
- D. Faceted Search
- E. Search Page
Answer: B
Explanation:
Explanation
All of the options listed are different kinds of page components that you can create in APEX. A page component is an area of a page that serves as a container for content. Each page component contains a different type of content, such as HTML, a report, a form, a chart, a list, a breadcrumb, PL/SQL, a tree, a URL, or a calendar. You can create page components by using the Create Page Wizard, dragging and dropping from the Gallery pane in Page Designer, or using the context-sensitive menu in the Rendering tree in Page Designer.
NEW QUESTION # 93
Choose the two options provided in a Column Heading menu of an Interactive Report.
- A. Control Break
- B. Group By
- C. Hide
- D. Delete
Answer: A,C
Explanation:
Explanation
The Column Heading menu of an Interactive Report provides various options to customize the report based on the selected column. The options include:
Control Break: This option allows you to create a control break on the column, which groups the rows by the column values and inserts a header and a footer for each group. You can also apply aggregate functions, such as sum, count, or average, to the footer of each group.
Hide: This option allows you to hide the column from the report, which reduces the clutter and improves the readability of the report. You can also show the hidden columns by using the Columns option in the Actions menu.
The other options are incorrect because:
Group By: This option is not provided in the Column Heading menu of an Interactive Report. It is provided in the Actions menu of an Interactive Report. It allows you to group the rows by one or more columns and display the result in a chart or a pivot table.
Delete: This option is not provided in the Column Heading menu of an Interactive Report. It is provided in the Data option in the Actions menu of an Interactive Report. It allows you to delete one or more rows from the report and the underlying table.
Verified References: [Customizing Interactive Reports] [Column Heading Menu]
NEW QUESTION # 94
The Page Designer Toolbar allows you to perform which two of the following actions?
- A. Export the application
- B. Navigate to Shared Components
- C. Delete the application
- D. Create a new page
Answer: B,D
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 # 95
Which two statements are true about the APEX MAIL API?
- A. You can receive emails using the APEX_MAIL package in an Oracle APEX application
- B. You can send emails using the APEX MAIL package from 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: B,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 # 96
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 # 97
Which three statements are TRUE about Search Configuration?
- A. Search Configuration is a shared component defines the data source to be searched and the way results should be displayed.
- B. Only one Search Configuration can be used in a Search Page.
- C. Searches can be based on Local data, APEX Lists, REST Enabled SQL Service, or REST Data Sources.
- D. One or more Search Configurations can be configured in a Search Page.
Answer: A,C,D
Explanation:
Explanation
Search configuration is a shared component that defines the data source to be searched and the way results should be displayed. You can create a search configuration based on a local data source (table or SQL query), an APEX list, a REST enabled SQL service, or a REST data source2. You can use one or more search configurations in a search page, depending on the search type you select. For example, you can use multiple search configurations for a standard search, but only one search configuration for an Oracle TEXT or a list search2.
NEW QUESTION # 98
Which is NOT a valid Geometry Column Data Type available for maps region?
- A. Latitude/Longitude
- B. JSON_OBJECT
- C. GeoJSON
- D. SDO_GEOMETRY
Answer: B
Explanation:
Explanation
The valid Geometry Column Data Types for maps region are Latitude/Longitude, GeoJSON, and SDO_GEOMETRY. These types represent different ways of storing spatial data in Oracle Database.
Latitude/Longitude uses two numeric columns for longitude and latitude values. GeoJSON uses a VARCHAR2 or CLOB column that contains geometry information in GeoJSON format. SDO_GEOMETRY uses an object type that stores spatial data using Oracle Spatial features. JSON_OBJECT is not a valid Geometry Column Data Type for maps region. Verified References: About Supported MapsEditing Maps
NEW QUESTION # 99
Which of the following options in the Developer Toolbar enables you to customize the look and feel of the application?
- A. Customize
- B. Quick Edit
- C. Debug
- D. Session
Answer: A
Explanation:
Explanation
The Developer Toolbar is a component that appears at the bottom of every page in an Oracle APEX application when running in development mode. The Developer Toolbar provides quick access to various features and tools for developing and debugging an application. One of the options in the Developer Toolbar that enables developers to customize the look and feel of the application is Customize.
Customize: This option opens the Theme Roller tool that allows developers to modify the theme style of the application by changing colors, fonts, sizes, borders, shadows, and more. Developers can also create new theme styles or switch between existing ones using this option.
NEW QUESTION # 100
Select the two places from where you can access the Shared Components Page?
- A. SQL Workshop
- B. Page Designer
- C. Application homepage
- D. Gallery
Answer: B,C
Explanation:
Explanation
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.
NEW QUESTION # 101
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 # 102
Choose the three supported spatial geometry objects in Maps.
- A. Heat map
- B. Polygons
- C. Points
- D. Bars
Answer: A,B,C
Explanation:
Explanation
A map is a type of component that enables users 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. Three of the supported spatial geometry objects in Oracle APEX are:
Polygons: A polygon is a closed shape that consists of three or more vertices connected by straight line segments. A polygon can represent an area on a map, such as a country, a state, a city, or a building. A polygon can have different colors, patterns, or borders to indicate different attributes or categories of the data.
Heat map: A heat map is a type of visualization that uses color gradients to show the density or intensity of data values in a geographic area. A heat map can represent the distribution or variation of a numeric variable on a map, such as population, income, crime rate, or temperature.
Points: A point is a zero-dimensional shape that represents a single location on a map. A point can have different symbols, sizes, or colors to indicate different attributes or categories of the data. A point can also have a label or a tooltip to display additional information about the data.
NEW QUESTION # 103
......
Download Real Oracle 1z1-770 Exam Dumps Test Engine Exam Questions: https://freecert.test4sure.com/1z1-770-exam-materials.html