Download 1z1-770 Dumps (2024) - Free PDF Exam Demo
Enhance your career with 1z1-770 PDF Dumps - True Oracle Exam Questions
Oracle 1Z0-770 (Oracle APEX Developer Professional) Exam is a certification exam designed to test the skills and knowledge of professionals who work with Oracle Application Express (APEX) technology. APEX is a low-code development platform that enables developers to build web-based applications quickly and efficiently using SQL and PL/SQL. 1z1-770 exam is intended for professionals who have experience with APEX and want to demonstrate their proficiency in designing, developing, and deploying APEX applications.
NEW QUESTION # 86
What are Task definitions that exist on the application level inthe Shared Components section made up of?
- A. All of them
- B. Particpants
- C. Parameters
- D. Task Settings
- E. Actions
Answer: A
Explanation:
Explanation
Task definitions that exist on the application level in the Shared Components section are made up of all of the following: Participants, Task Settings, Parameters, and Actions. Task definitions are used to define approval workflows for data changes in interactive grids or forms5. Participants are the users or groups who can approve or reject tasks. Task Settings are the properties that control how tasks are created, assigned, and completed. Parameters are the variables that store information about tasks or data changes. Actions are the PL/SQL code blocks that execute when tasks are created, updated, or completed5.
NEW QUESTION # 87
Choose the three types of page items that can be placed on a page.
- A. Select List
- B. Date Picker
- C. Checkbox
- D. Global variable
Answer: A,B,C
Explanation:
Explanation
A page item is a component that is part of an HTML form and can accept user input or display output. There are many types of page items that can be placed on a page in APEX, such as text fields, text areas, radio groups, checkboxes, date pickers, select lists, popup LOVs, shuttles, and so on. Each type of page item has different properties and attributes that affect its appearance and functionality. Three of the types of page items that can be placed on a page are:
Checkbox: A checkbox is a page item that displays one or more options that can be selected or deselected by the user. A checkbox can have either static values or dynamic values based on a list of values (LOV). A checkbox can also have different display styles, such as pill button or switch.
Date Picker: A date picker is a page item that displays a text field with an icon that opens a calendar popup when clicked. A date picker allows users to enter or select a date value in a specific format. A date picker can also have different attributes, such as minimum or maximum date, display format, or time picker.
Select List: A select list is a page item that displays a drop-down list of options that can be selected by the user. A select list can have either static values or dynamic values based on a list of values (LOV). A select list can also have different attributes, such as multiple selection, null value display text, or cascading LOV.
NEW QUESTION # 88
Which of the following are preconfigured authentication schemes?
- A. Social Sign In
- B. All of them
- C. LDAP Directory
- D. Open Door Credentials
- E. HTTP Header Variables
Answer: B
Explanation:
Explanation
Oracle APEX provides several preconfigured authentication schemes that follow a standard behavior for authentication and session management. You can select a preconfigured authentication scheme from the gallery when you create an authentication scheme for your application. The preconfigured authentication schemes are:
Open Door Credentials: This scheme enables anyone to access your application using a built-in login page that captures a user name.
LDAP Directory: This scheme authenticates a user and password with an authentication request to a LDAP server.
HTTP Header Variable: This scheme authenticates users externally by storing the username in a HTTP Header variable set by the web server.
Social Sign-In: This scheme supports authentication with Google, Facebook, and other social networks that support OpenID Connector OAuth2 standards.
Oracle APEX Accounts: This scheme authenticates users against Oracle APEX user accounts that are created within and managed in the APEX user repository.
Custom Authentication: This scheme allows you to create a custom authentication scheme from scratch to have complete control over your authentication interface.
Database Accounts: This scheme authenticates users using database schema accounts.
Oracle Application Server Single Sign-On Server: This scheme delegates authentication to the Oracle AS Single Sign-On (SSO) Server.
SAML Sign-In: This scheme delegates authentication to the Security Assertion Markup Language (SAML) Sign In authentication scheme.
NEW QUESTION # 89
You must reference certain data from a dragged event under the Drag and Drop PL/SQL Code attribute of the Calendar component.
Examine this list:
1. The ID
2. The NEW_START_DATE
3. The NEW END DATE
How can these be referenced?
- A. :APEX$PK_VALUE, APEX$NEW START DATE and APEXSNEW_END_DATE
- B. #APEX.PK_VALUE#, #APEX.NEW START_DATE# and #APEX.NEW_END_DATE#
- C. #APEXSPK VALUE#, #APEX$NEW START DATE# and #APEXSNEW END DATE#
- D. :APEX.PK_VALUE, :APEX.NEW START DATE and :APEX.NEW END DATE
Answer: D
Explanation:
Explanation
d event under the Drag and Drop PL/SQL Code attribute of the Calendar component. This attribute allows you to write PL/SQL code to update the event row in the database after the user drags and drops an event on the calendar. To reference the ID, the new start date, and the new end date of the dragged event, you can use these bind variables: :APEX.PK_VALUE, :APEX.NEW_START_DATE and :APEX.NEW_END_DATE. These variables are automatically populated by APEX when the user performs a drag and drop action on the calendar. For example, you can write something like this:
UPDATE events
SET start_date = :APEX.NEW_START_DATE,
end_date = :APEX.NEW_END_DATE
WHERE id = :APEX.PK_VALUE;
NEW QUESTION # 90
Which two statements are true about Maps in Oracle APEX?
- A. Background maps do not require any API keys.
- B. Heat Map and Polygons are not supported Spatial geometry objects
- C. Maps don't support REST Data Sources
- D. Maps support REST Enabled SQL
Answer: A,D
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 # 91
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 each facet and then in the Property Editor, turn on client-Side Filtering.
- B. 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.
- C. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute
- D. Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute.
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. 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 # 92
Which authentication scheme type supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards?
- A. HTTP Header Variable
- B. Open Door Credentials
- C. Social Sign-In
- D. SAML Sign-In
Answer: C
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 # 93
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. Setting Display Location to Inline in Notification
- C. Removing P1_SALARY from the validation Associated Item
Answer: C
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 # 94
When you click a Customer Name in the Customers report, the Customer Details form dialog page is displayed. What are the events that occur in this scenario?
- A. Page Rendering
- B. Page compilation
- C. Page rendering and processing
- D. Page Processing
Answer: C
Explanation:
Explanation
When you click a Customer Name in the Customers report, the Customer Details form dialog page is displayed. This involves two events: page rendering and page processing. Page rendering is the event that occurs when APEX generates and sends the page to the browser. Page processing is the event that occurs when APEX receives and processes the page from the browser. In this scenario, both events happen because the Customer Details form dialog page is a modal dialog that uses AJAX to communicate with the server without reloading the entire page. Page compilation is not an event, but an action that occurs when APEX compiles an application or a page before running it.
NEW QUESTION # 95
Which two statements are true about the Create Application Wizard?
- A. It allows the uploading of JavaScript or CSS files required for an application.
- B. It allows the application authorization to be changed
- C. It allows application pages to be reordered.
- D. It allows application pages to be added or deleted.
Answer: C,D
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 # 96
What three are the building blocks of Approvals Component?
- A. Task Details Page
- B. Unified Task List
- C. Automations
- D. Task Definition
Answer: A,B,D
Explanation:
Explanation
The Approvals Component is Oracle APEX's new offering as part of the 22.1 Release. It allows seamless management of approvals across APEX Applications. Approvals are commonly used in business situations involving Expense Reimbursements, Leave Requests, Purchase Requisitions, On-boarding of Employees to name a few. The Approvals Component provides the following building blocks for the approvals functionality:
Task Definition: A shared component for configuring task parameters, participants, and actions. A task definition defines the template for creating tasks based on a specific type of approval request, such as Leave Approval or Purchase Requisition. A task definition specifies the data source, display attributes, potential owners, business administrators, and available actions for the tasks.
Task Details Page: A page that shows task details, which can include metadata, history, comments, and actions. A task details page allows users to view and take action on a specific task, such as approve, reject, reassign, or escalate. A task details page can be created using the Create Page Wizard or the Quick SQL tool in APEX.
Unified Task List: A page type in the Create Page Wizard, used to create a summary of a user's tasks that functions like an inbox. A unified task list allows users to see and manage all their tasks in one place. Users can filter, sort, search, claim, release, or open tasks from the unified task list.
NEW QUESTION # 97
Consider a page in an APEX app where the Departments names with location is displayed on the left. Selecting a Department on the left will render details of the employees corresponding to that department on the right. Which kind of report/form is this?
- A. Interactive Report
- B. Side by Side Master Detail
- C. Stacked Master Detail
- D. Cards
Answer: C
Explanation:
Explanation
A stacked master detail is a form type that displays two editable interactive grids based on two related tables or views on the same page. Users select a row in the master grid to update the detail grid6. In this scenario, the departments names with location on the left is the master grid and the employees details on the right is the detail grid. A cards report is not a form type, but a report type that displays data in cards with an image and text7. A side by side master detail is a form type that displays two editable interactive grids based on two related tables or views side by side on the same page. Users select multiple rows in the master grid to update multiple detail grids6. 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 # 98
When you run an application, the APEX engine relies on which two processes?
- A. Accept page
- B. Validate Page
- C. Show Page
- D. Run Page
Answer: A,C
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 # 99
Choose from the below options the actions that can be performed when a button is clicked.
- A. All of them
- B. Redirect to a page in a different application
- C. Redirect to a page in the same application
- D. Redirect to a URL
- E. Submit Page
Answer: A
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 # 100
In your application, you want to include a master aetall containing two pages based on two related tables or views. The first page contains an interactive report for the master table. The second page features a standard form for the master and interactive grids for the detail. Which master detail form will you create?
- A. Editable Interactive Grid
- B. Stacked Master Detail
- C. Side by Side Master Detail
- D. Drill down Master Detail
Answer: D
Explanation:
Explanation
A drill down master detail form allows you to create a master detail form that contains two pages based on two related tables or views. The first page contains an interactive report for the master table. The second page features a standard form for the master and interactive grids for the detail. You can use the Create Page wizard to create a drill down master detail form. References: Creating Master Detail Forms and [Creating a Drill Down Master Detail Form]
NEW QUESTION # 101
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 # 102
To create a Dynamic Action, you need to specify which three of the following options?
- A. Why the action is performed
- B. When the action occurs
- C. What elements are affected by the action
- D. What action or actions are performed
Answer: B,C,D
Explanation:
Explanation
To create a dynamic action, you need to specify at least three options: what action or actions are performed, when the action occurs, and what elements are affected by the action1. The action is the behavior that you want to happen when the event is triggered. You can choose from a list of predefined actions or create your own custom action using JavaScript code1. The event is the user interaction or condition that causes the dynamic action to fire. You can select an event from a list of available events based on the type of element you select1. The affected elements are the items, buttons, or regions that are affected by the action. You can select one or more elements by using jQuery selectors1. You do not need to specify why the action is performed, as this is not a required option for creating a dynamic action.
NEW QUESTION # 103
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, select P21_PRODUCT_NAME and then in the Property Editor, under Layout set Start New Row to Yes.
- B. In Page Designer, use the Middle Pane, click P21 UNIT PRICE and drag the item until it is directly next to P21 PRODUCT_NAME.
- 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, right-click P21_UNIT_PRICE and select Start New Row.
Answer: B,C
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 # 104
Which client credentials are utilized for authentication during the One-Click Remote ApplicationDeployment process?
- A. PEX Developer credentials
- B. Database schema credentials
- C. APEX Workspace Admin credentials
Answer: C
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 # 105
Choose the two correct statements about PWA.
- A. Provides a customizable offline page when users areoffline and cannot request thenetwork.
- B. Enables users to install the application on devices
- C. To download the app as PWA, one must visit the App Store
- D. An existing APEX app cannot be made a PWA
Answer: A,B
NEW QUESTION # 106
Choose the two statements that are TRUE about an Interactive Report. As a developer:
- A. You cannot modify the report source query
- B. You can customize the Actions menu to include or exclude certain options.
- C. You can modify the data in the report after running the app
- D. You can customize the pagination
Answer: C,D
NEW QUESTION # 107
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 # 108
To highlight certain rows in the interactive report based on a condition, you must:
- A. Choose a condition in Format > Highlight
- B. Edit the rows in the report and select a color
- C. Rows cannot be highlighted in an Interactive report
- D. Provide a conditional SQL query
Answer: A
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 # 109
Which two layout options are available for Page Designer under Utilities?
- A. Four Pane Mode
- B. Single Pane Mode
- C. Two Pane Mode
- D. Three Pane Mode
Answer: B,C
Explanation:
Explanation
Page Designer is a tool that allows developers to create and edit pages in Oracle APEX using a graphical user interface. Page Designer has three main panes: Rendering, Processing, and Property Editor. You can change the layout of Page Designer under Utilities by selecting one of the following options:
Single Pane Mode - This option displays only one pane at a time. You can switch between the Rendering, Processing, and Property Editor panes by using the buttons on the toolbar or the keyboard shortcuts.
Two Pane Mode - This option displays two panes side by side. You can choose which panes to display by using the buttons on the toolbar or the keyboard shortcuts. You can also resize the panes by dragging the splitter bar between them. There is no Three Pane Mode or Four Pane Mode option for Page Designer layout. Verified References: [Managing Pages in Page Designer - Oracle Help Center], [Page Designer Layout Options - Oracle Help Center]
NEW QUESTION # 110
Which statement is true about using the App Gallery?
- A. Sample Apps and Starter Apps are only available if your instance administrator has enabled them.
- B. Custom Apps are only available if your instance administrator has enabled them.
- C. You cannot install Sample Apps and Starter Apps directly from the Gallery.
- D. You can download Sample Apps and Starter Apps from Team Development to import into your workspace.
Answer: B
Explanation:
Explanation
Custom Apps are specific to your workspace and are only available if your instance administrator has enabled them. You can install Sample Apps and Starter Apps directly from the Gallery or download them from GitHub. Sample Apps and Starter Apps are available with every Oracle APEX workspace. References: Using the App Gallery and Configuring the Application Gallery
NEW QUESTION # 111
......
100% Free 1z1-770 Files For passing the exam Quickly: https://prep4sure.examtorrent.com/1z1-770-exam-papers.html
