(PDF) Oracle Database 1Z0-770 Exam and Certification Test Engine
Use 1Z0-770 Exam Dumps (2024 PDF Dumps) To Have Reliable 1Z0-770 Test Engine
Oracle APEX Developer Professional exam consists of 70 multiple-choice questions that are based on Oracle APEX version 20.x. 1Z0-770 exam covers different topics such as understanding APEX architecture, creating and managing applications, working with data, security, and troubleshooting APEX applications. Oracle APEX Developer Professional certification exam is designed to evaluate the candidate’s knowledge, skills, and abilities in using Oracle APEX to design and develop web applications that meet the industry standards.
NEW QUESTION # 80
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. Create a dynamic action on form load.
- C. Create a dynamic action on P2_JOB, P2_HIREDATE, and P2_COMM.
- D. Create a dynamic action on P2_HIREDATE and P2_COMM.
- E. ......... and enter SALESMAN for Value.
Answer: A,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 # 81
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: C
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 # 82
What are Task definitions that exist on the application level inthe Shared Components section made up of?
- A. Task Settings
- B. Parameters
- C. Particpants
- D. All of them
- E. Actions
Answer: D
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 # 83
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 # 84
Which statement is true about session state management in Oracle APEX?
- A. A user cannot run multiple instances of an application simultaneously in different browser programs.
- B. APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests.
- C. Multiple number of sessions cannot exist in the database at the same time
Answer: B
Explanation:
Explanation
Session state management is a feature that enables developers to store and retrieve values for a user as the user navigates between different application pages. A session is a logical construct that establishes persistence (or stateful behavior) across page views. Each session is assigned a unique identifier (or session ID). The statement that is true about session state management in Oracle APEX is:
APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests. APEX Sessions are stored in memory within an Application Express engine process while Oracle database sessions are stored in memory within an Oracle database process. The other statements are false because:
A user can run multiple instances of an application simultaneously in different browser programs by using different session IDs.
Multiple number of sessions can exist in the database at the same time for different users or applications.
Verified References: [Understanding Session State Management - Oracle Help Center], [What Is a Session? - Oracle Help Center]
NEW QUESTION # 85
Select the three types of Card Layout you can create in APEX.
- A. Vertical(Column)
- B. Horizontal(Row)
- C. Grid
- D. Float
Answer: B,C,D
Explanation:
Explanation
You can create two types of card layout in APEX: Float and Grid. Float layout displays cards in a single row that wraps to the next row when the available space is filled. Grid layout displays cards in a fixed number of columns that can be responsive to the screen size1. Vertical and Horizontal are not valid card layout types in APEX.
NEW QUESTION # 86
Which of the following options in the Developer Toolbar enables you to customize the look and feel of the application?
- A. Customize
- B. Debug
- C. Session
- D. Quick Edit
Answer: A
Explanation:
Explanation
The Developer Toolbar is a component that appears at the bottom of every page in an Oracle APEX application when running in development mode. The Developer Toolbar provides quick access to various features and tools for developing and debugging an application. One of the options in the Developer Toolbar that enables developers to customize the look and feel of the application is Customize.
Customize: This option opens the Theme Roller tool that allows developers to modify the theme style of the application by changing colors, fonts, sizes, borders, shadows, and more. Developers can also create new theme styles or switch between existing ones using this option.
NEW QUESTION # 87
What are the three types of List of Values(LOV) you can create on a page?
- A. Dynamic LOV
- B. Cascading LOV
- C. Popup LOV
- D. Static LOV
Answer: A,B,D
Explanation:
Explanation
A list of values (LOV) is a definition that provides a set of display values and return values for a page item or a report column. A LOV can be created at the application level as a shared component or at the page level as a local component. There are three types of LOVs that you can create on a page:
Static LOV: A static LOV is based on a fixed list of display values and return values that you specify when you create the LOV. A static LOV does not change unless you edit it manually.
Cascading LOV: A cascading LOV is based on another parent LOV that determines the values of the child LOV. A cascading LOV changes dynamically depending on the selection made in the parent LOV.
Dynamic LOV: A dynamic LOV is based on a SQL query that returns display values and return values from the database. A dynamic LOV changes dynamically depending on the data in the database.
NEW QUESTION # 88
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 # 89
Which two of the following capabilities are TRUE for both Interactive Report and Interactive Grid?
- A. End user can add, modify, and refresh data directly on the report.
- B. End user can save the report
- C. End user can rearrange the report interactively using the mouse.
- D. End user can customize how and what data is displayed.
Answer: A,D
Explanation:
Explanation
An Interactive Report and an Interactive Grid are two types of regions that allow end users to customize how and what data is displayed. They have some common capabilities such as:
End users can add, modify, and refresh data directly on the report by using the Edit option. This option enables inline editing or modal dialog editing depending on the region settings.
End users can customize how and what data is displayed by using the Actions menu. This menu provides various options such as Filter, Highlight, Aggregate, Chart, Group By, Pivot, etc.
The other options are incorrect because:
End users cannot rearrange the report interactively using the mouse in an Interactive Report. This capability is only available in an Interactive Grid by using the Reorder option in the Actions menu.
End users cannot save the report in an Interactive Grid. This capability is only available in an Interactive Report by using the Save Report option in the Actions menu.
Verified References: [About Interactive Reports] [About Interactive Grids]
NEW QUESTION # 90
Choose from the below options the actions that can be performed when a button is clicked.
- A. Redirect to a page in a different application
- B. Submit Page
- C. Redirect to a page in the same application
- D. All of them
- E. Redirect to a URL
Answer: D
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 # 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 the faceted search region Attributes, and turn off the show Facet Name attribute.
- 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 each facet and then in the Property Editor, turn on client-Side Filtering.
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
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. Column Toggle Report
- B. Classic Report
- C. Interactive Grid
- D. Interactive Report
Answer: B
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 # 93
Which statement is true about using the App Gallery?
- A. You cannot install Sample Apps and Starter Apps directly from the Gallery.
- B. Custom Apps are only available if your instance administrator has enabled them.
- C. Sample Apps and Starter Apps are only available if your instance administrator has enabled them.
- 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 # 94
Which two statements that are TRUE about charts in Interactive grid?
- A. Once a chart is created, you can switch the view between Grid and Chart view.
- B. Once the chart is created, it cannot be reconfigured.
- C. To remove a chart, click the Remove Chart icon (X) adjacent to the chart filter
- D. You can create multiple charts at a time in an interactive grid
Answer: A,C
Explanation:
Explanation
You can create a chart in an interactive grid by selecting Chart in the Actions menu. You can only create one chart at a time in an interactive grid. To create a second chart, you have to reconfigure or delete the existing chart1. To remove a chart, you can click the Remove Chart icon (X) adjacent to the chart filter12. Once a chart is created, you can switch the view between Grid and Chart by clicking the toggle that appears at the top of the interactive grid
NEW QUESTION # 95
What three are the uses of Collections in APEX?
- A. You insert, update, and delete collection information using PL/SQL APIAPEX_COLLECTION.
- B. Collections enable you to store rows and columns in the current session into database tables
- C. Use collections to temporarily capture one or more nonscalar Values.
- D. Collections can be accessed, manipulated, or processed during a user's specific session.
Answer: A,C,D
Explanation:
Explanation
Collections are temporary tables that store session-specific data in memory. They can be used for various purposes in APEX applications. Some uses of collections are:
You insert, update, and delete collection information using PL/SQL API APEX_COLLECTION. This API provides several procedures and functions to manipulate collections and their members.
Use collections to temporarily capture one or more nonscalar values. For example, you can use collections to store the results of a query, the values of page items, or the selections of a report.
Collections can be accessed, manipulated, or processed during a user's specific session. For example, you can use collections to pass data between pages, perform calculations on collection members, or create reports based on collections.
Collections do not enable you to store rows and columns in the current session into database tables.
Collections are stored in memory and are not persistent across sessions.
NEW QUESTION # 96
......
Oracle 1Z0-770 (Oracle APEX Developer Professional) Exam is a certification exam for individuals seeking to become a professional Oracle APEX developer. Oracle APEX (Application Express) is a web application development platform that is built on top of the Oracle database, which allows developers to create and deploy web applications quickly and easily. 1Z0-770 exam is designed to test an individual’s knowledge and expertise in Oracle APEX development.
1Z0-770 Dumps Full Questions with Free PDF Questions to Pass: https://www.exams4collection.com/1Z0-770-latest-braindumps.html
1Z0-770 PDF Recently Updated Questions Dumps to Improve Exam Score: https://drive.google.com/open?id=1K_x8EIFOxIjsOjHDgdvrYdoWb9A9GjiE
