100% Accurate Answers! Oct-2023 1z1-770 Actual Real Exam Questions Best Value Available! 2023 Realistic Verified Free 1z1-770 Exam Questions NEW QUESTION # 78 Which two statements are TRUE about Dynamic Actions? A. Dynamic actions provide a way to define complex client-sidebehaviordeclaratively without the need for JavaScript. B. It is not possible to debug Dynamic Actions from the Developer Toolbar [...]

All Products Contact now

100% Accurate Answers! Oct-2023 1z1-770 Actual Real Exam Questions [Q78-Q101]

Share

100% Accurate Answers! Oct-2023 1z1-770 Actual Real Exam Questions

Best Value Available! 2023 Realistic Verified Free 1z1-770 Exam Questions

NEW QUESTION # 78
Which two statements are TRUE about Dynamic Actions?

  • A. Dynamic actions provide a way to define complex client-sidebehaviordeclaratively without the need for JavaScript.
  • B. It is not possible to debug Dynamic Actions from the Developer Toolbar
  • C. More dynamic actions you add to a page, the greater your overall page size.
  • D. Dynamic Actions require complex client side Javascript code

Answer: A,C

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 # 79
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. Subscribing the copied theme to the master theme and refreshing the theme
  • B. Refreshing the templates
  • C. Copying the changes made in the master theme to the copied theme
  • D. Verifying the theme subscription

Answer: A

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 # 80
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. A single REST Data Source can use multiple remote servers.
  • D. The remote server should mandatorily be an APEX instance.

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 # 81
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. #APEXSPK VALUE#, #APEX$NEW START DATE# and #APEXSNEW END DATE#
  • B. :APEX$PK_VALUE, APEX$NEW START DATE and APEXSNEW_END_DATE
  • C. #APEX.PK_VALUE#, #APEX.NEW START_DATE# and #APEX.NEW_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 # 82
When you create a Dynamic Action, you specify the event that causes the dynamic action to fire.
Choose the categories these events are classified into.

  • A. Browser Events
  • B. Component Events
  • C. All of them
  • D. Framework Events
  • E. Custom Events

Answer: C

Explanation:
Explanation
The events that cause the dynamic action to fire are classified into five categories: Browser Events, Component Events, Custom Events, Framework Events, and jQuery Events1. Browser events are triggered by user interactions with the browser window, such as resize, scroll, or unload. Component events are triggered by user interactions with specific APEX components, such as interactive grids, interactive reports, or trees.
Custom events are user-defined events that can be triggered by other dynamic actions or JavaScript code.
Framework events are triggered by APEX framework actions, such as page load, page submit, or dialog close. jQuery events are triggered by user interactions with jQuery UI widgets, such as accordion, tabs, or date picker1.


NEW QUESTION # 83
The Page Designer Toolbar allows you to perform which two of the following actions?

  • A. Export the application
  • B. Delete the application
  • C. Create a new page
  • D. Navigate to Shared Components

Answer: C,D

Explanation:
Explanation
The Page Designer Toolbar allows you to perform various actions related to the development of an APEX page. Two of the actions that you can perform are:
Navigate to Shared Components: This option lets you access the shared components of your application, such as lists, breadcrumbs, navigation menus, and so on. You can edit, create, or delete shared components from this option. To access this option, click the icon that resembles a puzzle piece on the Page Designer Toolbar.
Create a new page: This option lets you create a new page for your application using the Create Page Wizard. You can choose from different page types, such as blank page, form, report, chart, calendar, and so on. To access this option, click the icon that resembles a plus sign (+) on the Page Designer Toolbar.


NEW QUESTION # 84
Choose the two correct statements about PWA.

  • A. Enables users to install the application on devices
  • B. Provides a customizable offline page when users areoffline and cannot request thenetwork.
  • C. An existing APEX app cannot be made a PWA
  • D. To download the app as PWA, one must visit the App Store

Answer: A,B


NEW QUESTION # 85
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 Processing
  • B. Page Rendering
  • C. Page rendering and processing
  • D. Page compilation

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 # 86
In APEX, you can choose which three of the following Authentication methods?

  • A. Authorization Scheme
  • B. No Authentication
  • C. Custom Authentication Scheme
  • D. Built-in Authentication Scheme

Answer: B,C,D

Explanation:
Explanation
In Oracle APEX, you can choose from different authentication methods to establish a user's identity and control access to your application. Authentication may require a user to provide some type of credentials, such as a user name and password, or could involve the use of digital certificates or a secure key. Three of the authentication methods that you can choose in Oracle APEX are:
Custom Authentication Scheme: This method allows you to create your own authentication logic using PL/SQL code or an external web service. You can also customize the login page and session management for your application.
No Authentication (using DAD): This method adopts the current database user as the authenticated user.
This approach can be used in combination with a mod_plsql Database Access Descriptor (DAD) configuration that uses basic authentication to set the database session user.
Built-in Authentication Scheme: This method allows you to use one of the preconfigured authentication schemes that ship with Oracle APEX, such as Open Door Credentials, LDAP Directory, Social Sign-In, and so on.


