[2024] New 1Z0-770 exam Free Sample Questions to Practice
Cover Real 1Z0-770 Exam Questions Make Sure You 100% Pass
Oracle 1Z0-770 exam consists of 60 multiple-choice questions and must be completed within 105 minutes. 1Z0-770 exam is available in English and Japanese and can be taken at any Pearson VUE testing center worldwide. 1Z0-770 exam can also be taken online from a candidate's home or office using a remote proctoring service.
NEW QUESTION # 49
Which two statements that are TRUE about charts in Interactive grid?
- A. To remove a chart, click the Remove Chart icon (X) adjacent to the chart filter
- B. Once a chart is created, you can switch the view between Grid and Chart view.
- C. You can create multiple charts at a time in an interactive grid
- D. Once the chart is created, it cannot be reconfigured.
Answer: A,B
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 # 50
What are the two primary ways to move database objects and data from one environment toanother, for a single application?
- A. App Builder
- B. SQL Workshop
- C. Oracle SQL Developer
- D. Page Designer
Answer: B,C
Explanation:
Explanation
Oracle SQL Developer and SQL Workshop are two primary ways to move database objects and data from one environment to another, for a single application. Oracle SQL Developer is a graphical tool that allows you to export and import data schemas using Data Pump or SQL scripts. SQL Workshop is a component of Oracle APEX that enables you to perform tasks such as exporting and importing data, running SQL commands, and generating DDL scripts. Both tools can help you migrate your database objects and data to a different instance or workspace. References: Using SQL Developer to Migrate Your Oracle Database and Using Data Workshop to Manage Data
NEW QUESTION # 51
Which search type in Search Configurations provides linguistic and fuzzy search capabilities?
- A. Oracle Text
- B. Standard
- C. List
Answer: A
Explanation:
Explanation
Search Configurations is a feature that allows developers to define how end users can search for data in an application. There are three types of search configurations: Standard, List, and Oracle Text. Oracle Text is a search type that provides linguistic and fuzzy search capabilities by using an Oracle Text index on a table column or view column. Linguistic search enables end users to search for data based on language-specific rules and preferences, such as stemming, stopwords, synonyms, etc. Fuzzy search enables end users to search for data based on approximate matches that account for spelling errors, typos, OCR errors, etc. Verified References: [Managing Search Configurations - Oracle Help Center], [Oracle Text User's Guide]
NEW QUESTION # 52
Which statement is true about the Approvals component?
- A. Task Definition is a page that shows details for a specific task, which can include metadata, history, comments, and actions.
- B. Unified Task List is a shared component used to configure task parameters,participants, actions, and due dates.
- C. You can set up task approvers and administrators at design time or determine themdynamically at runtime based on data related to the task.
- D. APEX_APPROVAL is Page processes that create andact on task instances in yourpages.
Answer: C
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 # 53
Which three are the main components of APEX workspace homepage?
- A. Gallery
- B. RESTful Services
- C. App Builder
- D. SQL Workshop
Answer: A,C,D
Explanation:
Explanation
The main components of an APEX workspace homepage are:
Gallery: This component displays various sample applications, blueprints, plug-ins, themes, and learning resources that you can use to get started with Oracle APEX.
SQL Workshop: This component allows you to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can also use this component to run SQL queries or scripts, load or unload data from the database, generate DDL statements, view object reports, and restore dropped objects.
App Builder: This component allows you to create and edit your applications using the Create Application Wizard or the Page Designer. You can also use this component to import or export applications from files or URLs, run or debug applications, manage application settings, and access various utilities.
The other option is incorrect because:
RESTful Services: This component is not part of the APEX workspace homepage. It is part of the SQL Workshop component. It allows you to create and manage RESTful web services based on your database objects or SQL queries.
Verified References: [About the Workspace Home Page] [About SQL Workshop] [About App Builder]
NEW QUESTION # 54
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_HIREDATE and P2_COMM.
- B. ......... and enter SALESMAN for Value.
- C. Create a dynamic action on P2_JOB.
- D. Create a dynamic action on form load.
- E. Create a dynamic action on P2_JOB, P2_HIREDATE, and P2_COMM.
Answer: B,C
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 # 55
Consider a customers report. A customer name is clicked in the report to display the Customer Details form. When the items in the form dialog are updated and the user clicks Apply Changes, the page process is executed and the items from the page are used to update and commit the underlying table in the Oracle Database. What are the two types of events that occurred in this scenario?
- A. Page Refresh
- B. Page Rendering
- C. Page Processing
- D. Page Validation
Answer: C,D
Explanation:
Explanation
When the customer name is clicked in the report, the Customer Details form dialog page is displayed. This is a page rendering event, which means the page is generated and sent to the browser. When the items in the form dialog are updated and the user clicks Apply Changes, the page process is executed and the items from the page are used to update and commit the underlying table in the Oracle Database. This is a page processing event, which means the page is submitted to the server and processed by APEX. Page validation is also a part of page processing, but it is not a separate event. Page refresh is not an event, but an action that can be triggered by a dynamic action or a process
NEW QUESTION # 56
You want to enable anyone to access your application using a built-in login page that captures a user name.
Whichauthentication scheme would youchoose?
- A. No Authentication
- B. Custom Authentication
- C. Social Sign-In
- D. Open Door Credentials
Answer: D
Explanation:
Explanation
Open Door Credentials is an authentication scheme that allows anyone to access your application using a built-in login page that captures a user name. You can use this scheme for testing purposes or for applications that do not require secure authentication. You can select this scheme from the Authentication Type list when creating or editing an authentication scheme. References: [Understanding Authentication] and [Creating an Authentication Scheme]
NEW QUESTION # 57
Which two Query Source types can be used to create a dynamic Navigation Bar List?
- A. Select List
- B. SQL Query
- C. Function Returning SQL Query
- D. Procedure
Answer: B,C
Explanation:
Explanation
The Query Source types for a Navigation Bar List are SQL Query and Function Returning SQL Query. These types allow you to define the list entries using a SQL statement or a PL/SQL function that returns a SQL statement. The other options, Select List and Procedure, are not valid for a Navigation Bar List. Verified References: Create Page Wizard: Navigation Bar List AttributesCreating Lists
NEW QUESTION # 58
Which is a valid method of logging messages to the execution log in APEX automation?
- A. apex_automation.log_info('SAL for || :ENAME || increased by 18.');
- B. apex_debug.info ('SAL for ' || :ENAME || ' increased by 1%.');
- C. apex error.add error ( p_message => 'SAL for || :ENAME || increased by 1%.', p_display_location => apex_error.c_inline_in_notification );
Answer: B
Explanation:
Explanation
APEX automation is a feature that allows you to automate tasks such as data loading, data synchronization, application export and import, and REST API calls by using declarative actions or PL/SQL code blocks. You can create automation tasks by using the Database Actions interface or by using the APEX_AUTOMATION package. To log messages to the execution log in APEX automation, you can use the APEX_DEBUG package with any of its logging levels (info, warning, error, etc.). The other options are not valid methods of logging messages in APEX automation. Verified References: [Using APEX Automation - Oracle Help Center],
[APEX_DEBUG - Oracle Help Center]
NEW QUESTION # 59
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 # 60
While migrating apps, once the database objects are created in the target environment, you canload the data using which of the components?
- A. Data Generator
- B. App Builder
- C. Data Workshop
- D. Quick SQL
Answer: C
Explanation:
Explanation
Data Workshop is a feature in Oracle APEX that enables you to load and unload data to and from the database.
You can use Data Workshop to copy data between Oracle databases or between an Oracle database and external files. Data copying is accomplished by exporting and importing data, and by unloading and loading data. While migrating apps, once the database objects are created in the target environment, you can load the data using Data Workshop by following these steps:
Access Data Workshop by clicking Utilities and then Data Workshop in SQL Workshop.
Click Load Data.
Select a data source type, such as Text File (CSV), XML File (XML), Copy & Paste (Spreadsheet), or Object Store Reference (Autonomous Database only).
Specify a file name or location for your data source.
Select a table name for your data destination.
Map your data columns to your table columns.
Review your data load settings and click Load Data.
NEW QUESTION # 61
Which two statements are true about creating and using dynamic actions?
- A. You can execute JavaScript code by creating a dynamic action.
- 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. Once you create a dynamic action, you cannot add additional true actions.
Answer: A,B
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 # 62
Which two actions can you perform using the Object Browser?
- A. Create and run SQL scripts.
- B. Create a lookup table based on a column in the current table.
- C. Browse database objects of the current schema.
- D. Export and import SQL scripts.
- E. Restore dropped database objects.
Answer: B,C
Explanation:
Explanation
Object Browser is a utility in SQL Workshop that enables developers to browse, create, and edit objects in a database. Some of the actions that you can perform using Object Browser are:
Browse database objects of the current schema. You can view the details of an object by selecting it from the Object Tree and then clicking the different object detail tabs.
Create a lookup table based on a column in the current table. You can use the Create Lookup Table option in the Column Details tab to create a new table that stores the distinct values of the selected column and a foreign key constraint to reference it. You cannot restore dropped database objects, create and run SQL scripts, or export and import SQL scripts using Object Browser. You can use other utilities in SQL Workshop to perform these actions, such as Recycle Bin,SQL Commands, and SQL Scripts.
Verified References: [Managing Database Objects with Object Browser - Oracle Help Center], [Creating Lookup Tables - Oracle Help Center]
NEW QUESTION # 63
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. Interactive Report
- B. Column Toggle Report
- C. Classic Report
- D. Interactive Grid
Answer: C
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 # 64
Select the two advantages of using One-click Remote Deployment.
- A. Deploy the app, and explicitly install the supporting objects in one-click.
- B. You need to access your production environment to import the app directly.
- C. Directly deploy your app definition along with the objects from the source system to the target system
- D. Simplify the process of deploying an application
Answer: A,C
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 # 65
Choose the two options provided in a Column Heading menu of an Interactive Report.
- A. Delete
- B. Group By
- C. Hide
- D. Control Break
Answer: C,D
Explanation:
Explanation
The Column Heading menu of an Interactive Report provides various options to customize the report based on the selected column. The options include:
Control Break: This option allows you to create a control break on the column, which groups the rows by the column values and inserts a header and a footer for each group. You can also apply aggregate functions, such as sum, count, or average, to the footer of each group.
Hide: This option allows you to hide the column from the report, which reduces the clutter and improves the readability of the report. You can also show the hidden columns by using the Columns option in the Actions menu.
The other options are incorrect because:
Group By: This option is not provided in the Column Heading menu of an Interactive Report. It is provided in the Actions menu of an Interactive Report. It allows you to group the rows by one or more columns and display the result in a chart or a pivot table.
Delete: This option is not provided in the Column Heading menu of an Interactive Report. It is provided in the Data option in the Actions menu of an Interactive Report. It allows you to delete one or more rows from the report and the underlying table.
Verified References: [Customizing Interactive Reports] [Column Heading Menu]
NEW QUESTION # 66
......
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.
Real 1Z0-770 Quesions Pass Certification Exams Easily: https://crucialexams.lead1pass.com/Oracle/1Z0-770-practice-exam-dumps.html