Oracle 1Z0-770 Test Engine Dumps Training With 144 Questions
1Z0-770 Questions Pass on Your First Attempt Dumps for Oracle Database Certified
NEW QUESTION # 44
Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?
- A. REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
- B. Install Oracle APEX in the remote Oracle Database.
- C. On the remote Oracle Database, install ORDS 19.x or later.
- D. Create a database link to the remote Oracle Database in the local APEX Schema.
Answer: A,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 # 45
Which two are true about Oracle APEX?
- A. Performs the data processing in a middle-tier server
- B. Requires developers to be proficient in Java, Python and other programming languages.
- C. Is declarative. It requires no code generation.
- D. Requires no additional client software. A web browser is the app development IDE.
Answer: C,D
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 # 46
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. Popup LOV
- D. Checkbox Group
Answer: A,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 # 47
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. Side by Side Master Detail
- C. Interactive Report
- D. Cards
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 # 48
Choose the two correct statements about PWA.
- A. Enables users to install the application on devices
- B. Provides a customizable offline page when users areoffline and cannot request thenetwork.
- 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 # 49
While migrating apps, once the database objects are created in the target environment, you canload the data using which of the components?
- A. Data Workshop
- B. App Builder
- C. Quick SQL
- D. Data Generator
Answer: A
Explanation:
Explanation
Data Workshop is a feature in Oracle APEX that enables you to load and unload data to and from the database.
You can use Data Workshop to copy data between Oracle databases or between an Oracle database and external files. Data copying is accomplished by exporting and importing data, and by unloading and loading data. While migrating apps, once the database objects are created in the target environment, you can load the data using Data Workshop by following these steps:
Access Data Workshop by clicking Utilities and then Data Workshop in SQL Workshop.
Click Load Data.
Select a data source type, such as Text File (CSV), XML File (XML), Copy & Paste (Spreadsheet), or Object Store Reference (Autonomous Database only).
Specify a file name or location for your data source.
Select a table name for your data destination.
Map your data columns to your table columns.
Review your data load settings and click Load Data.
NEW QUESTION # 50
Which statement is true about Unified Task List in the Approvals component?
- A. It is a page that shows details for a specific task, which can include metadata, history, comments, and actions.
- B. It is a shared component used to configure task parameters, participants, actions, and due dates.
- 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 # 51
Choose the three types of aggregations you can apply on a column.
- A. Standard Deviation
- B. Average
- C. Count
- D. Sum
Answer: B,C,D
NEW QUESTION # 52
Which two types of pages behave similarly in functionality?
- A. Faceted Search
- B. Smart Filter
- C. Map
- D. Cards
Answer: A,B
Explanation:
Explanation
A Faceted Search and a Smart Filter are two types of pages that behave similarly in functionality. They both allow users to filter data based on multiple criteria and see the results in real time. They differ in the following aspects:
A Faceted Search uses facets to filter data. A facet is a set of filters based on a column or expression. A facet can be displayed as a list, a range slider, a star rating, or a chart.
A Smart Filter uses conditions to filter data. A condition is a logical expression that evaluates to true or false. A condition can be based on a column, an item, or a function.
The other options are incorrect because:
A Map is a type of region that displays spatial data on an interactive map. It allows users to zoom, pan, and select features on the map.
A Cards is a type of region that displays data in a grid of cards. Each card represents one row of data and can contain text, images, icons, or buttons.
Verified References: [About Faceted Search] [About Smart Filter] [About Maps] [About Cards]
NEW QUESTION # 53
Which three of the following options are TRUE about a page in an APEX application?
- A. To view the rendered version of the page, you run or submit it to the Oracle APEX engine.
- B. A page can be viewed and edited in the Page Designer.
- C. A page can contain buttons, page items and regions.
- D. An APEX application can have only one page.
Answer: A,B,C
NEW QUESTION # 54
Which two statements are TRUE about Dynamic Actions?
- A. Dynamic Actions require complex client side Javascript code
- B. More dynamic actions you add to a page, the greater your overall page size.
- C. Dynamic actions provide a way to define complex client-sidebehaviordeclaratively without the need for JavaScript.
- D. It is not possible to debug Dynamic Actions from the Developer Toolbar
Answer: B,C
Explanation:
Explanation
Dynamic actions provide a way to define complex client-side behavior declaratively without the need for JavaScript. You can create dynamic actions on items, buttons, or regions of a page by specifying an event, a condition, an action, and other properties1. However, more dynamic actions you add to a page, the greater your overall page size. This can affect the performance and user experience of your application2. It is possible to debug dynamic actions from the Developer Toolbar by using the Debug option3. Dynamic actions do not require complex client-side JavaScript code, but they can optionally include custom JavaScript code as an action or a condition1.
NEW QUESTION # 55
You added Access Control feature pages to your application. Which two actions can you perform as an Administrator using the Administration page?
- A. Create Authorization schemes
- B. Assign roles to users
- C. Create new application roles
- D. Add Users
Answer: B,D
Explanation:
Explanation
The Access Control feature pages are a set of pages that allow developers to implement role-based access control for an application. The Access Control feature pages consist of four pages: Administration, Users, Roles, and Role Assignments. The Administration page allows administrators to perform various tasks related to managing users and roles, such as:
Add Users: Administrators can add new users to the application by entering their username, email address, password, status, etc.
Assign roles to users: Administrators can assign one or more roles to users by selecting them from a list of available roles.
Edit Users: Administrators can edit user details such as username, email address, password, status, etc.
Delete Users: Administrators can delete users from the application by selecting them from a list of existing users.
Lock/Unlock Users: Administrators can lock or unlock users by changing their status from active to locked or vice versa. You cannot create authorization schemes or create new application roles using the Administration page. You can create authorization schemes by using Shared Components > Security > Authorization Schemes. You can create new application roles by using Shared Components > Security > Access Control > Roles. Verified References: [Using Access Control - Oracle Help Center], [Creating an Administration Page - Oracle Help Center]
NEW QUESTION # 56
You have an interactive grid component and you are enabling the Save Public Report attribute. As what can end users save the report type?
- A. As Public only
- B. As Private only
- C. As Private and public only
- D. As Primary only
Answer: C
Explanation:
Explanation
When you enable the Save Public Report attribute for an interactive grid, end users can save their report preferences as either private or public reports. Private reports are only visible to the user who created them, while public reports are visible to all users who have access to the interactive grid. You can also specify an authorization scheme to control who can save public reports. Verified References: Managing Interactive Grids
- Oracle Help Center, [Interactive Grid Attributes - Oracle Help Center]
NEW QUESTION # 57
What are the three types of Master Detail Form you can create in APEX?
- A. One Below the other
- B. Stacked
- C. Side by Side
- D. Two Page Drill Down
Answer: B,C,D
Explanation:
Explanation
A master detail form is a type of form that enables users to query, insert, update, and delete values from two related tables or views. A master detail form reflects a one-to-many relationship between tables in a database.
Typically, a master detail form displays a master row and multiple detail rows. In APEX, you can create three types of master detail forms using the Create Page Wizard or the Create Application Wizard:
Stacked: A stacked master detail form contains a single page with editable interactive grids based on two related tables or views. Users select a row in the master grid to update the detail grid. Developers can create a stacked master detail with either the Create Application Wizard or the Create Page Wizard.
Side by Side: A side by side master detail form contains a single page with two editable interactive grids based on two related tables or views. Users can see and edit both the master and detail grids at the same time. Developers can create a side by side master detail with either the Create Application Wizard or the Create Page Wizard.
Two Page Drill Down: A two page drill down master detail form contains two pages based on two related tables or views. The first page is a non-editable interactive grid for the master table. Users click the Edit icon on the first page to edit details on the second page. The second page includes both a standard form for the master and an editable interactive grid for the detail. Developers can create a two page drill down master detail with only the Create Page Wizard.
NEW QUESTION # 58
Choose the three correct options in the given friendly URL syntax:
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?
- A. 13766599855150 is the session ID. A new ID is generated for each session.
- B. session=13766599855150 Ahr-app is the application alias.
- C. mycompany is the path-prefix which is by default the workspace name
- D. update-employees is the PL/SQL procedure to update the employee details.
Answer: A,B,C
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 # 59
Select the two places from where you can access the Shared Components Page?
- A. Gallery
- B. Page Designer
- C. SQL Workshop
- D. Application homepage
Answer: B,D
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 # 60
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. REST Data Sources doesn't support any authentication
- D. AREST Data Source can contain one or many Operations which are the references toa concrete external web service
Answer: A,D
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 # 61
Select the three types of Facets you can create in APEX.
- A. Range
- B. Input Field
- C. Checkbox Group
- D. Text Area
Answer: A,B,C
Explanation:
Explanation
A facet is a type of component that provides a set of display values and return values for a faceted search region or a smart filters region. A facet can be based on either static values or dynamic values from a list of values (LOV). A facet can also have different display styles depending on its type and settings. Three of the types of facets that you can create in APEX are:
Range: A range facet displays numeric values in either buckets or sliders that users can select or adjust to filter the search results. A range facet can have either static values or dynamic values based on an LOV or SQL query.
Checkbox Group: A checkbox group facet displays multiple options that users can select or deselect to filter the search results. A checkbox group facet can have either static values or dynamic values based on an LOV or SQL query.
Input Field: An input field facet displays a text field that users can enter text to filter the search results.
An input field facet does not have any values but uses an operator to compare the user input with the data.
NEW QUESTION # 62
Which authentication scheme type supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards?
- A. Open Door Credentials
- B. HTTP Header Variable
- 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 # 63
An application includes a report and form on the PRODUCTS table.
The form page includes page items P21 PRODUCT NAME and P21_UNIT_PRICE.
P21_UNIT_PRICE is currently displayed below P21_PRODUCT_NAME.
Now, you need to reposition the items and display P21 UNIT_PRICE next to P21_PRODUCT_NAME.
Which two statements are true?
- A. In Page Designer, use the Middle Pane, click P21 UNIT PRICE and drag the item until it is directly next to P21 PRODUCT_NAME.
- B. In Page Designer, select P21_PRODUCT_NAME and then in the Property Editor, under Layout set Start New Row to Yes.
- C. In Page Designer, right-click P21_UNIT_PRICE and select Start New Row.
- D. In Page Designer, select P21_UNIT_PRICE and then in the Property Editor, under Layout set Start New Row to Yes.
Answer: A,D
Explanation:
Explanation
To reposition the page items and display P21_UNIT_PRICE next to P21_PRODUCT_NAME, you can use either of these methods:
In Page Designer, use the Middle Pane, click P21_UNIT_PRICE and drag the item until it is directly next to P21_PRODUCT_NAME. This method allows you to visually arrange the items on the page layout.
In Page Designer, select P21_UNIT_PRICE and then in the Property Editor, under Layout set Start New Row to Yes. This method changes the attribute of the item to start a new row in the grid layout. The other options, A and D, are incorrect because they would not achieve the desired result. Setting Start New Row to Yes for P21_PRODUCT_NAME would move it to a new row, not next to P21_UNIT_PRICE. Right-clicking P21_UNIT_PRICE and selecting Start New Row would not change the attribute of the item, but only move it to a new position in the Layout tab. Verified References: Positioning Page ItemsLayout Tab
NEW QUESTION # 64
Which component in SQL Workshop allows you to build queries graphically without manual SQLcoding?
- A. Data Workshop
- B. Query Builder
- C. SQL commands
- D. Quick SQL
Answer: B
Explanation:
Explanation
Query Builder is a component in SQL Workshop that allows you to build queries graphically without manual SQL coding. You can use Query Builder to select tables and views from your schema, join them using drag-and-drop operations, add filters andgroupings, and view the results in a grid or chart format. You can also switch to the SQL mode to view or edit the generated SQL statement.
The other options are incorrect because:
Quick SQL is a component in SQL Workshop that allows you to generate SQL scripts for creating tables and other database objects using shorthand syntax. You cannot use Quick SQL to build queries graphically.
SQL Commands is a component in SQL Workshop that allows you to run individual SQL statements or PL/SQL blocks interactively. You cannot use SQL Commands to build queries graphically.
Data Workshop is a component in SQL Workshop that allows you to load or unload data from the database using various file formats. You cannot use Data Workshop to build queries graphically.
Verified References: [About Query Builder] [Using Query Builder]
NEW QUESTION # 65
Choose the three Form types that you can create using the Create Page wizard.
- A. Interactive Grid
- B. Form
- C. Interactive Report
- D. Master Detail
Answer: A,B,D
Explanation:
Explanation
The Create Page wizard supports three form types that you can create: Interactive Grid, Form, and Master Detail4. An interactive grid is a report that allows users to view and edit data in a tabular format. A form is a page that enables users to update a single row in a database table or view. A master detail is a page that reflects a one-to-many relationship between two tables or views4. 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 # 66
Which two statements are true about loading data from the "Create an Application From a File" wizard?
- A. CSV, XLSX, XML, TXT, or JSON files can be uploaded.
- B. XML and JSON data can be pasted and loaded.
- C. Data from remote web services can be uploaded.
- D. Seed data from a SQL script can be uploaded.
- E. A sample data set from the sample list can be uploaded.
Answer: A,E
Explanation:
Explanation
The "Create an Application From a File" wizard is a tool that allows developers to create an application based on an existing spreadsheet file or sample data set. Some of the statements that are true about loading data from this wizard are:
A sample data set from the sample list can be uploaded. You can use the Sample Data Sets option to select a predefined data set from a list of available samples, such as Employees, Products, Projects, etc.
CSV, XLSX, XML, TXT, or JSON files can be uploaded. You can use the Upload a File option to upload a spreadsheet file in one of these formats and create an application based on its data. You cannot upload seed data from a SQL script, paste and load XML and JSON data, or upload data from remote web services using this wizard. You can use other features in App Builder or SQL Workshop to perform these actions, such as SQL Scripts, RESTful Services, etc. VerifiedReferences: [Creating an Application From a File - Oracle Help Center], [Creating an Application Based on Sample Data Sets - Oracle Help Center]
NEW QUESTION # 67
From SQL Workshop, you can perform which two of the following actions?
- A. Delete database
- B. Run SQL commands and scripts
- C. Create an APEX user
- D. Create and view database objects
Answer: B,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 # 68
......
Oracle 1Z0-770 certification exam is designed to validate the skills and knowledge of professionals who are interested in becoming Oracle APEX Developer Professionals. Oracle Application Express (APEX) is a low-code development platform that enables developers to build secure, scalable, and feature-rich applications rapidly. The Oracle 1Z0-770 certification exam is intended for individuals who have experience in developing APEX applications and want to demonstrate their knowledge and expertise.
1Z0-770 Practice Test Pdf Exam Material: https://www.itcertmagic.com/Oracle/real-1Z0-770-exam-prep-dumps.html
1Z0-770 Answers 1Z0-770 Free Demo Are Based On The Real Exam: https://drive.google.com/open?id=1PMf5iar_8CMI7xFvEUi_4jJ9BUKTVYIC