1z1-770 Dumps with Practice Exam Questions Answers [Q67-Q92]

1z1-770 Dumps with Practice Exam Questions Answers

1z1-770 by Oracle Database Actual Free Exam Practice Test

Oracle 1Z0-770 exam is designed to test the skills and knowledge of professionals who work with Oracle Application Express (APEX). It covers a wide range of topics related to APEX development, including application design, security, data modeling, debugging, and more. 1z1-770 exam is ideal for individuals who want to demonstrate their proficiency in APEX development and earn a professional certification from Oracle.

Oracle 1Z0-770: Oracle APEX Developer Professional exam is designed to test the skills and knowledge of individuals who want to become certified as Oracle Application Express (APEX) developers. 1z1-770 exam is aimed at professionals who have experience in developing web applications using Oracle APEX.

 

NEW QUESTION # 67
Choose from the following the different kinds of page components you can create in APEX.

• A. Smart Filters
• B. Search Page
• C. Interactive Grid
• D. Faceted Search
• E. All of them

Answer: E

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 # 68
From SQL Workshop, you can perform which two of the following actions?

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

Answer: A,C

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 # 69
Which two are true when the Edit option is NOT enabled for an Interactive Grid?

• A. The end user can customize the report
• B. The end user cannot create charts
• C. The end user can edit the underlying data in the database
• D. The end user cannot edit the underlying data in the database

Answer: A,D

Explanation:
Explanation
An interactive grid is a component that displays data in a tabular format and allows users to perform various actions on the data, such as sorting, filtering, grouping, highlighting, and editing. However, the editing feature is optional and can be enabled or disabled by the developer. When the Edit option is not enabled for an interactive grid, the following statements are true:
The end user cannot edit the underlying data in the database. The interactive grid becomes read-only and does not allow users to add, modify, or delete rows. The Add Row and Save buttons are hidden from the toolbar and the cells are not editable.
The end user can customize the report. The interactive grid still allows users to change the appearance and behavior of the report using the Actions menu. Users can perform actions such as changing column order, resizing column width, hiding or showing columns, applying filters or highlights, creating control breaks or charts, and saving reports.

NEW QUESTION # 70
Which is NOT a valid Geometry Column Data Type available for maps region?

• A. GeoJSON
• B. SDO_GEOMETRY
• C. JSON_OBJECT
• D. Latitude/Longitude

Answer: C

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 # 71
Which client credentials are utilized for authentication during the One-Click Remote ApplicationDeployment process?

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

Answer: C

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 # 72
Which two statements are true about the Create Application Wizard?

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

Answer: A,B

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 # 73
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. You can set up task approvers and administrators at design time or determine themdynamically at runtime based on data related to the task.
• C. APEX_APPROVAL is Page processes that create andact on task instances in yourpages.
• D. Unified Task List is a shared component used to configure task parameters,participants, actions, and due dates.

Answer: B

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 # 74
Choose the three correct options in the given friendly URL syntax:
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?

• A. update-employees is the PL/SQL procedure to update the employee details.
• B. mycompany is the path-prefix which is by default the workspace name
• C. 13766599855150 is the session ID. A new ID is generated for each session.
• D. session=13766599855150 Ahr-app is the application alias.

Answer: B,C,D

Explanation:
Explanation
The friendly URL syntax
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?session=13766599855150 has the following components:
session=13766599855150 is the session ID. A new ID is generated for each session. This parameter identifies which session is associated with the request.
hr-app is the application alias. This parameter identifies which application is being requested. An application alias is a user-friendly name that can be used instead of an application ID.
mycompany is the path-prefix which is by default the workspace name. This parameter identifies which workspace is being requested. A path-prefix is a URL segment that can be used instead of a workspace ID.
updateemployees is the page alias. This parameter identifies which page is being requested. A page alias is a user-friendly name that can be used instead of a page number.
The other option is incorrect because:
update-employees is not the PL/SQL procedure to update the employee details. It is the page alias that identifies which page is being requested.
Verified References: [About Friendly URLs] [Understanding URL Syntax]

NEW QUESTION # 75
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. Date Picker
• B. Popup LOV
• C. Range
• D. Checkbox Group

Answer: C,D

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 # 76
There is a page with an interactive grid region based on this statement: SELECT EMPNO, ENAME, COMM from EMP; In the Interactive Grid attributes, under the Edit group, the Enabled switch is turned Off. Which are two of the actions that you must perform to make an employee's commission editable in the grid?

• A. Set EMPNO, ENAME to "Display Only".
• B. Ensure that the "Primary Key" switch is turned "On" for the EMPNO column.
• C. In the Interactive Grid attributes, select COMM for "Allowed Row Operations Column".
• D. In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group.

Answer: B,D

