Updated May 12, 2025 1Z0-770 Exam Dumps - PDF Questions and Testing Engine
New (2025) Oracle 1Z0-770 Exam Dumps
Oracle APEX Developer Professional certification is designed to validate the skills and knowledge of professionals who develop applications using Oracle Application Express (APEX). Oracle APEX is a low-code, web-based development platform that enables developers to create scalable and secure enterprise applications with ease. The Oracle 1Z0-770 exam is the certification exam for Oracle APEX Developer Professional.
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.
NEW QUESTION # 58
You can create an APEX workspace and build APEX apps on which of the following platforms?
- A. Oracle Autonomous Cloud
- B. Microsoft Azure
- C. Oracle XE
- D. Amazon RDS
- E. All of the above
Answer: E
Explanation:
Explanation
You can create an APEX workspace and build APEX apps on any of the following platforms:
Oracle Autonomous Cloud: This is a cloud platform that provides various services such as Autonomous Database, Oracle Cloud Infrastructure, and Oracle APEX Application Development. You can create an APEX workspace and build APEX apps on an Autonomous Database instance or an APEX Service instance.
Oracle XE: This is a free edition of Oracle Database that supports up to 12 GB of user data. You can install Oracle XE on your local machine and use it to create an APEX workspace and build APEX apps.
Amazon RDS: This is a cloud service that provides managed relational databases. You can create an APEX workspace and build APEX apps on an Amazon RDS for Oracle instance that supports Oracle APEX.
Microsoft Azure: This is a cloud platform that provides various services such as virtual machines, storage, and networking. You can create an APEX workspace and build APEX apps on a Microsoft Azure VM that runs Oracle Database and Oracle APEX.
Verified References: Oracle Autonomous CloudOracle XEAmazon RDSMicrosoft Azure
NEW QUESTION # 59
Which two statements that are TRUE about charts in Interactive grid?
- A. To remove a chart, click the Remove Chart icon (X) adjacent to the chart filter
- B. Once a chart is created, you can switch the view between Grid and Chart view.
- C. You can create multiple charts at a time in an interactive grid
- D. Once the chart is created, it cannot be reconfigured.
Answer: A,B
Explanation:
Explanation
You can create a chart in an interactive grid by selecting Chart in the Actions menu. You can only create one chart at a time in an interactive grid. To create a second chart, you have to reconfigure or delete the existing chart1. To remove a chart, you can click the Remove Chart icon (X) adjacent to the chart filter12. Once a chart is created, you can switch the view between Grid and Chart by clicking the toggle that appears at the top of the interactive grid
NEW QUESTION # 60
Which three of the following are use cases of Automations?
- A. Deleting a database record based on an end user's request
- B. Sending email alerts at a particular time of the week
- C. Monitoring log tables and raising an alert when there is an issue
- D. Approving specific requests
Answer: B,C,D
Explanation:
Explanation
Automations are a sequential set of PL/SQL actions that are triggered by query results. They are used to monitor data and then perform the appropriate action2. Some use cases of automations are:
Monitoring log tables and raising an alert when there is an issue. For example, an automation can query a log table for any errors and send an email notification to the administrator if any errors are found2.
Approving specific requests. For example, an automation can query a table for any pending requests and approve them automatically based on some criteria2.
Sending email alerts at a particular time of the week. For example, an automation can query a table for any overdue tasks and send a reminder email to the assignees every Monday2.
Deleting a database record based on an end user's request is not a use case of automations, as it does not involve querying data and triggering actions based on the query results. This can be achieved by using a PL/SQL process or a dynamic action on the page where the user requests the deletion34.
NEW QUESTION # 61
Using the App Builder component, you can perform which three tasks?
- A. Edit pages in the page designer
- B. Install a sample App
- C. Create a new App
- D. Run SQL scripts and commands
Answer: A,B,C
Explanation:
Explanation
Using the App Builder component, you can perform the following tasks:
Edit pages in the page designer: You can use the Page Designer tool to modify the pages in your application using drag-and-drop operations, property editors, and code editors. You can also preview how your pages will look on different devices.
Install a sample app: You can use the Gallery option to install a sample app from a list of pre-built applications that demonstrate various features and best practices of Oracle APEX. You can also use the Packaged Apps option to install a packaged app from a list of ready-to-use applications that provide common functionality and solutions.
Create a new app: You can use the Create App option to create a new app from scratch or from an existing data source using the Create Application Wizard. You can also use the From a File option to create a new app from a file that contains data or metadata.
The other option is incorrect because:
Run SQL scripts and commands: You cannot use the App Builder component to run SQL scripts and commands. You can use the SQL Workshop component to run SQL scripts and commands using the SQL Commands or SQL Scripts tools.
Verified References: [About App Builder] [Using Page Designer] [Installing Sample Apps] [Installing Packaged Apps] [Creating Applications]
NEW QUESTION # 62
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. Open Door Credentials
- C. Custom Authentication
- D. No Authentication
Answer: B
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 # 63
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. Data Synchronization enables developers to automatically sync the contents of a local table with the data from a REST service.
- C. You must trigger Data Synchronization manually
- D. APEX can create the local table based on the visible columns in the REST Data Source Data Profile.
Answer: A,B,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 # 64
Which two statements are true about loading data from the "Create an Application From a File" wizard?
- A. Data from remote web services can be uploaded.
- B. Seed data from a SQL script can be uploaded.
- C. CSV, XLSX, XML, TXT, or JSON files can be uploaded.
- D. XML and JSON data can be pasted and loaded.
- E. A sample data set from the sample list can be uploaded.
Answer: C,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 # 65
The APEX engine uses which component as a key for tracking each user's session state?
- A. APEX_USER
- B. APP_USER
- C. LDAP_USER
- D. HTTP_USER
Answer: B
Explanation:
Explanation
APP_USER is a built-in substitution string in Oracle APEX that stores the user name of the current user session. The APEX engine uses APP_USER as one component of a key for tracking each user's session state.
As a user navigates from page to page, the APEX engine sets the value of APP_USER to identify the user. The APEX engine also uses APP_USER to perform security checks and conditional processing. You can reference APP_USER using different syntax depending on the context, such as SQL, PL/SQL, or static text.
NEW QUESTION # 66
From SQL Workshop, you can perform which two of the following actions?
- A. Create and view database objects
- B. Create an APEX user
- C. Delete database
- D. Run SQL commands and scripts
Answer: A,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 # 67
Which two statements are true about Maps in Oracle APEX?
- A. Background maps do not require any API keys.
- B. Maps don't support REST Data Sources
- C. Maps support REST Enabled SQL
- D. Heat Map and Polygons are not supported Spatial geometry objects
Answer: A,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 # 68
There is a validation of type Item is numeric on the P1_SALARY item. When the page is submitted, this or message is displayed both in the notification and below the item: What will cause the validation error to appear only in the Notification area?
- A. Setting the value Required to Yes on P1_SALARY
- B. Removing P1_SALARY from the validation Associated Item
- C. Setting Display Location to Inline in Notification
Answer: B
Explanation:
Explanation
A validation is a rule that checks the data entered by end users before processing it. A validation of type Item is numeric checks if a page item value is a valid number. When the page is submitted, if the validation fails, an error message is displayed both in the notification area (atthe top of the page) and below the item (next to the item label). To cause the validation error to appear only in the notification area, you need to remove P1_SALARY from the validation Associated Item attribute. The Associated Item attribute specifies which page item is associated with the validation and where to display the error message if the validation fails.
Setting the value Required to Yes on P1_SALARY or setting Display Location to Inline in Notification will not affect the validation error display. Verified References: [Creating Validations - Oracle Help Center],
[Validation Attributes - Oracle Help Center]
NEW QUESTION # 69
Which of the following options in the Developer Toolbar enables you to customize the look and feel of the application?
- A. Quick Edit
- B. Debug
- C. Session
- D. Customize
Answer: D
Explanation:
Explanation
The Developer Toolbar is a component that appears at the bottom of every page in an Oracle APEX application when running in development mode. The Developer Toolbar provides quick access to various features and tools for developing and debugging an application. One of the options in the Developer Toolbar that enables developers to customize the look and feel of the application is Customize.
Customize: This option opens the Theme Roller tool that allows developers to modify the theme style of the application by changing colors, fonts, sizes, borders, shadows, and more. Developers can also create new theme styles or switch between existing ones using this option.
NEW QUESTION # 70
Which statement is true about importing an APEX application?
- A. You cannot change the application ID during the import process.
- B. The import process does not import the supporting objects defined during the export.
- C. You cannot import an APEX application exported from a latest APEX version to an old APEX version.
Answer: C
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 # 71
You use the Create Page Wizard to create a faceted search page on the EMP table. What is the default report type generated for this page?
- A. Classic Report
- B. Interactive Report
- C. Column Toggle Report
- D. Interactive Grid
Answer: A
Explanation:
Explanation
When you use the Create Page Wizard to create a faceted search page on any table or SQL query, such as EMP table, APEX generates a classic report region as default report type for this page. A classic report region displays data from a SQL query or PL/SQL function returning a SQL query in tabular format. A faceted search page also contains a region of Faceted Search type, which holds one or more facets that allow end users to filter data by applying one or more facets. Verified References: Creating Faceted Search Pages - Oracle Help Center, Creating Classic Reports - Oracle Help Center
NEW QUESTION # 72
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, right-click P21_UNIT_PRICE and select Start New Row.
- 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, select P21_UNIT_PRICE and then in the Property Editor, under Layout set Start New Row to Yes.
- D. In Page Designer, use the Middle Pane, click P21 UNIT PRICE and drag the item until it is directly next to P21 PRODUCT_NAME.
Answer: C,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 # 73
Which search type in Search Configurations provides linguistic and fuzzy search capabilities?
- A. Standard
- B. List
- C. Oracle Text
Answer: C
Explanation:
Explanation
Search Configurations is a feature that allows developers to define how end users can search for data in an application. There are three types of search configurations: Standard, List, and Oracle Text. Oracle Text is a search type that provides linguistic and fuzzy search capabilities by using an Oracle Text index on a table column or view column. Linguistic search enables end users to search for data based on language-specific rules and preferences, such as stemming, stopwords, synonyms, etc. Fuzzy search enables end users to search for data based on approximate matches that account for spelling errors, typos, OCR errors, etc. Verified References: [Managing Search Configurations - Oracle Help Center], [Oracle Text User's Guide]
NEW QUESTION # 74
To highlight certain rows in the interactive report based on a condition, you must:
- A. Provide a conditional SQL query
- B. Edit the rows in the report and select a color
- C. Rows cannot be highlighted in an Interactive report
- D. Choose a condition in Format > Highlight
Answer: D
Explanation:
Explanation
To highlight certain rows in the interactive report based on a condition, you must choose a condition in Format
> Highlight. This option allows you to apply a conditional formatting rule to the report, which changes the appearance of the rows that match the condition. You can specify the condition type, expression, column, operator, and value. You can also choose the highlighting style, such as background color, text color, or icon.
The other options are incorrect because:
Provide a conditional SQL query: This option will not highlight certain rows in the interactive report based on a condition. It will filter the data in the report by applying a WHERE clause to the SQL query that defines the report source.
Edit the rows in the report and select a color: This option will not highlight certain rows in the interactive report based on a condition. It will modify the data in the report by using inline editing or modal dialog editing. You cannot select a color for the rows in this option.
Rows cannot be highlighted in an Interactive report: This option is false. Rows can be highlighted in an Interactive Report by using the Format > Highlight option.
Verified References: [Customizing Interactive Reports] [Highlighting Rows Based on Conditions]
NEW QUESTION # 75
Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?
- A. Create a database link to the remote Oracle Database in the local APEX Schema.
- B. REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
- C. Install Oracle APEX in the remote Oracle Database.
- D. On the remote Oracle Database, install ORDS 19.x or later.
Answer: B,D
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 # 76
In an Employee form, the 'Commission' and 'Hire Date' fields are enabled only if the Job is
'Salesman'. This can be achieved by which feature of APEX?
- A. PL/SQL procedure
- B. Dynamic Actions
- C. Processing
- D. Conditional SQL
Answer: B
Explanation:
Explanation
In an Employee form, the 'Commission' and 'Hire Date' fields are enabled only if the Job is 'Salesman'. This can be achieved by using Dynamic Actions in APEX. Dynamic Actions are declarative components that define client-side behavior without writing JavaScript code. You can create Dynamic Actions on items, buttons, or regions of a page by specifying an event, a condition, an action, and other properties. In this scenario, you can create a Dynamic Action on Job item with Change as event, Execute JavaScript Code as action, and use jQuery to enable or disable Commission and Hire Date fields based on Job value. Processing, Conditional SQL, and PL/SQL procedure are not features of APEX that can achieve this requirement without writing JavaScript code.
NEW QUESTION # 77
What are the three key features of Universal Theme?
- A. Versatile UI Components
- B. Easy Customization
- C. Responsive Design
- D. Support for single theme
Answer: A,B,C
Explanation:
Explanation
Universal Theme has many features that make it an ideal user interface for Oracle APEX applications. Three of the key features of Universal Theme are:
Versatile UI Components: Universal Theme provides a rich set of UI components that can be used to create interactive and engaging applications. Some of the UI components include cards, lists, charts, calendars, maps, timelines, accordions, tabs, modals, alerts, and more.
Responsive Design: Universal Theme adapts to different screen sizes and devices using CSS media queries and grid layout. It ensures that the applications look good and work well on any device, from desktops to tablets to smartphones.
Easy Customization: Universal Theme allows developers to customize the appearance and behavior of their applications using template options and theme styles. Template options enable developers to apply different styles to components on a page without writing custom code. Theme styles enable developers to change the overall look and feel of the application by choosing from a variety of pre-built styles or creating their own.
NEW QUESTION # 78
......
To prepare for the Oracle 1Z0-770 certification exam, candidates are recommended to have a strong understanding of SQL and PL/SQL, as well as experience with Oracle Database. In addition, Oracle provides training courses and study materials, including practice exams, to help candidates prepare for the exam.
Updated Verified Pass 1Z0-770 Exam - Real Questions and Answers: https://www.pass4guide.com/1Z0-770-exam-guide-torrent.html
Best Way To Study For Oracle 1Z0-770 Exam Brilliant 1Z0-770 Exam Questions PDF: https://drive.google.com/open?id=1UZZoJEYi7EH0Na-oJ_sgJEmHypYF1F9o