Best Preparations of 1z1-770 Exam 2023 Oracle Database Unlimited 144 Questions
Focus on 1z1-770 All-in-One Exam Guide For Quick Preparation.
Oracle 1Z0-770 exam is a certification exam designed for Oracle APEX (Application Express) developers who want to showcase their skills and knowledge in this field. Oracle APEX is a low-code web application development platform that allows developers to create scalable and secure applications with ease. The Oracle 1Z0-770 exam tests your ability to develop, implement, and maintain Oracle APEX applications.
Oracle 1Z0-770 exam is designed for professionals who want to become certified as an Oracle APEX Developer Professional. Oracle APEX Developer Professional certification is aimed at individuals who have experience in designing and developing applications with Oracle APEX. 1z1-770 exam measures the candidate's proficiency in configuring, developing, and deploying applications using Oracle APEX.
NEW QUESTION # 49
Let's say that there are two select lists on a page. Making a selection in the DEPARTMENT select list, determines which individuals display in the Employees select list. This type of LOV is called:
- A. Dynamic LOV
- B. Static LOV
- C. Popup LOV
- D. Cascading LOV
Answer: D
Explanation:
Explanation
A cascading LOV is a type of list of values (LOV) that depends on another parent LOV to determine its values. For example, if there are two select lists on a page, one for DEPARTMENT and one for EMPLOYEES, you can create a cascading LOV for EMPLOYEES that only shows the employees who belong to the selected department in the DEPARTMENT select list. To create a cascading LOV, you need to specify the parent item name and use bind variables in the SQL query for the child item.
NEW QUESTION # 50
There is a page with an interactive grid region based on this statement: SELECT EMPNO, ENAME, COMM from EMP; In the Interactive Grid attributes, under the Edit group, the Enabled switch is turned Off. Which are two of the actions that you must perform to make an employee's commission editable in the grid?
- A. Ensure that the "Primary Key" switch is turned "On" for the EMPNO column.
- B. Set EMPNO, ENAME to "Display Only".
- C. In the Interactive Grid attributes, select COMM for "Allowed Row Operations Column".
- D. In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group.
Answer: A,D
Explanation:
Explanation
An interactive grid is a customizable report that allows end users to modify the data and layout of the report.
To make an employee's commission editable in the grid, you need to perform two actions:
In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group. This enables editing for the entire interactive grid region and allows you to specify which columns are editable and which are not.
Ensure that the "Primary Key" switch is turned "On" for the EMPNO column. This identifies the EMPNO column as the primary key for the EMP table and allows APEX to perform DML operations on the table when end users edit the data in the grid. You do not need to set EMPNO or ENAME to
"Display Only" or select COMM for "Allowed Row Operations Column" to make an employee's commission editable in the grid. Verified References: [Managing Interactive Grids - Oracle Help Center], [Interactive Grid Attributes - Oracle Help Center]
NEW QUESTION # 51
Which two statements are true about the APEX MAIL API?
- A. The APEX_MAIL package supports sending emails only to Oracle database users.
- B. You can add files as attachments to your emails using the APEX_MAIL package.
- C. You can send emails using the APEX MAIL package from an Oracle APEX application.
- D. You can receive emails using the APEX_MAIL package in an Oracle APEX application
Answer: B,C
Explanation:
Explanation
The APEX_MAIL package is an API for the APEX mail system that enables developers to send emails from PL/SQL code. Some of the statements that are true about the APEX_MAIL package are:
You can add files as attachments to your emails using the APEX_MAIL package. You can use the APEX_MAIL.ADD_ATTACHMENT procedure to add one or more files as attachments to your emails.
The files can be in various formats, such as PDF, DOCX, XLSX, etc.
You can send emails using the APEX_MAIL package from an Oracle APEX application. You can use the APEX_MAIL.SEND procedure or function to send an outbound email message from your application. You can also specify various parameters for your email, such as sender, recipients, subject, body, priority, etc. The APEX_MAIL package does not support sending emails only to Oracle database users or receiving emails in an Oracle APEX application. You can send emails to any valid email address or use other tools or services to receive emails. Verified References: [APEX_MAIL - Oracle Help Center], [APEX_MAIL : Send Emails from PL/SQL - ORACLE-BASE]
NEW QUESTION # 52
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 modify the data in the report after running the app
- C. You can customize the pagination
- D. You can customize the Actions menu to include or exclude certain options.
Answer: B,C
NEW QUESTION # 53
Plug-ins can be used declaratively in which of the following components in APEX?
- A. Regions
- B. Items
- C. Process Type
- D. Dynamic Actions
- E. All of them
Answer: E
Explanation:
Explanation
Plug-ins can be used declaratively in all of the following components in APEX: Dynamic Actions, Regions, Items, Process Type, and Authentication and Authorization Schemes. Plug-ins are shared components that enable developers to extend the native functionality of APEX with custom components1. Plug-ins can be created or imported from the Shared Components page or the App Gallery1.
NEW QUESTION # 54
Choose the three types of aggregations you can apply on a column.
- A. Standard Deviation
- B. Sum
- C. Average
- D. Count
Answer: B,C,D
NEW QUESTION # 55
Which three of the following are use cases of Automations?
- A. Sending email alerts at a particular time of the week
- B. Deleting a database record based on an end user's request
- C. Approving specific requests
- D. Monitoring log tables and raising an alert when there is an issue
Answer: A,C,D
Explanation:
Explanation
Automations are a sequential set of PL/SQL actions that are triggered by query results. They are used to monitor data and then perform the appropriate action2. Some use cases of automations are:
Monitoring log tables and raising an alert when there is an issue. For example, an automation can query a log table for any errors and send an email notification to the administrator if any errors are found2.
Approving specific requests. For example, an automation can query a table for any pending requests and approve them automatically based on some criteria2.
Sending email alerts at a particular time of the week. For example, an automation can query a table for any overdue tasks and send a reminder email to the assignees every Monday2.
Deleting a database record based on an end user's request is not a use case of automations, as it does not involve querying data and triggering actions based on the query results. This can be achieved by using a PL/SQL process or a dynamic action on the page where the user requests the deletion34.
NEW QUESTION # 56
Which two feature pages can you create using the Create Page Wizard?
- A. Feedback
- B. Search Page
- C. Access Control
- D. Unified Task List
Answer: A,C
Explanation:
Explanation
The feature pages that can be created using the Create Page Wizard are About Page, Access Control, Activity Reporting, Configuration Options, Email Reporting, Feedback, Login Page, and Theme Style Selection. These pages provide application-level functionality that can be added to an existing application. Search Page and Unified Task List are not feature pages that can be created using the Create Page Wizard. Verified References: Managing Feature PagesFeature Page Types
NEW QUESTION # 57
When you click a Customer Name in the Customers report, the Customer Details form dialog page is displayed. What are the events that occur in this scenario?
- A. Page Rendering
- B. Page Processing
- C. Page compilation
- D. Page rendering and processing
Answer: D
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 # 58
Which two functions can be used by an end user when pivoting an interactive report?
- A. Median
- B. List aggregate
- C. Rank
- D. list aggregate
- E. Minimum
Answer: C,E
Explanation:
Explanation
When pivoting an interactive report, you can use different functions to aggregate or summarize the data in the pivot table. Some of the available functions are Minimum, Maximum, Average, Sum, Count, Median, and Rank. Minimum returns the smallest value in a set of values. Rank returns the rank of each value in a group of values. Verified References: 56
NEW QUESTION # 59
Which two statements are true about Maps in Oracle APEX?
- A. Maps don't support REST Data Sources
- B. Background maps do not require any API keys.
- C. Heat Map and Polygons are not supported Spatial geometry objects
- D. Maps support REST Enabled SQL
Answer: B,D
Explanation:
Explanation
A map is a type of component that enables you to view and manage data based on geographic locations. A map consists of a background map and spatial geometry objects that are sourced from data in a table or from a REST Data Source. Spatial geometry objects are shapes that represent real-world features on a map, such as points, lines, polygons, or heat maps. Two of the statements that are true about maps in Oracle APEX are:
Background maps do not require any API keys. This statement is true because Oracle APEX provides several background map options that do not require any API keys or registration to use. These options include OpenStreetMap, Stamen Maps, CartoDB Maps, and Esri Maps.
Maps support REST Enabled SQL. This statement is true because Oracle APEX allows you to use REST Enabled SQL as a data source for your map regions. REST Enabled SQL is a feature of Oracle REST Data Services (ORDS) that enables you to execute SQL statements and PL/SQL blocks over HTTPS using REST endpoints.
NEW QUESTION # 60
Which statement is true about the Link Column attribute of an interactive report?
- A. If you select Link Column, it is always displayed as the last column in the report.
- B. A Link Column cannot be sorted, hidden, or moved by an end user.
- C. It is not possible to exclude Link Column.
- D. It is not possible to include a custom target in Link Column
Answer: B
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 # 61
Choose the three different ways in which you can add a checkbox to a page.
- A. Drag and drop the checkbox item into the Layout pane
- B. Add a checkbox from the Property Editor
- C. Use the context sensitive menu in the Gallery pane.
- D. Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type.
Answer: A,C,D
Explanation:
Explanation
There are three different ways in which you can add a checkbox to a page in APEX:
Drag and drop the checkbox item into the Layout pane: In Page Designer, you can drag and drop items from the Gallery pane into the Layout pane to create them on your page. To create a checkbox item, expand the Items node in the Gallery pane and drag and drop Checkbox into the Layout pane.
Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type: In Page Designer, you can right click any node in the Rendering tree andselect Create to create a new component under that node. To create a checkbox item under the Body node, right click Body and select Create > New Page Item > Checkbox.
Use the context sensitive menu in the Gallery pane: In Page Designer, you can use the context sensitive menu in the Gallery pane to create items on your page. To create a checkbox item using this method, expand the Items node in the Gallery pane and right click Checkbox. Then select Create Checkbox.
NEW QUESTION # 62
Select the three types of Card Layout you can create in APEX.
- A. Float
- B. Horizontal(Row)
- C. Vertical(Column)
- D. Grid
Answer: A,B,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 # 63
What three components must be considered whilemigrating an APEX app betweenenvironments?
- A. Move the sessions data
- B. Move the application definition and all associated files
- C. Move the images
- D. Move the database objects
Answer: B,C,D
Explanation:
Explanation
To migrate an APEX app between environments, such as from development to production, you need to consider three components that make up an APEX app:
Database objects: These are the tables, views, procedures, functions, packages, triggers, sequences, synonyms, and other schema objects that store or manipulate the data used by the app. You need to move these objects from the source schema to the target schema using tools such as SQL Developer, Data Pump Export/Import, or Data Workshop.
Images: These are the static files, such as images, CSS files, JavaScript files, or PDF files, that are used by the app for display or download purposes. You need to move these files from the source web server to the target web server using tools such as FTP, SCP, or File Explorer.
Application definition and all associated files: These are the metadata files that define the app components, such as pages, regions, items, buttons, processes, validations, computations, dynamic actions, shared components, and so on. You also need to include any supporting object definitions or data scripts that are used to create or populate database objects for the app. You need to move these files from the source APEX instance to the target APEX instance using tools such as App Builder Export/Import or One-click Remote Application Deployment.
NEW QUESTION # 64
Examine this code entered in Quick SQL:
emp_salary
name vc255
salary num
commission yn/check TRUE, FALSE
Which statement is true about the commission yn column?
- A. It will default to FALSE.
- B. It will restrict acceptable values to Y or N.
- C. It will restrict acceptable values to TRUE or FALSE.
- D. It will default to TRUE.
Answer: C
Explanation:
Explanation
The commission yn column will restrict acceptable values to TRUE or FALSE because of the /check modifier in the column name. This modifier adds a check constraint to the column based on the values specified after it.
The yn suffix indicates that the column is of type VARCHAR2(1). The other options are incorrect because they do not reflect the effect of the /check modifier or the yn suffix. Verified References: Using Quick SQLAbout Quick SQL Shorthand Syntax
NEW QUESTION # 65
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. You can create multiple charts at a time in an interactive grid
- C. Once the chart is created, it cannot be reconfigured.
- D. To remove a chart, click the Remove Chart icon (X) adjacent to the chart filter
Answer: A,D
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 # 66
The APEX engine uses which component as a key for tracking each user's session state?
- A. HTTP_USER
- B. APEX_USER
- C. LDAP_USER
- D. APP_USER
Answer: D
Explanation:
Explanation
APP_USER is a built-in substitution string in Oracle APEX that stores the user name of the current user session. The APEX engine uses APP_USER as one component of a key for tracking each user's session state.
As a user navigates from page to page, the APEX engine sets the value of APP_USER to identify the user. The APEX engine also uses APP_USER to perform security checks and conditional processing. You can reference APP_USER using different syntax depending on the context, such as SQL, PL/SQL, or static text.
NEW QUESTION # 67
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 Validation
- D. Page Processing
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 # 68
Using Data Workshop, you can perform which three tasks:
- A. Delete data from the database
- B. Load vast amount of data into the database
- C. Load data using various file formats such as XLSX, CSV, XML, and JSON
- D. Export vast amount of data from the database into a file
Answer: B,C,D
Explanation:
Explanation
Using Data Workshop, you can perform the following tasks:
Load vast amount of data into the database: You can use the Data Load option to load data from various file formats such as XLSX, CSV, XML, and JSON into a table or a collection in your database. You can also use the Data Load Wizard to guide you through the steps of loading data.
Export vast amount of data from the database into a file: You can use the Data Unload option to export data from a table or a collection in your database into a file in CSV or JSON format. You can also use the Data Unload Wizard to guide you through the steps of exporting data.
Load data using various file formats such as XLSX, CSV, XML, and JSON: You can use the Data Load option to load data from different file formats into your database. You can choose the file format from a list of supported formats or let Oracle APEX detect it automatically.
The other option is incorrect because:
Delete data from the database: You cannot use Data Workshop to delete data from the database. You can use SQL Commands or SQL Scripts in SQL Workshop to run DELETE statements to delete data from the database.
Verified References: [About Data Workshop] [Loading Data] [Unloading Data]
NEW QUESTION # 69
In your APEX application, you want to have an orderly grid layout of information tiles. Which page type should you choose in the Create Page Wizard?
- A. Cards
- B. Interactive Grid
- C. Master Detail
- D. Unified Task List
Answer: A
Explanation:
Explanation
Cards are a page type that display information in a grid layout of tiles. Each card can contain an image, a title, a subtitle, and an optional link. Cards are suitable for presenting summary or overview information in an attractive and compact way1 Verified References: 1: Understanding Page Types, Features, and Settings - Oracle Help Center
NEW QUESTION # 70
Which two layout options are available for Page Designer under Utilities?
- A. Single Pane Mode
- B. Three Pane Mode
- C. Two Pane Mode
- D. Four Pane Mode
Answer: A,C
Explanation:
Explanation
Page Designer is a tool that allows developers to create and edit pages in Oracle APEX using a graphical user interface. Page Designer has three main panes: Rendering, Processing, and Property Editor. You can change the layout of Page Designer under Utilities by selecting one of the following options:
Single Pane Mode - This option displays only one pane at a time. You can switch between the Rendering, Processing, and Property Editor panes by using the buttons on the toolbar or the keyboard shortcuts.
Two Pane Mode - This option displays two panes side by side. You can choose which panes to display by using the buttons on the toolbar or the keyboard shortcuts. You can also resize the panes by dragging the splitter bar between them. There is no Three Pane Mode or Four Pane Mode option for Page Designer layout. Verified References: [Managing Pages in Page Designer - Oracle Help Center], [Page Designer Layout Options - Oracle Help Center]
NEW QUESTION # 71
......
To take the Oracle 1Z0-770 exam, candidates must have a strong understanding of SQL, PL/SQL, HTML, CSS, and JavaScript. They must also have experience working with Oracle databases and be able to design, develop, and deploy applications using Oracle APEX. 1z1-770 exam consists of 60 multiple-choice questions and has a time limit of 105 minutes. A passing score of 63% or higher is required to earn the certification.
Guaranteed Success with 1z1-770 Dumps: https://lead2pass.examdumpsvce.com/1z1-770-valid-exam-dumps.html