Explanation:
Explanation
An interactive grid is a customizable report that allows end users to modify the data and layout of the report.
To make an employee's commission editable in the grid, you need to perform two actions:
In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group. This enables editing for the entire interactive grid region and allows you to specify which columns are editable and which are not.
Ensure that the "Primary Key" switch is turned "On" for the EMPNO column. This identifies the EMPNO column as the primary key for the EMP table and allows APEX to perform DML operations on the table when end users edit the data in the grid. You do not need to set EMPNO or ENAME to
"Display Only" or select COMM for "Allowed Row Operations Column" to make an employee's commission editable in the grid. Verified References: [Managing Interactive Grids - Oracle Help Center], [Interactive Grid Attributes - Oracle Help Center]

NEW QUESTION # 77
You must use a Static Content region type to display messages about the employees of the month. Employee names are stored in the P1 ENAME page item. Which text, when placed in Source, will display the message correctly?

• A. Join me in congratulating v('P1_ENAME') as the new employee of the month!
• B. Join me in congratulating &P1 ENAME, as the new employee of the month!
• C. Join me in congratulating :P1 ENAME as the new employee of the month!

Answer: B

Explanation:
Explanation
A Static Content region type is used to display static text or HTML content on a page. To display messages about the employees of the month, you can use a Static Content region type with substitution variables that reference page items. Substitution variables are enclosed in ampersands (&) and can be used to dynamically replace text with values from page items or application items. The correct text to display the message is "Join me in congratulating &P1_ENAME, as the new employee of the month!" The other options are incorrect because they use either colons (:) or v() function, which are not valid ways to reference page items in Static Content regions. Verified References: [Creating Static Content Regions - Oracle Help Center], [Understanding Substitution Strings - Oracle Help Center]

NEW QUESTION # 78
Which three of the following options are TRUE about a page in an APEX application?

• A. A page can contain buttons, page items and regions.
• B. To view the rendered version of the page, you run or submit it to the Oracle APEX engine.
• C. An APEX application can have only one page.
• D. A page can be viewed and edited in the Page Designer.

Answer: A,B,D

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

• A. Maps don't support REST Data Sources
• B. Maps support REST Enabled SQL
• C. Background maps do not require any API keys.
• 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 # 80
Which statement is true about using SQL Commands?

• A. You can design and prototype data models using a markdown-like shorthand syntax.
• B. You can search and filter database objects.
• C. You can unload data from the database.
• D. In SQL Commands, you can view queries saved in Query Builder.

Answer: C

Explanation:
Explanation
Commands allow you to execute SQL statements or PL/SQL blocks to create, edit, view, run, and delete database objects. One of the features of SQL Commands is the ability to unload data from the database to a CSV file. You can do this by clicking the Download button after running a query that returns data. Verified References: 34

NEW QUESTION # 81
In a Classic Report, an end user can perform which two of the following actions?

• A. Sort the columns of the report
• B. Rearrange the columns in the report
• C. Create Control Breaks in the report
• D. Filter values of a column in the report

Answer: A,D

Explanation:
Explanation
In a Classic Report, an end user can perform the following actions:
Filter values of a column in the report by using the Search Bar. This bar allows the user to enter a search string and apply it to one or more columns in the report.
Sort the columns of the report by clicking on the column headers. This action toggles the sort order between ascending and descending for the selected column.
The other options are incorrect because:
Create Control Breaks in the report is not an action that an end user can perform in a Classic Report.
This action is only available in an Interactive Report by using the Control Break option in the Actions menu.
Rearrange the columns in the report is not an action that an end user can perform in a Classic Report.
This action is only available in an Interactive Grid by using the Reorder option in the Actions menu.
Verified References: [About Classic Reports] [Searching Classic Reports] [Sorting Classic Reports]

NEW QUESTION # 82
Which statement is true about creating and using a report with form?

• A. The Create Page Wizard doesn't support the creation of a classic report and formcombination
• B. In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source).
• C. Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination.
• D. The Create Application Wizard doesn't support the creation of an interactive report and form combination.

Answer: C

Explanation:
Explanation
You can create a report with form in Oracle APEX by using either the Create Application Wizard or the Create Page Wizard. The report can be either an interactive report or a classic report, and the form can be either a single row form or a multi row form. The report with form combination enables you to view and edit data from a table or a query in a single page. You can also customize the report and form attributes, such as the columns, regions, buttons, validations, processes, and so on. Verified References: [Creating a Report Using the Create Page Wizard - Oracle], [Creating a Report with Form on Table - Oracle]

NEW QUESTION # 83
Which statement is true about Theme Styles in Oracle APEX?

• A. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.
• B. You can only enable the Is Current attribute when the Theme Style has the Read Only attribute disabled.
• C. Theme Styles in Oracle APEX determine the layout and structure of a webpage.

Answer: A

Explanation:
Explanation
Theme Styles in Oracle APEX are CSS style sheets that are added to the base CSS of a theme to alter the look and feel of an application. A theme can have multiple theme styles with one style set as current. When the Is Public attribute is enabled for a theme style, end users can choose the theme style from the runtime environment by using the Theme Style Switcher component. This allows end users to customize the appearance of the application according to their preferences. Verified References: Using Themes and Theme Styles - Oracle Help Center, Theme Styles - Oracle APEX

