Use the best ways of preparing for 1z1-770 Exam Dumps with Fast2test Oracle 1z1-770 dump PDF [2024]
Oracle 1z1-770 exam candidates will surely pass the Exam if they consider the 1z1-770 dumps learning material presented by Fast2test.
NEW QUESTION # 39
An Employees App includes a form to enter and update employee details.
Examine this Exhibit.
Now you must extend the functionality of this form so that:
* If you select 'SALESMAN' from the select list for Job page item (P2_JOB), both the 'Hire date' (P2_HIREDATE) and 'Commission' (P2_COMM) page items and their associated labels are displayed
* If you select any other value from the select list for Job page item (P2_JOB), both the 'Hire date' (P2_HIREDATE) and 'Commission' (P2_COMM) page items and their associated labels are hidden Which two steps must be performed?
- A. Create a dynamic action on P2_JOB, P2_HIREDATE, and P2_COMM.
- B. ......... and enter SALESMAN for Value.
- C. Create a dynamic action on P2_HIREDATE and P2_COMM.
- D. Create a dynamic action on form load.
- E. Create a dynamic action on P2_JOB.
Answer: B,E
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 # 40
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 # 41
You must create a single master detail page where users can select a row in the master grid to update the detail grids.
Users must also interact with the master or the detail without leaving the page.
Which type of master detail implementation should you use?
- A. Drill Down
- B. Stacked
- C. Side by Side
Answer: B
Explanation:
Explanation
A stacked master detail is a type of master detail implementation that features two editable interactive grids based on two related tables or views. Users can select a row in the master grid to update the detail grid. Users can also interact with the master or the detail without leaving the page. A stacked master detail is suitable for scenarios where you want to display and edit data from a one-to-many relationship in a single page. You can create a stacked master detail using either the Create Application Wizard or the Create Page Wizard. Verified References: [Managing Master Detail Forms - Oracle Help Center], [Creating a Single Page Master Detail Using the Create Application Wizard - Oracle Help Center]
NEW QUESTION # 42
Which client credentials are utilized for authentication during the One-Click Remote ApplicationDeployment process?
- A. APEX Workspace Admin credentials
- B. PEX Developer credentials
- C. Database schema 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 # 43
You can create a report in which of the three following methods?
- A. Create a report as a new page in an application
- B. Create a report from Object Browser
- C. Create a report when you create a new database application
- D. Create a report region on a page in an application
Answer: A,C,D
Explanation:
Explanation
You can create a report in any of these three methods:
Create a report as a new page in an application by using the Create Page Wizard. This wizard guides you through the steps of selecting a page type, defining attributes, selecting a source (such as SQL query or table), and adding items or buttons.
Create a report when you create a new database application by using the Create Application Wizard.
This wizard allows you to generate one or more reports based on existing tables or views in your schema. You can also create a report and form on the same table or view.
Create a report region on a page in an application by using the Page Designer. This tool allows you to drag and drop a region type (such as Classic Report, Interactive Report, or Interactive Grid) onto the page and define its attributes and source.
The other option is incorrect because:
You cannot create a report from Object Browser. Object Browser is a tool that allows you to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can only run SQL queries or scripts from this tool, not create reports.
Verified References: [Creating Database Applications] [Creating Pages] [Creating Regions] [Using Object Browser]
NEW QUESTION # 44
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 turn off the show Facet Name attribute. Then, navigate to each facet and in the Property Editor, turn on client-Side Filtering.
- B. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute
- C. Navigate to each facet and then in the Property Editor, turn on client-Side Filtering.
- D. Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute.
Answer: B
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 # 45
Which statement is true about creating and using a report with form?
- A. The Create Page Wizard doesn't support the creation of a classic report and formcombination
- B. In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source).
- C. Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination.
- D. The Create Application Wizard doesn't support the creation of an interactive report and form combination.
Answer: C
Explanation:
Explanation
You can create a report with form in Oracle APEX by using either the Create Application Wizard or the Create Page Wizard. The report can be either an interactive report or a classic report, and the form can be either a single row form or a multi row form. The report with form combination enables you to view and edit data from a table or a query in a single page. You can also customize the report and form attributes, such as the columns, regions, buttons, validations, processes, and so on. Verified References: [Creating a Report Using the Create Page Wizard - Oracle], [Creating a Report with Form on Table - Oracle]
NEW QUESTION # 46
Which three of the following statements are TRUE about saved Public Interactive Grids?
- A. To enable an end user to save a public interactive grid, the user must have the required permission
- B. Only the user who creates a public interactive grid can save, rename, or delete it
- C. Public reports are available to all users
- D. Any user may save public interactive grids
Answer: A,B,C
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 # 47
Choose the three types of aggregations you can apply on a column.
- A. Sum
- B. Count
- C. Average
- D. Standard Deviation
Answer: A,B,C
NEW QUESTION # 48
Select the two places from where you can access the Shared Components Page?
- A. SQL Workshop
- B. Page Designer
- C. Gallery
- D. Application homepage
Answer: B,D
Explanation:
Explanation
You can access the Shared Components page from two places in App Builder: the Page Designer and the Application home page. In Page Designer, you can click on the Shared Components icon at the top of the page to open the Shared Components page in a new tab5. In the Application home page, you can click on the Shared Components link in the center of the page to navigate to the Shared Components page6. Gallery, SQL Workshop, and other pages do not have direct links to the Shared Components page.
NEW QUESTION # 49
Which statement is true about the Link Column attribute of an interactive report?
- A. A Link Column cannot be sorted, hidden, or moved by an end user.
- B. It is not possible to include a custom target in Link Column
- C. If you select Link Column, it is always displayed as the last column in the report.
- D. It is not possible to exclude Link Column.
Answer: A
Explanation:
Explanation
A Link Column is a special column type that you can define for an interactive report to create a link to another page, URL, or custom target. A Link Column is always displayed as the first column in the report, regardless of the order of the columns in the query. A Link Column cannot be sorted, hidden, or moved by an end user using the Actions menu or the column header. However, a developer can change the position and visibility of a Link Column by editing the report attributes in Page Designer.
NEW QUESTION # 50
Which two Plugin types can be created in Oracle APEX?
- A. Process
- B. Email Template
- C. Region
- D. Validation
Answer: A,C
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 # 51
To highlight certain rows in the interactive report based on a condition, you must:
- A. Provide a conditional SQL query
- B. Rows cannot be highlighted in an Interactive report
- C. Choose a condition in Format > Highlight
- D. Edit the rows in the report and select a color
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 # 52
You use the Create Page Wizard to create a faceted search page on the EMP table. What is the default report type generated for this page?
- A. Classic Report
- B. Interactive Grid
- C. Column Toggle Report
- D. Interactive Report
Answer: A
Explanation:
Explanation
When you use the Create Page Wizard to create a faceted search page on any table or SQL query, such as EMP table, APEX generates a classic report region as default report type for this page. A classic report region displays data from a SQL query or PL/SQL function returning a SQL query in tabular format. A faceted search page also contains a region of Faceted Search type, which holds one or more facets that allow end users to filter data by applying one or more facets. Verified References: Creating Faceted Search Pages - Oracle Help Center, Creating Classic Reports - Oracle Help Center
NEW QUESTION # 53
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. Lists
- B. Breadcrumbs
- C. Navigation Bar List
- 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 # 54
What are Task definitions that exist on the application level inthe Shared Components section made up of?
- A. Actions
- B. All of them
- C. Task Settings
- D. Parameters
- E. Particpants
Answer: B
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 # 55
Which three statements are TRUE about Search Configuration?
- A. Only one Search Configuration can be used in a Search Page.
- B. One or more Search Configurations can be configured in a Search Page.
- C. Search Configuration is a shared component defines the data source to be searched and the way results should be displayed.
- D. Searches can be based on Local data, APEX Lists, REST Enabled SQL Service, or REST Data Sources.
Answer: B,C,D
Explanation:
Explanation
Search configuration is a shared component that defines the data source to be searched and the way results should be displayed. You can create a search configuration based on a local data source (table or SQL query), an APEX list, a REST enabled SQL service, or a REST data source2. You can use one or more search configurations in a search page, depending on the search type you select. For example, you can use multiple search configurations for a standard search, but only one search configuration for an Oracle TEXT or a list search2.
NEW QUESTION # 56
Select the two advantages of using One-click Remote Deployment.
- A. You need to access your production environment to import the app directly.
- B. Directly deploy your app definition along with the objects from the source system to the target system
- C. Simplify the process of deploying an application
- D. Deploy the app, and explicitly install the supporting objects in one-click.
Answer: B,D
Explanation:
Explanation
One-click remote application deployment is a feature in Oracle APEX that simplifies the process of deploying an application from one APEX instance to another using REST Enabled SQL references. REST Enabled SQL references are shared components that work with an Oracle REST Data Services (ORDS) REST Enabled SQL Service. One-click remote application deployment can authenticate through first party authentication (Basic Authentication), Schema Authentication (database username and password), or OAuth 2 Client Credentials.
Two of the advantages of using one-click remote application deployment are:
Deploy the app, and explicitly install the supporting objects in one-click. This advantage allows you to package the app definition along with the database objects, images, and seed data necessary for your application to run correctly using the Supporting Objects functionality in APEX. You can then export and deploy this app and install the supporting objects in one-click without having to manually create or copy the database objects in the target system.
Directly deploy your app definition along with the objects from the source system to the target system.
This advantage allows you to avoid the intermediate step of exporting the app and its objects from the source system into files and then importing them into the target system. You can directly deploy your app and its objects from within your development environment to the remote production environment without having to access your production environment.
NEW QUESTION # 57
Which two are true about Oracle APEX?
- A. Performs the data processing in a middle-tier server
- B. Requires no additional client software. A web browser is the app development IDE.
- C. Requires developers to be proficient in Java, Python and other programming languages.
- D. Is declarative. It requires no code generation.
Answer: B,D
Explanation:
Explanation
Oracle APEX is a low-code development platform that enables you to build database-centric web applications using only a web browser. Oracle APEX has the following features:
Requires no additional client software. A web browser is the app development IDE: You can use any modern web browser to access the Oracle APEX development environment and build your applications.
You do not need to install or configure any additional software or tools on your client machine.
Is declarative. It requires no code generation: You can use declarative tools, visual editors, drag-and-drop components, and pre-built templates to define your application logic, user interface, security, and integration features. You do not need to write or generate any code for your applications.
The other options are incorrect because:
Performs the data processing in a middle-tier server: Oracle APEX performs the data processing in the database server. It uses SQL and PL/SQL to access and manipulate the data stored in the database. It does not rely on any middle-tier server or framework for data processing.
Requires developers to be proficient in Java, Python and other programming languages: Oracle APEX does not require developers to be proficient in Java, Python or other programming languages. It uses SQL and PL/SQL as the primarylanguages for data processing. It also supports HTML, CSS, JavaScript, and jQuery for user interface development.
Verified References: [About Oracle APEX] [Oracle APEX Architecture]
NEW QUESTION # 58
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. If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache.
- C. The search results report can be displayed as an interactive report.
- D. The search results report can be displayed as an interactive grid
Answer: A,B
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 # 59
Choose the statement that is TRUE about Universal Theme.
- A. Features a responsive design and enables developers to create web applications without extensive knowledge of HTML, CSS, or JavaScript
- B. All of them
- C. Universal theme is the default theme that is shipped with Oracle APEX
- D. Uses a 12-column grid layout system for arranging components on a page.Ships with a variety of pre-built theme styles
Answer: B
Explanation:
Explanation
Universal Theme is a responsive, versatile, and customizable user interface for your APEX apps. It is designed uniquely for Oracle APEX to make it easy for developers to build beautiful, modern applications, at any scale, for any purpose, that work on any device. All of the statements given are true about Universal Theme:
Features a responsive design and enables developers to create web applications without extensive knowledge of HTML, CSS, or JavaScript. Universal Theme adapts to different screen sizes and devices using CSS media queries and grid layout. It also provides a rich set of UI components, template options, and theme styles that can be used declaratively without writing custom code.
Universal theme is the default theme that is shipped with Oracle APEX. Universal Theme is the default theme for new applications created in APEX 5.0 or later. It is also the recommended theme for upgrading existing applications to the latest version of APEX.
Uses a 12-column grid layout system for arranging components on a page. Ships with a variety of pre-built theme styles. Universal Theme uses a 12-column grid layout system based on Flexbox to arrange components on a page. It also ships with a variety of pre-built theme styles that can be applied to change the look and feel of the application.
NEW QUESTION # 60
Which two statements are true about a Progressive Web Application (PWA)?
- A. To use the PWA feature, the Friendly URLS attribute in the Application Definition, Properties section must be turned Off.
- B. Enabling the PWA functionality optimizes page loading speed on a mobile device.
- C. Enabling the PWA functionality in your APEX app adds a new navigation bar entry named Install App to your app.
- D. You can create a PWA only when creating a new application with the Create Application Wizard.
- E. PWA features will be rendered even if the application is served in an unsecured environment.
Answer: B,C
Explanation:
Explanation
A Progressive Web Application (PWA) is a web application that uses modern web technologies and best practices to provide a native app-like experience to users. Enabling the PWA functionality in your APEX app has the following benefits:
It optimizes page loading speed on a mobile device by caching static resources and using service workers to handle network requests.
It adds a new navigation bar entry named Install App to your app, which allows users to install the app on their device's home screen and access it offline.
It enhances the app's appearance and behavior by using a manifest file to specify the app's name, icon, theme color, orientation, and display mode.
The other options are incorrect because:
To use the PWA feature, the Friendly URLS attribute in the Application Definition, Properties section must be turned On. This attribute enables user-friendly URLs that are required for PWA functionality.
PWA features will not be rendered if the application is served in an unsecured environment. The application must use HTTPS protocol to enable PWA functionality.
You can create a PWA from an existing application or a new application with the Create Application Wizard. You just need to enable the PWA functionality in the User Interface section of the Application Definition.
Verified References: Progressive Web ApplicationsEnabling Progressive Web Application Functionality
NEW QUESTION # 61
To create a Dynamic Action, you need to specify which three of the following options?
- A. What action or actions are performed
- B. What elements are affected by the action
- C. Why the action is performed
- D. When the action occurs
Answer: A,B,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 # 62
......
Full 1z1-770 Practice Test and 144 unique questions with explanations waiting just for you, get it now: https://drive.google.com/open?id=16rfEdPJV0y4yU9-SdNjpvMKkTO9AJxqE
Accurate & Verified Answers As Seen in the Real Exam here: https://www.fast2test.com/1z1-770-premium-file.html