100% Updated Oracle 1Z0-770 Enterprise PDF Dumps
Use Valid Exam 1Z0-770 by Exams-boost Books For Free Website
Oracle APEX Developer Professional certification exam covers a wide range of topics, including database design and development, SQL and PL/SQL, APEX architecture, and APEX development. 1Z0-770 exam is designed to test the candidate's ability to design, develop, and deploy APEX applications using the latest tools and technologies.
Oracle 1Z0-770 (Oracle APEX Developer Professional) Exam is a certification exam for individuals seeking to become a professional Oracle APEX developer. Oracle APEX (Application Express) is a web application development platform that is built on top of the Oracle database, which allows developers to create and deploy web applications quickly and easily. 1Z0-770 exam is designed to test an individual’s knowledge and expertise in Oracle APEX development.
NEW QUESTION # 16
Choose the three correct options in the given friendly URL syntax:
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?
- A. mycompany is the path-prefix which is by default the workspace name
- B. update-employees is the PL/SQL procedure to update the employee details.
- C. 13766599855150 is the session ID. A new ID is generated for each session.
- D. session=13766599855150 Ahr-app is the application alias.
Answer: A,C,D
Explanation:
Explanation
The friendly URL syntax
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?session=13766599855150 has the following components:
session=13766599855150 is the session ID. A new ID is generated for each session. This parameter identifies which session is associated with the request.
hr-app is the application alias. This parameter identifies which application is being requested. An application alias is a user-friendly name that can be used instead of an application ID.
mycompany is the path-prefix which is by default the workspace name. This parameter identifies which workspace is being requested. A path-prefix is a URL segment that can be used instead of a workspace ID.
updateemployees is the page alias. This parameter identifies which page is being requested. A page alias is a user-friendly name that can be used instead of a page number.
The other option is incorrect because:
update-employees is not the PL/SQL procedure to update the employee details. It is the page alias that identifies which page is being requested.
Verified References: [About Friendly URLs] [Understanding URL Syntax]
NEW QUESTION # 17
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. Choose a condition in Format > Highlight
- D. Rows cannot be highlighted in an Interactive report
Answer: C
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 # 18
What are the three types of List of Values(LOV) you can create on a page?
- A. Popup LOV
- B. Dynamic LOV
- C. Static LOV
- D. Cascading LOV
Answer: B,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 # 19
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 # 20
Choose from the below options the actions that can be performed when a button is clicked.
- A. Redirect to a page in a different application
- B. Submit Page
- C. All of them
- D. Redirect to a URL
- E. Redirect to a page in the same application
Answer: C
Explanation:
Explanation
A button is a component that performs an action when clicked by the user. A button can have different types, styles, icons, and labels. A button can also have different behaviors, such as submitting the page, redirecting to another page or URL, or doing nothing. A button can perform any of the following actions when clicked:
Redirect to a page in the same application: This action redirects the user to another page within the same APEX application. You can specify the target page number and optionally set some attributes, such as clear cache, request, and item values.
Redirect to a page in a different application: This action redirects the user to another page in a different APEX application. You can specify the target application ID and page number and optionally set some attributes, such as clear cache, request, and item values.
Redirect
to a URL: This action redirects the user to a custom URL that you specify. You can use any valid URL format, such as http://, https://, mailto:, or javascript:.
Submit Page: This action submits the current page to the server and performs any validations, computations, processes, or branches that are defined for the page. You can also specify a request value for the button that can be used to conditionally execute some components.
Defined by Dynamic Action: This action does not submit the page or redirect to another page. Instead, the button's behavior is defined by a dynamic action thatis associated with the button. A dynamic action is a declarative way of defining client-side behavior based on user actions or events.
NEW QUESTION # 21
Which two statements are true about Maps in Oracle APEX?
- A. Maps support REST Enabled SQL
- B. Background maps do not require any API keys.
- C. Maps don't support REST Data Sources
- D. Heat Map and Polygons are not supported Spatial geometry objects
Answer: A,B
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 # 22
From SQL Workshop, you can perform which two of the following actions?
- A. Run SQL commands and scripts
- B. Delete database
- C. Create and view database objects
- D. Create an APEX user
Answer: A,C
Explanation:
Explanation
From SQL Workshop, you can perform the following actions:
Run SQL commands and scripts: You can use SQL Commands or SQL Scripts components to run individual SQL statements or PL/SQL blocks interactively or in batch mode. You can also view the results, errors, or explain plans of your commands or scripts.
Create and view database objects: You can use Object Browser component to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can also use this component to create new objects, modify existing objects, drop objects, or run object reports.
The other options are incorrect because:
Create an APEX user: You cannot use SQL Workshop to create an APEX user. You can use Workspace Administration component to create and manage users in your workspace.
Delete database: You cannot use SQL Workshop to delete database. You can only delete database objects such as tables or views from your schema.
Verified References: [About SQL Workshop] [Using SQL Commands] [Using SQL Scripts] [Using Object Browser] [Managing Workspace Users]
NEW QUESTION # 23
You must use a Static Content region type to display messages about the employees of the month. Employee names are stored in the P1 ENAME page item. Which text, when placed in Source, will display the message correctly?
- A. Join me in congratulating &P1 ENAME, as the new employee of the month!
- B. Join me in congratulating v('P1_ENAME') as the new employee of the month!
- C. Join me in congratulating :P1 ENAME as the new employee of the month!
Answer: A
Explanation:
Explanation
A Static Content region type is used to display static text or HTML content on a page. To display messages about the employees of the month, you can use a Static Content region type with substitution variables that reference page items. Substitution variables are enclosed in ampersands (&) and can be used to dynamically replace text with values from page items or application items. The correct text to display the message is "Join me in congratulating &P1_ENAME, as the new employee of the month!" The other options are incorrect because they use either colons (:) or v() function, which are not valid ways to reference page items in Static Content regions. Verified References: [Creating Static Content Regions - Oracle Help Center], [Understanding Substitution Strings - Oracle Help Center]
NEW QUESTION # 24
The Movies faceted search report is filtered only when the Apply button for a selected facet is clicked. What must be done in the Page Designer so that report filtering is automatically executed when any facet value changes?
- A. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute
- B. Navigate to each facet and then in the Property Editor, turn on client-Side Filtering.
- C. Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute.
- D. Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute. Then, navigate to each facet and in the Property Editor, turn on client-Side Filtering.
Answer: A
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. By default, when end users select a facet value, they need to click on an Apply button for that facet to apply the filter to the report. To make report filtering automatically executed when any facet value changes, you need to navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute. The Batch Facet Changes attribute determines whether end users need to click on an Apply button for each facet or not. When this attribute is disabled, the report is automatically refreshed when any facet value changes. The other options are not relevant to the report filtering behavior. Verified References: [Faceted Search Attributes - Oracle Help Center], [Batch Facet Changes - Oracle APEX]
NEW QUESTION # 25
Which two statements are true about the Create Application Wizard?
- A. It allows application pages to be reordered.
- B. It allows application pages to be added or deleted.
- C. It allows the application authorization to be changed
- D. It allows the uploading of JavaScript or CSS files required for an application.
Answer: A,B
Explanation:
Explanation
The Create Application Wizard is a tool that allows developers to create a new application by following a series of steps. Some of the actions that you can perform using the Create Application Wizard are:
Reorder application pages. You can use the Reorder Pages option in the Pages step to change the order of the pages in your application by dragging and dropping them.
Add or delete application pages. You can use the Add Page or Delete Page options in the Pages step to add new pages or delete existing pages from your application. You can also use the Create Page Wizard to create additional pages after creating the application. You cannot upload JavaScript or CSS files required for an application or change the application authorization using the Create Application Wizard.
You can use other features in App Builder to perform these actions, such as Shared Components > User Interface > Files and Shared Components > Security > Authentication Schemes. Verified References:
[Creating an Application Using the Create Application Wizard - Oracle Help Center], [Create Application Wizard - Oracle APEX]
NEW QUESTION # 26
Which client credentials are utilized for authentication during the One-Click Remote ApplicationDeployment process?
- A. APEX Workspace Admin credentials
- B. Database schema credentials
- C. PEX Developer credentials
Answer: A
Explanation:
Explanation
The One-Click Remote Application Deployment feature in Oracle APEX enables developers to deploy an application along with supporting object definitions to another workspace or to remote Oracle APEX instances. To use this feature, you need to provide the client credentials for authentication during the deployment process. The client credentials are utilized for authentication during the One-Click Remote Application Deployment process are the APEX Workspace Admin credentials. You can either specify an existing credential or create a new credential when you create a REST Enabled SQL reference in Shared Components. Optionally, you can create the credentials as empty credentials to prompt for client ID and client secret each time the REST Enabled SQL reference is used. Verified References: [Understanding One-Click Remote Application Deployment - Oracle Help Center], [Remote Deployment of your APEX App is just One Click Away! - Oracle Blogs]
NEW QUESTION # 27
Which two statements are TRUE about Dynamic Actions?
- A. More dynamic actions you add to a page, the greater your overall page size.
- B. Dynamic actions provide a way to define complex client-sidebehaviordeclaratively without the need for JavaScript.
- C. It is not possible to debug Dynamic Actions from the Developer Toolbar
- D. Dynamic Actions require complex client side Javascript code
Answer: A,B
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 # 28
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. Popup LOV
- B. Checkbox Group
- C. Range
- D. Date Picker
Answer: B,C
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 # 29
Which statement is true about session state management in Oracle APEX?
- A. A user cannot run multiple instances of an application simultaneously in different browser programs.
- B. APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests.
- C. Multiple number of sessions cannot exist in the database at the same time
Answer: B
Explanation:
Explanation
Session state management is a feature that enables developers to store and retrieve values for a user as the user navigates between different application pages. A session is a logical construct that establishes persistence (or stateful behavior) across page views. Each session is assigned a unique identifier (or session ID). The statement that is true about session state management in Oracle APEX is:
APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests. APEX Sessions are stored in memory within an Application Express engine process while Oracle database sessions are stored in memory within an Oracle database process. The other statements are false because:
A user can run multiple instances of an application simultaneously in different browser programs by using different session IDs.
Multiple number of sessions can exist in the database at the same time for different users or applications.
Verified References: [Understanding Session State Management - Oracle Help Center], [What Is a Session? - Oracle Help Center]
NEW QUESTION # 30
Which is a valid Page Process type?
- A. Execute JavaScript Code
- B. Send E-Mail
- C. Set Value
Answer: C
Explanation:
Explanation
A page process type defines what action the page process performs when it is executed. There are many page process types available in Oracle APEX, such as Execute PL/SQL Code, Data Loading, Branch, etc. One of the valid page process types is Set Value. The Set Value page process type sets session state for an item or items on a page using a computation or PL/SQL expression. You can use this page process type to assign values to items based on logic or conditions. The other options are not valid page process types. Execute JavaScript Code is a dynamic action type, not a page process type. Send E-Mail is an application process type, not a page process type. Verified References: [Understanding Page Processes - Oracle Help Center], [Set Value Process Type - Oracle Help Center]
NEW QUESTION # 31
Generally, clicking on the hamburger menu in the upper-left corner of an APEX application displays a list of pages. What is this navigation called?
- A. Breadcrumbs
- B. Navigation Bar List
- C. Lists
- D. Navigation Menu
Answer: D
Explanation:
Explanation
The navigation menu is the list of pages that displays when you click on the hamburger menu in the upper-left corner of an APEX application. The navigation menu is a shared component that can be created and edited in the Shared Components page3. Lists, breadcrumbs, and navigation bar entries are other types of navigation components in APEX, but they are not the same as the navigation menu.
NEW QUESTION # 32
What are the required fields while creating a Chart in APEX?
- A. Label Column
- B. Data Source
- C. Value Column
- D. All of them
- E. Name
Answer: D
Explanation:
Explanation
To create a chart in Oracle APEX, you need to provide some required fields that define the data source and appearance of the chart. You can use either the Create Page Wizard or Page Designer to create a chart. The required fields for creating a chart are:
Data Source: This field specifies the SQL query that returns the data for the chart. The query must include at least one column for the label and one column for the value of each data point. You can also include additional columns for grouping, color, or tooltip information.
Value Column: This field specifies the column from the data source query that contains the numeric values for the chart. The values are used to plot the data points on the chart and determine the size of each data point or segment.
Name: This field specifies the name of the chart region. The name is used to identify the region in Page Designer and other components, such as dynamic actions or processes.
Label Column: This field specifies the column from the data source query that contains the labels for the chart. The labels are used to display the name of each data point or segment on the chart or in the legend.
NEW QUESTION # 33
Which two statements are true about the usage of a Remote Server in the context of REST Data Sources?
- A. A single REST Data Source can use multiple remote servers.
- B. The remote server determines the base URL of the REST Data Source.
- C. Multiple REST Data Sources can reference a single remote server.
- D. The remote server should mandatorily be an APEX instance.
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 # 34
Which two are valid evaluation points for Authorization Schemes?
- A. Once per session
- B. Never
- C. Once per page view
- D. Once per user
Answer: B,C
Explanation:
Explanation
An authorization 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 authorization scheme can be evaluated at different points in time depending on its evaluation point attribute. The valid evaluation points for authorization schemes are:
Never: The authorization scheme is never evaluated and always returns false.
Once per session: The authorization scheme is evaluated only once per user session and caches the result for subsequent requests.
Once per page view: The authorization scheme is evaluated once per page view and caches the result for subsequent requests within the same page view.
On each new page view or partial page refresh: The authorization scheme is evaluated on each new page view or partial page refresh (for example, when using dynamic actions) and caches the result until the next page view or partial page refresh.
On each request (not cached): The authorization scheme is evaluated on each request and does not cache the result. Once per user and Once per page load are not valid evaluation points for authorization schemes. Verified References: [Creating Authorization Schemes - Oracle Help Center], [Authorization Scheme Attributes - Oracle Help Center]
NEW QUESTION # 35
Which two statements are true about creating and customizing Smart Filters pages?
- A. The search results report can be displayed as an interactive grid
- B. The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types.
- 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 report.
Answer: B,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 # 36
......
Oracle 1Z0-770 Official Cert Guide PDF: https://www.exams-boost.com/1Z0-770-valid-materials.html
Free Oracle Database 1Z0-770 Official Cert Guide PDF Download: https://drive.google.com/open?id=1B2CqAcGWkkA5S0tN2sCZW9a3PfyhggAq