NEW QUESTION # 84
Choose the three types of aggregations you can apply on a column.

• A. Standard Deviation
• B. Sum
• C. Count
• D. Average

Answer: B,C,D

NEW QUESTION # 85
Consider a page in an APEX app where the Departments names with location is displayed on the left. Selecting a Department on the left will render details of the employees corresponding to that department on the right. Which kind of report/form is this?

• A. Stacked Master Detail
• B. Interactive Report
• C. Cards
• D. Side by Side Master Detail

Answer: A

Explanation:
Explanation
A stacked master detail is a form type that displays two editable interactive grids based on two related tables or views on the same page. Users select a row in the master grid to update the detail grid6. In this scenario, the departments names with location on the left is the master grid and the employees details on the right is the detail grid. A cards report is not a form type, but a report type that displays data in cards with an image and text7. A side by side master detail is a form type that displays two editable interactive grids based on two related tables or views side by side on the same page. Users select multiple rows in the master grid to update multiple detail grids6. An interactive report is not a form type, but a report type that allows users to customize the report layout and filter data interactively5.

NEW QUESTION # 86
Choose the statement that is TRUE about Universal Theme.

• A. Universal theme is the default theme that is shipped with Oracle APEX
• B. Uses a 12-column grid layout system for arranging components on a page.Ships with a variety of pre-built theme styles
• C. Features a responsive design and enables developers to create web applications without extensive knowledge of HTML, CSS, or JavaScript
• D. All of them

Answer: D

Explanation:
Explanation
Universal Theme is a responsive, versatile, and customizable user interface for your APEX apps. It is designed uniquely for Oracle APEX to make it easy for developers to build beautiful, modern applications, at any scale, for any purpose, that work on any device. All of the statements given are true about Universal Theme:
Features a responsive design and enables developers to create web applications without extensive knowledge of HTML, CSS, or JavaScript. Universal Theme adapts to different screen sizes and devices using CSS media queries and grid layout. It also provides a rich set of UI components, template options, and theme styles that can be used declaratively without writing custom code.
Universal theme is the default theme that is shipped with Oracle APEX. Universal Theme is the default theme for new applications created in APEX 5.0 or later. It is also the recommended theme for upgrading existing applications to the latest version of APEX.
Uses a 12-column grid layout system for arranging components on a page. Ships with a variety of pre-built theme styles. Universal Theme uses a 12-column grid layout system based on Flexbox to arrange components on a page. It also ships with a variety of pre-built theme styles that can be applied to change the look and feel of the application.

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

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

Answer: C,D

NEW QUESTION # 88
Which two tasks can you perform using App Builder?

• A. Create and manage database objects.
• B. Import previously exported apps.
• C. Create join queries using drag and drop.
• D. Generate data definition language (DDL) statements from the Oracle data dictionary.
• E. Create and manage apps.

Answer: B,E

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 # 89
Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?

• A. Install Oracle APEX in the remote Oracle Database.
• B. On the remote Oracle Database, install ORDS 19.x or later.
• C. REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
• D. Create a database link to the remote Oracle Database in the local APEX Schema.

Answer: B,C

Explanation:
Explanation
The REST-enabled SQL feature in Oracle APEX allows developers to execute SQL statements and PL/SQL blocks on a remote Oracle Database by using REST services. The prerequisites to use this feature are:
On the remote Oracle Database, install ORDS 19.x or later.
REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
Create a REST Data Source with REST Enabled SQL as the REST Data Source Type in Oracle APEX.
Create an Authorization Scheme based on the REST Data Source in Oracle APEX. You do not need to create a database link to the remote Oracle Database or install Oracle APEX in the remote Oracle Database to use this feature. Verified References: [Using REST Enabled SQL - Oracle Help Center],
[REST Enabled SQL Service - Oracle Help Center]

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

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

Answer: C

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 # 91
What are Task definitions that exist on the application level inthe Shared Components section made up of?

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

Answer: D

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 # 92
......

Oracle 1Z0-770 exam is a certification exam aimed at those who wish to become an Oracle APEX Developer Professional. As a professional in Oracle APEX development, you will be responsible for designing, developing, and deploying enterprise-level web applications using the Oracle Application Express (APEX) platform. 1z1-770 exam is an excellent way to demonstrate your skills and knowledge in this area, and it is highly regarded by employers who are seeking individuals who can effectively leverage the Oracle APEX platform.

 

Free Oracle Database 1z1-770 Exam Question: https://www.itexamsimulator.com/1z1-770-brain-dumps.html

1z1-770 dumps & Oracle Database sure practice dumps: https://drive.google.com/open?id=19ontihbJpZ-9vYHcL9yffjh2gh98RfMn