Most UptoDate Oracle 1Z0-770 Exam Dumps PDF 2024
100% Free Oracle Database 1Z0-770 Dumps PDF Demo Cert Guide Cover
To prepare for the Oracle 1Z0-770 certification exam, candidates must have a deep understanding of APEX architecture, including its components and how they interact with each other. They must also have a solid understanding of SQL and PL/SQL, as these are essential skills for developing APEX applications. Additionally, candidates must have experience developing applications using APEX and be familiar with its various features and functionalities.
Oracle 1Z0-770 exam includes 60 multiple-choice questions that must be completed within 105 minutes. 1Z0-770 exam covers a wide range of topics, including APEX architecture, security, data modeling, application design, and deployment. Candidates must demonstrate their ability to create and manage APEX applications, develop reports, and use APEX APIs to customize and extend the platform's functionality.
NEW QUESTION # 36
Which two Plugin types can be created in Oracle APEX?
- A. Email Template
- B. Validation
- C. Region
- D. Process
Answer: C,D
Explanation:
Explanation
A plugin is a component that extends the native functionality of Oracle APEX by allowing developers to create custom components using SQL, PL/SQL, HTML, CSS, and JavaScript. A plugin can be created for any of the following component types: Dynamic Action, Item, Process, Region, Report Layout, Authentication Scheme, Authorization Scheme, or Data Load Method. A process plugin is a custom process type that can be executed when a page is submitted or loaded. A region plugin is a custom region type that can display data or content on a page. Verified References: [Creating Plugins - Oracle Help Center], [Plugin Concepts - Oracle Help Center]
NEW QUESTION # 37
Choose from the below options the actions that can be performed when a button is clicked.
- A. Submit Page
- B. Redirect to a page in the same application
- C. Redirect to a URL
- D. Redirect to a page in a different application
- E. All of them
Answer: E
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 # 38
Choose the three Form types that you can create using the Create Page wizard.
- A. Interactive Grid
- B. Form
- C. Master Detail
- D. Interactive Report
Answer: A,B,C
Explanation:
Explanation
The Create Page wizard supports three form types that you can create: Interactive Grid, Form, and Master Detail4. An interactive grid is a report that allows users to view and edit data in a tabular format. A form is a page that enables users to update a single row in a database table or view. A master detail is a page that reflects a one-to-many relationship between two tables or views4. An interactive report is not a form type, but a report type that allows users to customize the report layout and filter data interactively5.
NEW QUESTION # 39
Let's say that there are two select lists on a page. Making a selection in the DEPARTMENT select list, determines which individuals display in the Employees select list. This type of LOV is called:
- A. Cascading LOV
- B. Dynamic LOV
- C. Static LOV
- D. Popup LOV
Answer: A
Explanation:
Explanation
A cascading LOV is a type of list of values (LOV) that depends on another parent LOV to determine its values. For example, if there are two select lists on a page, one for DEPARTMENT and one for EMPLOYEES, you can create a cascading LOV for EMPLOYEES that only shows the employees who belong to the selected department in the DEPARTMENT select list. To create a cascading LOV, you need to specify the parent item name and use bind variables in the SQL query for the child item.
NEW QUESTION # 40
Choose the three supported spatial geometry objects in Maps.
- A. Polygons
- B. Heat map
- C. Bars
- D. Points
Answer: A,B,D
Explanation:
Explanation
A map is a type of component that enables users 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. Three of the supported spatial geometry objects in Oracle APEX are:
Polygons: A polygon is a closed shape that consists of three or more vertices connected by straight line segments. A polygon can represent an area on a map, such as a country, a state, a city, or a building. A polygon can have different colors, patterns, or borders to indicate different attributes or categories of the data.
Heat map: A heat map is a type of visualization that uses color gradients to show the density or intensity of data values in a geographic area. A heat map can represent the distribution or variation of a numeric variable on a map, such as population, income, crime rate, or temperature.
Points: A point is a zero-dimensional shape that represents a single location on a map. A point can have different symbols, sizes, or colors to indicate different attributes or categories of the data. A point can also have a label or a tooltip to display additional information about the data.
NEW QUESTION # 41
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 # 42
Which two statements are true about REST Data Sources?
- A. REST Data Sources doesn't support any authentication
- 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. Oracle APEX doesn't provide direct integration of REST Data Sources in interactivereports
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 # 43
Which is a valid Page Process type?
- A. Execute JavaScript Code
- B. Set Value
- C. Send E-Mail
Answer: B
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 # 44
When you run an application, the APEX engine relies on which two processes?
- A. Run Page
- B. Validate Page
- C. Accept page
- D. Show Page
Answer: C,D
Explanation:
Explanation
When you run an application, the APEX engine relies on two processes: Show Page and Accept Page. Show Page is responsible for rendering the page and sending it to the browser. Accept Page is responsible for processing the page when it is submitted by the browser. Run Page is not a process, but a command that can be used to run an application or a page from SQLWorkshop or Application Builder. Validate Page is not a process, but a step that occurs during page processing to check for any validations defined on the page
NEW QUESTION # 45
Which three statements are TRUE about Search Configuration?
- A. Search Configuration is a shared component defines the data source to be searched and the way results should be displayed.
- B. One or more Search Configurations can be configured in a Search Page.
- C. Searches can be based on Local data, APEX Lists, REST Enabled SQL Service, or REST Data Sources.
- D. Only one Search Configuration can be used in a Search Page.
Answer: A,B,C
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 # 46
Which two Query Source types can be used to create a dynamic Navigation Bar List?
- A. Select List
- B. Procedure
- C. SQL Query
- D. Function Returning SQL Query
Answer: C,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 # 47
Which two tasks can you perform using App Builder?
- A. Create join queries using drag and drop.
- B. Create and manage database objects.
- C. Create and manage apps.
- D. Import previously exported apps.
- E. Generate data definition language (DDL) statements from the Oracle data dictionary.
Answer: C,D
Explanation:
Explanation
App Builder is the main interface of Oracle APEX that allows developers to create and manage web applications. App Builder provides various features and tools to design, develop, test, debug, deploy, and maintain applications. Some of the tasks that you can perform using App Builder are importing previously exported apps, creating new apps from scratch or from predefined templates or blueprints, editing app properties and attributes, adding pages and regions, creating shared components, running and debugging apps, exporting apps to files or workspaces, etc. You cannot create join queries using drag and drop or generate DDL statements from the Oracle data dictionary using App Builder. Verified References: [Using App Builder
- Oracle Help Center], [App Builder Concepts - Oracle Help Center]
NEW QUESTION # 48
The APEX engine uses which component as a key for tracking each user's session state?
- A. LDAP_USER
- B. APP_USER
- C. HTTP_USER
- D. APEX_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 # 49
Which two are valid evaluation points for Authorization Schemes?
- A. Once per session
- B. Never
- C. Once per user
- D. Once per page view
Answer: B,D
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 # 50
Select the three types of Facets you can create in APEX.
- A. Input Field
- B. Text Area
- C. Checkbox Group
- D. Range
Answer: A,C,D
Explanation:
Explanation
A facet is a type of component that provides a set of display values and return values for a faceted search region or a smart filters region. A facet can be based on either static values or dynamic values from a list of values (LOV). A facet can also have different display styles depending on its type and settings. Three of the types of facets that you can create in APEX are:
Range: A range facet displays numeric values in either buckets or sliders that users can select or adjust to filter the search results. A range facet can have either static values or dynamic values based on an LOV or SQL query.
Checkbox Group: A checkbox group facet displays multiple options that users can select or deselect to filter the search results. A checkbox group facet can have either static values or dynamic values based on an LOV or SQL query.
Input Field: An input field facet displays a text field that users can enter text to filter the search results.
An input field facet does not have any values but uses an operator to compare the user input with the data.
NEW QUESTION # 51
You can create an APEX workspace and build APEX apps on which of the following platforms?
- A. Microsoft Azure
- B. Oracle XE
- C. Oracle Autonomous Cloud
- 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 # 52
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 # 53
......
Updated Oracle 1Z0-770 Dumps – PDF & Online Engine: https://actualtest.updatedumps.com/Oracle/1Z0-770-updated-exam-dumps.html