Verified 1Z0-770 Exam Dumps PDF [2025] Access using Exams-boost
Try Best 1Z0-770 Exam Questions from Training Expert Exams-boost
NEW QUESTION # 84
Which two statements are true about REST Data Sources?
- A. Oracle APEX doesn't provide direct integration of REST Data Sources in interactivereports
- B. Oracle APEX supports the REST Enabled SQL Query REST Data Source type
- C. AREST Data Source can contain one or many Operations which are the references toa concrete external web service
- D. REST Data Sources doesn't support any authentication
Answer: B,C
Explanation:
Explanation
A REST Data Source is a logical representation of an external web service in Oracle APEX. It can contain one or many Operations, which are the references to a concrete external web service endpoint. Oracle APEX supports three types of REST Data Sources: REST Enabled SQL Query, Web Source Module, and Generic REST Data Source. Oracle APEX provides direct integration of REST Data Sources in interactive reports and grids, as well as other components. REST Data Sources can support various authentication methods, such as Basic, OAuth2, or Custom. References: [Understanding REST Data Sources] and [Creating a REST Data Source]
NEW QUESTION # 85
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 unload data from the database.
- C. In SQL Commands, you can view queries saved in Query Builder.
- D. You can search and filter database objects.
Answer: B
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 # 86
Which three of the following statements are TRUE about saved Public Interactive Grids?
- A. Only the user who creates a public interactive grid can save, rename, or delete it
- B. Any user may save public interactive grids
- C. Public reports are available to all users
- D. To enable an end user to save a public interactive grid, the user must have the required permission
Answer: A,C,D
Explanation:
Explanation
Public reports are available to all users who can access the interactive grid1. However, to enable an end user to save a public interactive grid report, the user must have the required permission. By default, only developers can save public reports1. Any user may save private interactive grid reports, but only the user who creates a private report can view, save, rename, or delete it12. Verified References: 12
NEW QUESTION # 87
Choose the two options provided in a Column Heading menu of an Interactive Report.
- A. Control Break
- B. Group By
- C. Delete
- D. Hide
Answer: A,D
Explanation:
Explanation
The Column Heading menu of an Interactive Report provides various options to customize the report based on the selected column. The options include:
Control Break: This option allows you to create a control break on the column, which groups the rows by the column values and inserts a header and a footer for each group. You can also apply aggregate functions, such as sum, count, or average, to the footer of each group.
Hide: This option allows you to hide the column from the report, which reduces the clutter and improves the readability of the report. You can also show the hidden columns by using the Columns option in the Actions menu.
The other options are incorrect because:
Group By: This option is not provided in the Column Heading menu of an Interactive Report. It is provided in the Actions menu of an Interactive Report. It allows you to group the rows by one or more columns and display the result in a chart or a pivot table.
Delete: This option is not provided in the Column Heading menu of an Interactive Report. It is provided in the Data option in the Actions menu of an Interactive Report. It allows you to delete one or more rows from the report and the underlying table.
Verified References: [Customizing Interactive Reports] [Column Heading Menu]
NEW QUESTION # 88
Which three statements are TRUE about Search Configuration?
- A. Only one Search Configuration can be used in a Search Page.
- B. Search Configuration is a shared component defines the data source to be searched and the way results should be displayed.
- C. One or more Search Configurations can be configured in a Search Page.
- D. Searches can be based on Local data, APEX Lists, REST Enabled SQL Service, or REST Data Sources.
Answer: B,C,D
Explanation:
Explanation
Search configuration is a shared component that defines the data source to be searched and the way results should be displayed. You can create a search configuration based on a local data source (table or SQL query), an APEX list, a REST enabled SQL service, or a REST data source2. You can use one or more search configurations in a search page, depending on the search type you select. For example, you can use multiple search configurations for a standard search, but only one search configuration for an Oracle TEXT or a list search2.
NEW QUESTION # 89
Which two Query Source types can be used to create a dynamic Navigation Bar List?
- A. Function Returning SQL Query
- B. Select List
- C. Procedure
- D. SQL Query
Answer: A,D
Explanation:
Explanation
The Query Source types for a Navigation Bar List are SQL Query and Function Returning SQL Query. These types allow you to define the list entries using a SQL statement or a PL/SQL function that returns a SQL statement. The other options, Select List and Procedure, are not valid for a Navigation Bar List. Verified References: Create Page Wizard: Navigation Bar List AttributesCreating Lists
NEW QUESTION # 90
Which statement is true about creating and using a faceted search page?
- A. If you create a faceted search page based on a table, the facets are not auto-discovered.
- B. The Search Results region can be displayed as an interactive report.
- C. The Search Results region can be displayed as a Classic Report or Cards.
- D. If you create a faceted search page on a view or a SQL query, the facets are auto-discovered.
Answer: C
Explanation:
Explanation
A faceted search page is a type of page that allows end users to filter data by applying one or more facets. A facet is a set of filters based on a column or expression. You can create a faceted search page by using the Create Page Wizard or by adding a faceted search region to an existing page. If you create a faceted search page based on a table, view, or SQL query, the facets are auto-discovered by analyzing the data source. The Search Results region can be displayed as a Classic Report or Cards, but not as an interactive report. You can also customize the appearance and behavior of the facets and the search results by using various attributes.
Verified References: [Creating Faceted Search Pages - Oracle Help Center], [Faceted Search Attributes - Oracle Help Center]
NEW QUESTION # 91
You created a custom theme for an application. Examine these requirements: 1. The theme must be utilized by another application in the same workspace. 2. The master theme may still require changes. Which solution guarantees that any changes to the master theme are reflected in the copied theme?
- A. Refreshing the templates
- B. Copying the changes made in the master theme to the copied theme
- C. Subscribing the copied theme to the master theme and refreshing the theme
- D. Verifying the theme subscription
Answer: C
Explanation:
Explanation
A theme is a collection of templates and stylesheets that define the layout and appearance of an application.
You can create a custom theme for an application by using the Create Theme Wizard or by copying an existing theme. If you want to use a custom theme for anotherapplication in the same workspace, you can copy the theme to that application by using the Copy Theme option in Shared Components. However, if the master theme (the original theme) may still require changes, you need to subscribe the copied theme to the master theme and refresh the theme whenever there are changes in the master theme. This solution guarantees that any changes to the master theme are reflected in the copied theme by using a synchronization process that updates templates and stylesheets based on their subscription status. Verified References: [Creating Themes - Oracle Help Center], [Managing Theme Subscriptions - Oracle Help Center]
NEW QUESTION # 92
You can apply an authorization scheme for which three of the following components?
- A. An entire application
- B. A session
- C. A page
- D. Specific control such as region,item or button
Answer: A,C,D
Explanation:
Explanation
You can apply an authorization scheme for the following components in APEX:
A specific control such as a region, item, or button. You can select an authorization scheme from the Authorization Scheme list on the attributes page of the control. This will control the rendering and processing of the control based on the user privileges12.
A page. You can select an authorization scheme from the Authorization Scheme list on the Security page of the page definition. This will control the access to the page based on the user privileges12.
An entire application. You can select an authorization scheme from the Authorization Scheme list on the Security Attributes page of the application definition. This will control the access to the entire application based on the user privileges12.
You cannot apply an authorization scheme for a session, as a session is not a component in APEX. A session is a stateful connection between a browser and the APEX engine that persists across multiple requests and responses3. You can control session security by using session state protection, session expiration, and session isolation4.
NEW QUESTION # 93
To highlight certain rows in the interactive report based on a condition, you must:
- A. Provide a conditional SQL query
- B. Rows cannot be highlighted in an Interactive report
- C. Edit the rows in the report and select a color
- 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 # 94
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. Social Sign-In
- C. HTTP Header Variable
- D. SAML Sign-In
Answer: B
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 # 95
Which two statements are true about the usage of a Remote Server in the context of REST Data Sources?
- A. Multiple REST Data Sources can reference a single remote server.
- B. The remote server determines the base URL of the REST Data Source.
- C. The remote server should mandatorily be an APEX instance.
- D. A single REST Data Source can use multiple remote servers.
Answer: A,B
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 # 96
Which two statements are true about creating and customizing Smart Filters pages?
- A. The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types.
- B. The search results report can be displayed as an interactive report.
- C. If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache.
- D. The search results report can be displayed as an interactive grid
Answer: A,C
Explanation:
Explanation
Smart Filters is a component that allows end users to filter data by typing keywords in a single search field.
Some of the statements that are true about creating and customizing Smart Filters pages are:
If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache. You can also manually add or remove filters as needed.
The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types. For other filter types, such as Input or Range, the count is not displayed. The search results report cannot be displayed as an interactive report or an interactive grid. The supported report types are Classic Report, Cards, Map, or Calendar. Verified References: [Managing Smart Filters - Oracle Help Center],
[Creating Smart Filters Using the Create Page Wizard - Oracle Help Center]
NEW QUESTION # 97
Consider a customers report. A customer name is clicked in the report to display the Customer Details form. When the items in the form dialog are updated and the user clicks Apply Changes, the page process is executed and the items from the page are used to update and commit the underlying table in the Oracle Database. What are the two types of events that occurred in this scenario?
- A. Page Rendering
- B. Page Processing
- C. Page Refresh
- D. Page Validation
Answer: B,D
Explanation:
Explanation
When the customer name is clicked in the report, the Customer Details form dialog page is displayed. This is a page rendering event, which means the page is generated and sent to the browser. When the items in the form dialog are updated and the user clicks Apply Changes, the page process is executed and the items from the page are used to update and commit the underlying table in the Oracle Database. This is a page processing event, which means the page is submitted to the server and processed by APEX. Page validation is also a part of page processing, but it is not a separate event. Page refresh is not an event, but an action that can be triggered by a dynamic action or a process
NEW QUESTION # 98
Select the three types of Card Layout you can create in APEX.
- A. Float
- B. Vertical(Column)
- C. Grid
- D. Horizontal(Row)
Answer: A,C,D
Explanation:
Explanation
You can create two types of card layout in APEX: Float and Grid. Float layout displays cards in a single row that wraps to the next row when the available space is filled. Grid layout displays cards in a fixed number of columns that can be responsive to the screen size1. Vertical and Horizontal are not valid card layout types in APEX.
NEW QUESTION # 99
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 add files as attachments to your emails using the APEX_MAIL package.
- C. You can receive emails using the APEX_MAIL package in an Oracle APEX application
- D. The APEX_MAIL package supports sending emails only to Oracle database users.
Answer: A,B
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 # 100
Choose the three types of aggregations you can apply on a column.
- A. Average
- B. Sum
- C. Count
- D. Standard Deviation
Answer: A,B,C
NEW QUESTION # 101
Which three of the following statements are TRUE about Faceted Search?
- A. You can create only 5 facets per page
- B. The facets are displayed on the left and upper part of the screen
- C. After the end user changes a facet, the results, dependent facets, and occurrence counts refresh immediately.
- D. The right side of the page features a Search Results region, which can display as a classic report or a cards report.
Answer: B,C,D
Explanation:
Explanation
A faceted search is a type of component that enables users to filter information easily and intuitively by selecting the options in each facet. A faceted search consists of a faceted search region and a search results region. The faceted search region displays on the left and upper part of the screen and shows possible values and occurrence counts for each facet. The search results region displays on the right side of the screen and shows the data that matches the selected facet values. The search results region can display as either a classic report or a cards report. Three of the statements that are true about faceted search are:
After the end user changes a facet, the results, dependent facets, and occurrence counts refresh immediately. This feature provides instant feedback to the user and allows them to refine their search criteria without reloading the page.
The right side of the page features a Search Results region, which can display as a classic report or a cards report. A classic report displays data in a tabular format with columns and rows. A cards report displays data in a grid of cards with images and text.
The facets are displayed on the left and upper part of the screen. This layout provides a clear separation between the facets and the results and allows users to see and access all the facets without scrolling.
NEW QUESTION # 102
Which two among the following are TRUE about Low Code Apps?
- A. Not Mobile Friendly
- B. Scalable
- C. Expensive
- D. Provide Rich Functionality with Less Code
Answer: B,D
Explanation:
Explanation
Low Code Apps are applications that are developed using a low-code development platform such as Oracle APEX. Low Code Apps have the following characteristics:
Scalable: Low Code Apps can handle large volumes of data and users without compromising performance or reliability. They can also leverage the scalability features of the underlying database or cloud platform.
Provide Rich Functionality with Less Code: Low Code Apps can provide complex business logic, user interface, security, and integration features with minimal or no coding. They use declarative tools, visual editors, drag-and-drop components, and pre-built templates to speed up the development process.
The other options are incorrect because:
Not Mobile Friendly: Low Code Apps are mobile friendly by default. They use responsive design techniques to adapt to different screen sizes and orientations. They also support touch gestures, device features, and offline capabilities.
Expensive: Low Code Apps are not expensive to develop or maintain. They reduce the cost of development by requiring less time, resources, and skills. They also reduce the cost of maintenance by simplifying the deployment, testing, and debugging processes.
Verified References: [What is Low Code?] [Why Choose Oracle APEX?]
NEW QUESTION # 103
Which two are true about Oracle APEX?
- A. Is declarative. It requires no code generation.
- B. Performs the data processing in a middle-tier server
- C. Requires developers to be proficient in Java, Python and other programming languages.
- D. Requires no additional client software. A web browser is the app development IDE.
Answer: A,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 # 104
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. ......... and enter SALESMAN for Value.
- C. Create a dynamic action on P2_JOB.
- D. Create a dynamic action on P2_HIREDATE and P2_COMM.
- E. Create a dynamic action on form load.
Answer: B,C
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 # 105
You can create a report in which of the three following methods?
- A. Create a report region on a page in an application
- B. Create a report from Object Browser
- C. Create a report as a new page in an application
- D. Create a report when you create a new database application
Answer: A,C,D
Explanation:
Explanation
You can create a report in any of these three methods:
Create a report as a new page in an application by using the Create Page Wizard. This wizard guides you through the steps of selecting a page type, defining attributes, selecting a source (such as SQL query or table), and adding items or buttons.
Create a report when you create a new database application by using the Create Application Wizard.
This wizard allows you to generate one or more reports based on existing tables or views in your schema. You can also create a report and form on the same table or view.
Create a report region on a page in an application by using the Page Designer. This tool allows you to drag and drop a region type (such as Classic Report, Interactive Report, or Interactive Grid) onto the page and define its attributes and source.
The other option is incorrect because:
You cannot create a report from Object Browser. Object Browser is a tool that allows you to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can only run SQL queries or scripts from this tool, not create reports.
Verified References: [Creating Database Applications] [Creating Pages] [Creating Regions] [Using Object Browser]
NEW QUESTION # 106
What are the three types of List of Values(LOV) you can create on a page?
- A. Dynamic LOV
- B. Popup LOV
- C. Cascading LOV
- D. Static LOV
Answer: A,C,D
Explanation:
Explanation
A list of values (LOV) is a definition that provides a set of display values and return values for a page item or a report column. A LOV can be created at the application level as a shared component or at the page level as a local component. There are three types of LOVs that you can create on a page:
Static LOV: A static LOV is based on a fixed list of display values and return values that you specify when you create the LOV. A static LOV does not change unless you edit it manually.
Cascading LOV: A cascading LOV is based on another parent LOV that determines the values of the child LOV. A cascading LOV changes dynamically depending on the selection made in the parent LOV.
Dynamic LOV: A dynamic LOV is based on a SQL query that returns display values and return values from the database. A dynamic LOV changes dynamically depending on the data in the database.
NEW QUESTION # 107
......
Oracle 1Z0-770 certification exam consists of 60 multiple-choice questions that are to be completed within 105 minutes. 1Z0-770 exam measures the candidate's knowledge of APEX architecture, data modeling, security, user interface design, and application deployment. Oracle APEX Developer Professional certification exam is proctored and can be taken at any authorized Pearson VUE testing center globally. Candidates who pass the exam will earn the Oracle APEX Developer Professional certification, which is recognized globally and can help them advance their careers in the IT industry.
Latest 100% Passing Guarantee - Brilliant 1Z0-770 Exam Questions PDF: https://www.exams-boost.com/1Z0-770-valid-materials.html
Practice Examples and Dumps & Tips for 2025 Latest 1Z0-770 Valid Tests Dumps: https://drive.google.com/open?id=1B2CqAcGWkkA5S0tN2sCZW9a3PfyhggAq