NEW QUESTION # 87
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.
  • B. ......... and enter SALESMAN for Value.
  • C. Create a dynamic action on P2_JOB, P2_HIREDATE, and P2_COMM.
  • D. Create a dynamic action on form load.
  • E. Create a dynamic action on P2_HIREDATE and P2_COMM.

Answer: A,B

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 # 88
What three are the building blocks of Approvals Component?

  • A. Unified Task List
  • B. Task Details Page
  • 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 # 89
Which two statements are true about creating and managing an APEX Workspace?

  • A. During workspace creation, you can associate the workspace with an existing databaseschema.
  • B. A workspace can be associated with only one schema.
  • C. You can create only two workspaces in an APEX Service(APEX Application Development)instance.
  • D. New schemas cannot be created during workspace creation.
  • E. A workspace enables multiple users to work within the same Oracle APEX installation.

Answer: A,E

Explanation:
Explanation
A workspace is a logical work area that enables multiple users to work within the same Oracle APEX installation while keeping their objects, data, and applications private. Creating and managing an APEX workspace involves the following statements:
During workspace creation, you can associate the workspace with an existing database schema or create a new schema for the workspace. A schema is a collection of database objects such as tables, views, indexes, etc. that belong to a user.
A workspace enables multiple users to work within the same Oracle APEX installation. Each user can have a different role and privilege in the workspace, such as workspace administrator, developer, or end user.
A workspace can be associated with one or more schemas. You can add or remove schemas from a workspace after it is created.
You can create as many workspaces as you need in an APEX Service (APEX Application Development) instance. There is no limit on the number of workspaces per instance.
Verified References: Managing WorkspacesAbout Workspaces


NEW QUESTION # 90
Which of the following are preconfigured authentication schemes?

  • A. Open Door Credentials
  • B. HTTP Header Variables
  • C. All of them
  • D. Social Sign In
  • E. LDAP Directory

Answer: C

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 # 91
Which two statements are true about Faceted Search pages?

  • A. Faceted Search supports the ability to filter columns storing multiple values as one string.
  • B. Multiple charts are not visible in the same region.
  • C. Facets map to specific database columns.
  • D. A facet's chart can be seen only in a nonmodal dialog.

Answer: A,C

Explanation:
Explanation
Faceted Search is a feature 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. Faceted Search supports the ability to filter columns storing multiple values as one string, such as comma-separated values or JSON arrays, by using the Split Values attribute. Facets map to specific database columns or expressions that are defined in the Data Source attribute of the faceted search region. The other statements are false because Faceted Search supports displaying multiple charts in the same region by using the Chart View attribute, and a facet's chart can be seen either in a nonmodal dialog or inline by using the Chart Display Mode attribute. Verified References: [Creating Faceted Search Pages - Oracle Help Center], [Facet Attributes - Oracle APEX]


NEW QUESTION # 92
When a button is pressed, an overlay window is positioned within the viewport. What kind ofpage mode is it?

  • A. Help Page
  • B. Normal Page
  • C. Modal Dialog
  • D. Non-Modal Dialog

Answer: C

Explanation:
Explanation
A modal dialog is a type of page mode that displays an overlay window within the viewport when a button is pressed. A modal dialog is a stand-alone page that does not interact with the base page where it was launched.
A modal dialog blocks access to the base page until it is closed by the user. A modal dialog can be used for various purposes, such as displaying additional information, confirming an action, or collecting user input.


NEW QUESTION # 93
Which statement is true about the Approvals component?

  • A. You can set up task approvers and administrators at design time or determine themdynamically at runtime based on data related to the task.
  • B. Task Definition is a page that shows details for a specific task, which can include metadata, history, comments, and actions.
  • C. Unified Task List is a shared component used to configure task parameters,participants, actions, and due dates.
  • D. APEX_APPROVAL is Page processes that create andact on task instances in yourpages.

Answer: A

Explanation:
Explanation
The Approvals Component is a feature in Oracle APEX that enables you to create and manage tasks for user approval. The Approvals Component deals with all aspects of human approval in Oracle APEX, allowing you to put approval functionality into your applications. The Approvals Component creates one or more tasks for items that require approval based on a pre-configured template, known as the Task Definition. The Task Definition specifies the data source, display attributes, potential owners, business administrators, and available actions for the tasks. You can set up task approvers and administrators at design time or determine them dynamically at runtime based on data related to the task. For example, you can use a SQL query or a PL/SQL function to return the list of potential owners or business administrators for each task based on some criteria, such as department, role, or location.


