Best Oracle 1Z0-770 2024 Training With 144 QA's
Oracle 1Z0-770 Certification Exam Questions
The 1Z0-770 exam consists of 60 multiple-choice questions that must be answered within 105 minutes. 1Z0-770 exam covers topics such as Oracle APEX architecture, security, data modeling, page design, and application deployment. Candidates are expected to have a strong understanding of SQL and PL/SQL, as well as experience with Oracle database administration. Successful candidates should possess the skills necessary to design and develop complex, multi-tier applications using Oracle APEX.
Oracle 1Z0-770 exam covers various topics related to APEX development, including building web applications, designing database schemas, creating interactive reports and grids, and implementing security measures. 1Z0-770 exam is designed to test the candidate's ability to develop efficient and robust APEX applications that meet business requirements.
NEW QUESTION # 23
Which two actions can you perform using the Object Browser?
- A. Restore dropped database objects.
- B. Browse database objects of the current schema.
- C. Export and import SQL scripts.
- D. Create a lookup table based on a column in the current table.
- E. Create and run SQL scripts.
Answer: B,D
Explanation:
Explanation
Object Browser is a utility in SQL Workshop that enables developers to browse, create, and edit objects in a database. Some of the actions that you can perform using Object Browser are:
Browse database objects of the current schema. You can view the details of an object by selecting it from the Object Tree and then clicking the different object detail tabs.
Create a lookup table based on a column in the current table. You can use the Create Lookup Table option in the Column Details tab to create a new table that stores the distinct values of the selected column and a foreign key constraint to reference it. You cannot restore dropped database objects, create and run SQL scripts, or export and import SQL scripts using Object Browser. You can use other utilities in SQL Workshop to perform these actions, such as Recycle Bin,SQL Commands, and SQL Scripts.
Verified References: [Managing Database Objects with Object Browser - Oracle Help Center], [Creating Lookup Tables - Oracle Help Center]
NEW QUESTION # 24
Choose the three requirements for creating a REST Enabled SQL Reference.
- A. Install Oracle REST Data Services (ORDS) 19.x or later.
- B. Configure and enable the REST Enabled SQL service feature
- C. Set up any remote database
- D. Activate REST Enabled SQL for the target schema on the remote database
Answer: A,B,D
Explanation:
Explanation
To create a REST Enabled SQL Reference, you need to meet the following requirements:
Install Oracle REST Data Services (ORDS) 19.x or later. ORDS is a Java application that enables developers to create, publish, and manage RESTful web services for Oracle databases1.
Activate REST Enabled SQL for the target schema on the remote database. REST Enabled SQL is a feature of ORDS that allows you to execute any SQL or PL/SQL through a REST endpoint. You need to enable this feature for the schema that contains the data you want to access2.
Configure and enable the REST Enabled SQL service feature. This is a workspace-level setting that allows you to use REST Enabled SQL references in your APEX applications. You need to specify a path prefix and a secret for the REST Enabled SQL service3.
You do not need to set up any remote database, as long as it meets the ORDS and REST Enabled SQL requirements. You can use any Oracle database or MySQL database as a remote data source2.
NEW QUESTION # 25
Choose the three correct options in the given friendly URL syntax:
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?
- A. session=13766599855150 Ahr-app is the application alias.
- B. 13766599855150 is the session ID. A new ID is generated for each session.
- 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 # 26
Which statement is true about importing an APEX application?
- A. The import process does not import the supporting objects defined during the export.
- B. You cannot import an APEX application exported from a latest APEX version to an old APEX version.
- C. You cannot change the application ID during the import process.
Answer: B
Explanation:
Explanation
As a general rule, you cannot import an application created in a newer release of APEX into an earlier version.
This is because the newer release may have features or attributes that are not supported or recognized by the older version. For example, you cannot import an application created in APEX 21.2 into APEX 19.2.
However, you can import an application created in an older release into a newer one, as long as the application is compatible with the newer release. For example, you can import an application created in APEX 18.2 into APEX 21.2, but you may need to upgrade or modify some components to use the latest features.
NEW QUESTION # 27
Which two statements are true about a Progressive Web Application (PWA)?
- A. PWA features will be rendered even if the application is served in an unsecured environment.
- B. Enabling the PWA functionality optimizes page loading speed on a mobile device.
- C. You can create a PWA only when creating a new application with the Create Application Wizard.
- D. Enabling the PWA functionality in your APEX app adds a new navigation bar entry named Install App to your app.
- E. To use the PWA feature, the Friendly URLS attribute in the Application Definition, Properties section must be turned Off.
Answer: B,D
Explanation:
Explanation
A Progressive Web Application (PWA) is a web application that uses modern web technologies and best practices to provide a native app-like experience to users. Enabling the PWA functionality in your APEX app has the following benefits:
It optimizes page loading speed on a mobile device by caching static resources and using service workers to handle network requests.
It adds a new navigation bar entry named Install App to your app, which allows users to install the app on their device's home screen and access it offline.
It enhances the app's appearance and behavior by using a manifest file to specify the app's name, icon, theme color, orientation, and display mode.
The other options are incorrect because:
To use the PWA feature, the Friendly URLS attribute in the Application Definition, Properties section must be turned On. This attribute enables user-friendly URLs that are required for PWA functionality.
PWA features will not be rendered if the application is served in an unsecured environment. The application must use HTTPS protocol to enable PWA functionality.
You can create a PWA from an existing application or a new application with the Create Application Wizard. You just need to enable the PWA functionality in the User Interface section of the Application Definition.
Verified References: Progressive Web ApplicationsEnabling Progressive Web Application Functionality
NEW QUESTION # 28
What are the three features of a calendar in APEX?
- A. Previous - Navigates to the previous month.
- B. Month, Week, Day - Displays a monthly, weekly and daily view.
- C. Next - Navigates to the next month.
- D. Reminders - Displays the reminders set by the users
Answer: A,B,C
Explanation:
Explanation
A calendar is a type of component that enables users to view and manage data based on dates. A calendar can display data in different views, such as monthly, weekly, daily, or list. Users can also interact with the calendar by creating, editing, or deleting events, or by using drag and drop functionality. Three of the features of a calendar in Oracle APEX are:
Next - Navigates to the next month. This feature allows users to move forward in time and see the events for the following month.
Previous - Navigates to the previous month. This feature allows users to move backward in time and see the events for the previous month.
Month, Week, Day - Displays a monthly, weekly and daily view. These features allow users to switch between different views of the calendar and see the events for a specific month, week, or day.
NEW QUESTION # 29
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. Master Detail
- C. Unified Task List
- D. Interactive Grid
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 # 30
An Employees App includes a form to enter and update employee details.
Examine this Exhibit.
Now you must extend the functionality of this form so that:
* If you select 'SALESMAN' from the select list for Job page item (P2_JOB), both the 'Hire date' (P2_HIREDATE) and 'Commission' (P2_COMM) page items and their associated labels are displayed
* If you select any other value from the select list for Job page item (P2_JOB), both the 'Hire date' (P2_HIREDATE) and 'Commission' (P2_COMM) page items and their associated labels are hidden Which two steps must be performed?
- A. Create a dynamic action on P2_JOB, P2_HIREDATE, and P2_COMM.
- B. Create a dynamic action on P2_JOB.
- C. Create a dynamic action on form load.
- D. ......... and enter SALESMAN for Value.
- E. Create a dynamic action on P2_HIREDATE and P2_COMM.
Answer: B,D
Explanation:
Explanation
To extend the functionality of the form as required, you need to create a dynamic action on P2_JOB that shows or hides P2_HIREDATE and P2_COMM based on its value. The steps are as follows:
Create a dynamic action on P2_JOB by right-clicking it in Page Designer and selecting Create Dynamic Action.
Set Name to Show/Hide Hire Date and Commission.
Set Event to Change.
Set Selection Type to Item(s).
Set Item(s) to P2_JOB.
Set Condition Type to Equal To.
Set Value to SALESMAN.
Add two true actions by clicking the Add True Action button twice.
For the first true action, set Action to Show.
Set Affected Elements > Selection Type to Item(s).
Set Affected Elements > Item(s) to P2_HIREDATE,P2_COMM.
For the second true action, set Action to Show.
Set Fire On Initialization to Yes.
Set Affected Elements > Selection Type to jQuery Selector.
Set Affected Elements > jQuery Selector to label[for="P2_HIREDATE"],label[for="P2_COMM"].
Add two false actions by clicking the Add False Action button twice.
For the first false action, set Action to Hide.
Set Affected Elements > Selection Type to Item(s).
Set Affected Elements > Item(s) to P2_HIREDATE,P2_COMM.
For the second false action, set Action to Hide.
Set Fire On Initialization to Yes.
Set Affected Elements > Selection Type to jQuery Selector.
Set Affected Elements > jQuery Selector to label[for="P2_HIREDATE"],label[for="P2_COMM"].
This dynamic action will show or hide both the page items and their labels depending on whether P2_JOB is equal to SALESMAN or not. Verified References: [Creating a Dynamic Action in Oracle Apex - OrclQA.Com], [Managing Dynamic Actions - Oracle Help Center]
NEW QUESTION # 31
What three are the building blocks of Approvals Component?
- A. Unified Task List
- B. Task Definition
- C. Automations
- D. Task Details Page
Answer: A,B,D
Explanation:
Explanation
The Approvals Component is Oracle APEX's new offering as part of the 22.1 Release. It allows seamless management of approvals across APEX Applications. Approvals are commonly used in business situations involving Expense Reimbursements, Leave Requests, Purchase Requisitions, On-boarding of Employees to name a few. The Approvals Component provides the following building blocks for the approvals functionality:
Task Definition: A shared component for configuring task parameters, participants, and actions. A task definition defines the template for creating tasks based on a specific type of approval request, such as Leave Approval or Purchase Requisition. A task definition specifies the data source, display attributes, potential owners, business administrators, and available actions for the tasks.
Task Details Page: A page that shows task details, which can include metadata, history, comments, and actions. A task details page allows users to view and take action on a specific task, such as approve, reject, reassign, or escalate. A task details page can be created using the Create Page Wizard or the Quick SQL tool in APEX.
Unified Task List: A page type in the Create Page Wizard, used to create a summary of a user's tasks that functions like an inbox. A unified task list allows users to see and manage all their tasks in one place. Users can filter, sort, search, claim, release, or open tasks from the unified task list.
NEW QUESTION # 32
In a Classic Report, an end user can perform which two of the following actions?
- A. Rearrange the columns in the report
- B. Filter values of a column in the report
- C. Create Control Breaks in the report
- D. Sort the columns of the report
Answer: B,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 # 33
Which three of the following statements are TRUE about Data Synchronization?
- A. Helps in Providing efficient reporting on large data sets coming from a REST service
- B. You must trigger Data Synchronization manually
- C. Data Synchronization enables developers to automatically sync the contents of a local table with the data from a REST service.
- D. APEX can create the local table based on the visible columns in the REST Data Source Data Profile.
Answer: A,C,D
Explanation:
Explanation
Data Synchronization enables developers to automatically sync the contents of a local table with the data from a REST service. APEX invokes the REST service defined in the REST Data Source, downloads all data and synchronizes it to a local table6. Data Synchronization has several benefits, such as:
APEX can create the local table based on the visible columns in the REST Data Source Data Profile. Since the table is physically available in the database schema, developers can add indexes, change physical properties, or even add more columns6.
Data Synchronization helps in providing efficient reporting on large data sets coming from a REST service. Some REST services can return large amounts of result data that include pagination. If a reporting requirement needs larger data sets, this would lead to multiple HTTP requests and poorer response times. Also, no indexes or other database features can be used to speed up reporting queries. In this case, synchronizing the remote data to a local table and having the reports working on local tables can improve performance and user experience6.
Data Synchronization can also collect data from REST services for consumption by PL/SQL packages or other logic. If data from the REST service is replicated to local tables, developers will be able to perform all sorts of processing and also generate different types of reports6.
You do not have to trigger Data Synchronization manually, as you can also schedule it to run periodically using a DBMS_SCHEDULER expression6.
NEW QUESTION # 34
Which statement is true about Unified Task List in the Approvals component?
- A. It is a shared component used to configure task parameters, participants, actions, and due dates.
- B. It is a page that shows details for a specific task, which can include metadata, history, comments, and actions.
- C. It is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox.
Answer: C
Explanation:
Explanation
The Approvals component in Oracle APEX is a feature that allows developers to create approval workflows for business processes that require human intervention or decision making. The Approvals component consists of three main elements: Tasks, Task List Page, and Task Details Page. The Unified Task List is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox for end users.
The Unified Task List displays all tasks assigned to or created by an end user along with their status, priority, due date, etc. End users can filter, sort, search, view details, and perform actions on tasks from this page.
Verified References: [Using Approvals - Oracle Help Center], [Creating a Unified Task List Page - Oracle Help Center]
NEW QUESTION # 35
What three components must be considered whilemigrating an APEX app betweenenvironments?
- A. Move the sessions data
- B. Move the images
- C. Move the database objects
- D. Move the application definition and all associated files
Answer: B,C,D
Explanation:
Explanation
To migrate an APEX app between environments, such as from development to production, you need to consider three components that make up an APEX app:
Database objects: These are the tables, views, procedures, functions, packages, triggers, sequences, synonyms, and other schema objects that store or manipulate the data used by the app. You need to move these objects from the source schema to the target schema using tools such as SQL Developer, Data Pump Export/Import, or Data Workshop.
Images: These are the static files, such as images, CSS files, JavaScript files, or PDF files, that are used by the app for display or download purposes. You need to move these files from the source web server to the target web server using tools such as FTP, SCP, or File Explorer.
Application definition and all associated files: These are the metadata files that define the app components, such as pages, regions, items, buttons, processes, validations, computations, dynamic actions, shared components, and so on. You also need to include any supporting object definitions or data scripts that are used to create or populate database objects for the app. You need to move these files from the source APEX instance to the target APEX instance using tools such as App Builder Export/Import or One-click Remote Application Deployment.
NEW QUESTION # 36
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 # 37
Which two statements are true about the APEX MAIL API?
- A. You can send emails using the APEX MAIL package from an Oracle APEX application.
- B. You can receive emails using the APEX_MAIL package in an Oracle APEX application
- C. You can add files as attachments to your emails using the APEX_MAIL package.
- D. The APEX_MAIL package supports sending emails only to Oracle database users.
Answer: A,C
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 # 38
When you create a Dynamic Action, you specify the event that causes the dynamic action to fire.
Choose the categories these events are classified into.
- A. Framework Events
- B. All of them
- C. Component Events
- D. Browser Events
- E. Custom Events
Answer: B
Explanation:
Explanation
The events that cause the dynamic action to fire are classified into five categories: Browser Events, Component Events, Custom Events, Framework Events, and jQuery Events1. Browser events are triggered by user interactions with the browser window, such as resize, scroll, or unload. Component events are triggered by user interactions with specific APEX components, such as interactive grids, interactive reports, or trees.
Custom events are user-defined events that can be triggered by other dynamic actions or JavaScript code.
Framework events are triggered by APEX framework actions, such as page load, page submit, or dialog close. jQuery events are triggered by user interactions with jQuery UI widgets, such as accordion, tabs, or date picker1.
NEW QUESTION # 39
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 # 40
Which two statements are true about loading data from the "Create an Application From a File" wizard?
- A. Seed data from a SQL script can be uploaded.
- B. Data from remote web services can be uploaded.
- C. XML and JSON data can be pasted and loaded.
- D. A sample data set from the sample list can be uploaded.
- E. CSV, XLSX, XML, TXT, or JSON files can be uploaded.
Answer: D,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 # 41
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 # 42
Which statement is true about creating and using a report with form?
- A. Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination.
- B. The Create Application Wizard doesn't support the creation of an interactive report and form combination.
- C. The Create Page Wizard doesn't support the creation of a classic report and formcombination
- D. In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source).
Answer: A
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 # 43
Which two statements are true about creating and managing an APEX Workspace?
- A. During workspace creation, you can associate the workspace with an existing databaseschema.
- B. You can create only two workspaces in an APEX Service(APEX Application Development)instance.
- C. New schemas cannot be created during workspace creation.
- D. A workspace enables multiple users to work within the same Oracle APEX installation.
- E. A workspace can be associated with only one schema.
Answer: A,D
Explanation:
Explanation
A workspace is a logical work area that enables multiple users to work within the same Oracle APEX installation while keeping their objects, data, and applications private. Creating and managing an APEX workspace involves the following statements:
During workspace creation, you can associate the workspace with an existing database schema or create a new schema for the workspace. A schema is a collection of database objects such as tables, views, indexes, etc. that belong to a user.
A workspace enables multiple users to work within the same Oracle APEX installation. Each user can have a different role and privilege in the workspace, such as workspace administrator, developer, or end user.
A workspace can be associated with one or more schemas. You can add or remove schemas from a workspace after it is created.
You can create as many workspaces as you need in an APEX Service (APEX Application Development) instance. There is no limit on the number of workspaces per instance.
Verified References: Managing WorkspacesAbout Workspaces
NEW QUESTION # 44
......
Quickly and Easily Pass Oracle Exam with 1Z0-770 real Dumps: https://www.premiumvcedump.com/Oracle/valid-1Z0-770-premium-vce-exam-dumps.html
Realistic 1Z0-770 Dumps Questions To Gain Brilliant Result: https://drive.google.com/open?id=1Gc-1Hr5NUmQFFhoZSBK7lBgERbhrx0--