Give You Free Regular Updates on 1z1-770 Exam Questions Mar 29, 2024
Achieve the 1z1-770 Exam Best Results with Help from Oracle Certified Experts
Oracle 1Z0-770 Exam is intended for Oracle APEX developers, including software developers, web developers, and IT professionals who have extensive knowledge in APEX design and development. 1z1-770 exam is relevant for individuals who want to become a certified professional in Oracle APEX development, which demonstrates their expertise, skills, and knowledge in database-driven web application development.
NEW QUESTION # 18
Choose the three supported spatial geometry objects in Maps.
- A. Points
- B. Heat map
- C. Bars
- D. Polygons
Answer: A,B,D
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 # 19
Which two tasks can you perform using App Builder?
- A. Import previously exported apps.
- B. Generate data definition language (DDL) statements from the Oracle data dictionary.
- C. Create and manage database objects.
- D. Create and manage apps.
- E. Create join queries using drag and drop.
Answer: A,D
Explanation:
Explanation
App Builder is the main interface of Oracle APEX that allows developers to create and manage web applications. App Builder provides various features and tools to design, develop, test, debug, deploy, and maintain applications. Some of the tasks that you can perform using App Builder are importing previously exported apps, creating new apps from scratch or from predefined templates or blueprints, editing app properties and attributes, adding pages and regions, creating shared components, running and debugging apps, exporting apps to files or workspaces, etc. You cannot create join queries using drag and drop or generate DDL statements from the Oracle data dictionary using App Builder. Verified References: [Using App Builder
- Oracle Help Center], [App Builder Concepts - Oracle Help Center]
NEW QUESTION # 20
Which statement is true about the Link Column attribute of an interactive report?
- A. A Link Column cannot be sorted, hidden, or moved by an end user.
- B. It is not possible to include a custom target in Link Column
- C. It is not possible to exclude Link Column.
- D. If you select Link Column, it is always displayed as the last column in the report.
Answer: A
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 # 21
Which two statements are true about REST Data Source Synchronization?
- A. You cannot trigger Data Synchronization on a regular schedule using a scheduler job.
- B. If the local table is not in sync with the Data Profile, Data Synchronization doesn't work.
- C. The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties
- D. 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.
- E. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.
Answer: D,E
Explanation:
Explanation
REST Data Source Synchronization is a feature that enables developers to automatically sync the contents of a local table with the data from an external REST service. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema, which allows APEX to create a DBMS_SCHEDULER job for each scheduled synchronization task. If the local table is not in sync with the Data Profile, which defines the columns and data types of the REST service response, Data Synchronization continues to work for columns present in both the table and the Data Profile (other columns are ignored). However, APEX generates SQL DDL statements to sync table columns back to the Data Profile, which can be added to the application as supporting objects. Verified References: Managing Data Synchronization - Oracle Help Center, Synchronize Data from REST Services to Local Table - Oracle Blogs
NEW QUESTION # 22
Which two are true about Oracle APEX?
- A. Is declarative. It requires no code generation.
- B. Requires no additional client software. A web browser is the app development IDE.
- C. Requires developers to be proficient in Java, Python and other programming languages.
- D. Performs the data processing in a middle-tier server
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 # 23
Which two statements are true about creating and using an interactive report?
- A. You cannot include Form Page when creating an interactive report page using the Create Page Wizard.
- B. You cannot restrict users from saving private reports by using the Authorization Scheme.
- C. You cannot customize the Search Button Label.
- D. You can specify an Authorization Scheme at the column level.
Answer: C,D
NEW QUESTION # 24
Which authentication scheme type supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards?
- A. HTTP Header Variable
- B. Open Door Credentials
- C. Social Sign-In
- D. SAML Sign-In
Answer: C
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 # 25
Which two statements are true about the usage of a Remote Server in the context of REST Data Sources?
- A. The remote server should mandatorily be an APEX instance.
- B. Multiple REST Data Sources can reference a single remote server.
- C. The remote server determines the base URL of the REST Data Source.
- D. A single REST Data Source can use multiple remote servers.
Answer: B,C
Explanation:
Explanation
A remote server in the context of REST Data Sources is a configuration that defines how to connect to an external server that hosts one or more REST services. The remote server determines the base URL of the REST Data Source, which is used to construct the full URL of each REST operation. Multiple REST Data Sources can reference a single remote server, which simplifies the maintenance and security of accessing external REST services. Verified References: Managing Remote Servers - Oracle Help Center, Creating REST Data Sources - Oracle Help Center
NEW QUESTION # 26
Which two statements are true about Maps in Oracle APEX?
- A. Maps support REST Enabled SQL
- B. Maps don't support REST Data Sources
- C. Heat Map and Polygons are not supported Spatial geometry objects
- D. Background maps do not require any API keys.
Answer: A,D
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 # 27
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 disable the Batch Facet Changes attribute
- C. Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute.
- 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 # 28
Using Data Workshop, you can perform which three tasks:
- A. Export vast amount of data from the database into a file
- B. Load vast amount of data into the database
- C. Delete data from the database
- D. Load data using various file formats such as XLSX, CSV, XML, and JSON
Answer: A,B,D
Explanation:
Explanation
Using Data Workshop, you can perform the following tasks:
Load vast amount of data into the database: You can use the Data Load option to load data from various file formats such as XLSX, CSV, XML, and JSON into a table or a collection in your database. You can also use the Data Load Wizard to guide you through the steps of loading data.
Export vast amount of data from the database into a file: You can use the Data Unload option to export data from a table or a collection in your database into a file in CSV or JSON format. You can also use the Data Unload Wizard to guide you through the steps of exporting data.
Load data using various file formats such as XLSX, CSV, XML, and JSON: You can use the Data Load option to load data from different file formats into your database. You can choose the file format from a list of supported formats or let Oracle APEX detect it automatically.
The other option is incorrect because:
Delete data from the database: You cannot use Data Workshop to delete data from the database. You can use SQL Commands or SQL Scripts in SQL Workshop to run DELETE statements to delete data from the database.
Verified References: [About Data Workshop] [Loading Data] [Unloading Data]
NEW QUESTION # 29
When you click a Customer Name in the Customers report, the Customer Details form dialog page is displayed. What are the events that occur in this scenario?
- A. Page Processing
- B. Page compilation
- C. Page rendering and processing
- D. Page Rendering
Answer: C
Explanation:
Explanation
When you click a Customer Name in the Customers report, the Customer Details form dialog page is displayed. This involves two events: page rendering and page processing. Page rendering is the event that occurs when APEX generates and sends the page to the browser. Page processing is the event that occurs when APEX receives and processes the page from the browser. In this scenario, both events happen because the Customer Details form dialog page is a modal dialog that uses AJAX to communicate with the server without reloading the entire page. Page compilation is not an event, but an action that occurs when APEX compiles an application or a page before running it.
NEW QUESTION # 30
You want to enable anyone to access your application using a built-in login page that captures a user name.
Whichauthentication scheme would youchoose?
- A. Social Sign-In
- B. Custom Authentication
- C. Open Door Credentials
- D. No Authentication
Answer: C
Explanation:
Explanation
Open Door Credentials is an authentication scheme that allows anyone to access your application using a built-in login page that captures a user name. You can use this scheme for testing purposes or for applications that do not require secure authentication. You can select this scheme from the Authentication Type list when creating or editing an authentication scheme. References: [Understanding Authentication] and [Creating an Authentication Scheme]
NEW QUESTION # 31
Choose the three different ways in which you can add a checkbox to a page.
- A. Use the context sensitive menu in the Gallery pane.
- B. Drag and drop the checkbox item into the Layout pane
- C. Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type.
- D. Add a checkbox from the Property Editor
Answer: A,B,C
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 # 32
You must create a single master detail page where users can select a row in the master grid to update the detail grids.
Users must also interact with the master or the detail without leaving the page.
Which type of master detail implementation should you use?
- A. Stacked
- B. Side by Side
- C. Drill Down
Answer: A
Explanation:
Explanation
A stacked master detail is a type of master detail implementation that features two editable interactive grids based on two related tables or views. Users can select a row in the master grid to update the detail grid. Users can also interact with the master or the detail without leaving the page. A stacked master detail is suitable for scenarios where you want to display and edit data from a one-to-many relationship in a single page. You can create a stacked master detail using either the Create Application Wizard or the Create Page Wizard. Verified References: [Managing Master Detail Forms - Oracle Help Center], [Creating a Single Page Master Detail Using the Create Application Wizard - Oracle Help Center]
NEW QUESTION # 33
Which three are the main components of APEX workspace homepage?
- A. RESTful Services
- B. Gallery
- C. SQL Workshop
- D. App Builder
Answer: B,C,D
Explanation:
Explanation
The main components of an APEX workspace homepage are:
Gallery: This component displays various sample applications, blueprints, plug-ins, themes, and learning resources that you can use to get started with Oracle APEX.
SQL Workshop: This component allows you to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can also use this component to run SQL queries or scripts, load or unload data from the database, generate DDL statements, view object reports, and restore dropped objects.
App Builder: This component allows you to create and edit your applications using the Create Application Wizard or the Page Designer. You can also use this component to import or export applications from files or URLs, run or debug applications, manage application settings, and access various utilities.
The other option is incorrect because:
RESTful Services: This component is not part of the APEX workspace homepage. It is part of the SQL Workshop component. It allows you to create and manage RESTful web services based on your database objects or SQL queries.
Verified References: [About the Workspace Home Page] [About SQL Workshop] [About App Builder]
NEW QUESTION # 34
The Page Designer Toolbar allows you to perform which two of the following actions?
- A. Create a new page
- B. Export the application
- C. Navigate to Shared Components
- D. Delete the application
Answer: A,C
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 # 35
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. The search results report can be displayed as an interactive report.
- D. If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache.
Answer: A,D
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 # 36
Which two statements are true about REST Data Sources?
- A. Oracle APEX supports the REST Enabled SQL Query REST Data Source type
- B. Oracle APEX doesn't provide direct integration of REST Data Sources in interactivereports
- C. AREST Data Source can contain one or many Operations which are the references toa concrete external web service
- D. REST Data Sources doesn't support any authentication
Answer: A,C
Explanation:
Explanation
A REST Data Source is a logical representation of an external web service in Oracle APEX. It can contain one or many Operations, which are the references to a concrete external web service endpoint. Oracle APEX supports three types of REST Data Sources: REST Enabled SQL Query, Web Source Module, and Generic REST Data Source. Oracle APEX provides direct integration of REST Data Sources in interactive reports and grids, as well as other components. REST Data Sources can support various authentication methods, such as Basic, OAuth2, or Custom. References: [Understanding REST Data Sources] and [Creating a REST Data Source]
NEW QUESTION # 37
......
Detailed New 1z1-770 Exam Questions for Concept Clearance: https://torrentking.practicematerial.com/1z1-770-questions-answers.html