NEW QUESTION # 94
Which two statements are true about creating and using an interactive report?

  • A. You cannot customize the Search Button Label.
  • B. You cannot restrict users from saving private reports by using the Authorization Scheme.
  • C. You cannot include Form Page when creating an interactive report page using the Create Page Wizard.
  • D. You can specify an Authorization Scheme at the column level.

Answer: A,D


NEW QUESTION # 95
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. The search results report can be displayed as an interactive grid
  • D. If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache.

Answer: A,D

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 # 96
Which two statements are true about REST Data Sources?

  • A. Oracle APEX doesn't provide direct integration of REST Data Sources in interactivereports
  • B. AREST Data Source can contain one or many Operations which are the references toa concrete external web service
  • C. Oracle APEX supports the REST Enabled SQL Query REST Data Source type
  • 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 # 97
When you create an Access Control Page, which three of the following Access Roles get created?

  • A. Administrator
  • B. Reader
  • C. Developer
  • D. Contributor

Answer: A,B,D

Explanation:
Explanation
When you create an Access Control Page using the Create Page Wizard, three of the following Access Roles get created: Reader, Administrator, and Contributor. These roles are predefined by APEX and correspond to the authorization schemes that control the access to the application, pages, or page components1. Reader role grants read-only access to the application. Administrator role grants full access to the application, including administrative and edit privileges. Contributor role grants edit privileges to the application, but not administrative privileges2. Developer role is not a default Access Role created by the wizard, but you can create your own custom roles and assign them to users on the Application Access Control page.


NEW QUESTION # 98
Which two are true when the Edit option is NOT enabled for an Interactive Grid?

  • A. The end user can customize the report
  • B. The end user cannot create charts
  • C. The end user cannot edit the underlying data in the database
  • D. The end user can edit the underlying data in the database

Answer: A,C

Explanation:
Explanation
An interactive grid is a component that displays data in a tabular format and allows users to perform various actions on the data, such as sorting, filtering, grouping, highlighting, and editing. However, the editing feature is optional and can be enabled or disabled by the developer. When the Edit option is not enabled for an interactive grid, the following statements are true:
The end user cannot edit the underlying data in the database. The interactive grid becomes read-only and does not allow users to add, modify, or delete rows. The Add Row and Save buttons are hidden from the toolbar and the cells are not editable.
The end user can customize the report. The interactive grid still allows users to change the appearance and behavior of the report using the Actions menu. Users can perform actions such as changing column order, resizing column width, hiding or showing columns, applying filters or highlights, creating control breaks or charts, and saving reports.


NEW QUESTION # 99
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. Cards
  • D. Stacked Master Detail

Answer: D

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 # 100
Which two statements are true about creating and using dynamic actions?

  • A. Once you create a dynamic action, you cannot add additional true actions.
  • B. If a client-side condition is defined, the true action will fire when the condition is met, and the false action will fire when it is not
  • C. If no client-side condition is defined, true actions will not fire.
  • D. You can execute JavaScript code by creating a dynamic action.

Answer: B,D

Explanation:
Explanation
Dynamic actions are a declarative way to define client-side behavior without writing JavaScript code. You can create dynamic actions on an item, button, or region of a page by specifying the event, condition, affected elements, action, and other properties. Some of the statements that are true about creating and using dynamic actions are:
You can execute JavaScript code by creating a dynamic action. One of the supported action types is Execute JavaScript Code, which allows you to enter custom JavaScript code to run when the dynamic action fires.
If a client-side condition is defined, the true action will fire when the condition is met, and the false action will fire when it is not. You can define a client-side condition for a dynamic action to control when it should fire based on an expression or value. You can also define different actions for the true and false branches of the condition. You can add additional true actions to a dynamic action by clicking the Add True Action button in the Property Editor. If no client-side condition is defined, true actions will fire when the event occurs. Verified References: [Oracle Application Express 18: Creating Dynamic Actions], [Dynamic Action Enhancements in APEX 21.1 - Oracle Blogs]


NEW QUESTION # 101
......


With a successful completion of the Oracle 1Z0-770 Exam, you earn the Oracle APEX Developer Professional Certification, which qualifies you to develop and maintain advanced Oracle APEX applications. Achieving the Oracle APEX Developer Professional Certification enhances your skills portfolio and opens up career opportunities in Oracle APEX development.

 

Actual Questions Answers Pass With Real 1z1-770 Exam Dumps: https://examcollection.guidetorrent.com/1z1-770-dumps-questions.html

Related Articles

more
Oracle 1z1-770 Certification Practice Exam