[Jan 26, 2024] 1Z0-770 Exam Dumps - 100% Marks In 1Z0-770 Exam!
Exam Dumps Use Real Oracle Database Dumps With 144 Questions!
NEW QUESTION # 61
Which three of the following options are TRUE about a page in an APEX application?
- A. An APEX application can have only one page.
- B. A page can be viewed and edited in the Page Designer.
- C. To view the rendered version of the page, you run or submit it to the Oracle APEX engine.
- D. A page can contain buttons, page items and regions.
Answer: B,C,D
NEW QUESTION # 62
When a table or a SQL query returns many rows, an Interactive Grid is best displayed to the user with pagination. The two types of pagination available are:
- A. Page and Scroll
- B. No Pagination
- C. Page
- D. Scroll
Answer: A
Explanation:
Explanation
When a table or a SQL query returns many rows, an interactive grid is best displayed to the user with pagination. Pagination enables users to navigate through large data sets by displaying a subset of data at a time3. The two types of pagination available for interactive grids are Page and Scroll3. Page pagination displays a fixed number of rows per page and provides controls to navigate between pages. Scroll pagination displays rows as the user scrolls down the grid and fetches more data as needed
NEW QUESTION # 63
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. Set EMPNO, ENAME to "Display Only".
- B. Ensure that the "Primary Key" switch is turned "On" for the EMPNO column.
- 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: B,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 # 64
Choose the three types of page items that can be placed on a page.
- A. Select List
- B. Global variable
- C. Checkbox
- D. Date Picker
Answer: A,C,D
Explanation:
Explanation
A page item is a component that is part of an HTML form and can accept user input or display output. There are many types of page items that can be placed on a page in APEX, such as text fields, text areas, radio groups, checkboxes, date pickers, select lists, popup LOVs, shuttles, and so on. Each type of page item has different properties and attributes that affect its appearance and functionality. Three of the types of page items that can be placed on a page are:
Checkbox: A checkbox is a page item that displays one or more options that can be selected or deselected by the user. A checkbox can have either static values or dynamic values based on a list of values (LOV). A checkbox can also have different display styles, such as pill button or switch.
Date Picker: A date picker is a page item that displays a text field with an icon that opens a calendar popup when clicked. A date picker allows users to enter or select a date value in a specific format. A date picker can also have different attributes, such as minimum or maximum date, display format, or time picker.
Select List: A select list is a page item that displays a drop-down list of options that can be selected by the user. A select list can have either static values or dynamic values based on a list of values (LOV). A select list can also have different attributes, such as multiple selection, null value display text, or cascading LOV.
NEW QUESTION # 65
Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?
- A. Install Oracle APEX in the remote Oracle Database.
- B. Create a database link to the remote Oracle Database in the local APEX Schema.
- C. On the remote Oracle Database, install ORDS 19.x or later.
- D. REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
Answer: C,D
Explanation:
Explanation
The REST-enabled SQL feature in Oracle APEX allows developers to execute SQL statements and PL/SQL blocks on a remote Oracle Database by using REST services. The prerequisites to use this feature are:
On the remote Oracle Database, install ORDS 19.x or later.
REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
Create a REST Data Source with REST Enabled SQL as the REST Data Source Type in Oracle APEX.
Create an Authorization Scheme based on the REST Data Source in Oracle APEX. You do not need to create a database link to the remote Oracle Database or install Oracle APEX in the remote Oracle Database to use this feature. Verified References: [Using REST Enabled SQL - Oracle Help Center],
[REST Enabled SQL Service - Oracle Help Center]
NEW QUESTION # 66
Which two statements are true about the APEX MAIL API?
- A. You can receive emails using the APEX_MAIL package in an Oracle APEX application
- B. The APEX_MAIL package supports sending emails only to Oracle database users.
- C. You can add files as attachments to your emails using the APEX_MAIL package.
- D. You can send emails using the APEX MAIL package from an Oracle APEX application.
Answer: C,D
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 # 67
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 # 68
Which two among the following are TRUE about Low Code Apps?
- A. Provide Rich Functionality with Less Code
- B. Not Mobile Friendly
- C. Scalable
- D. Expensive
Answer: A,C
Explanation:
Explanation
Low Code Apps are applications that are developed using a low-code development platform such as Oracle APEX. Low Code Apps have the following characteristics:
Scalable: Low Code Apps can handle large volumes of data and users without compromising performance or reliability. They can also leverage the scalability features of the underlying database or cloud platform.
Provide Rich Functionality with Less Code: Low Code Apps can provide complex business logic, user interface, security, and integration features with minimal or no coding. They use declarative tools, visual editors, drag-and-drop components, and pre-built templates to speed up the development process.
The other options are incorrect because:
Not Mobile Friendly: Low Code Apps are mobile friendly by default. They use responsive design techniques to adapt to different screen sizes and orientations. They also support touch gestures, device features, and offline capabilities.
Expensive: Low Code Apps are not expensive to develop or maintain. They reduce the cost of development by requiring less time, resources, and skills. They also reduce the cost of maintenance by simplifying the deployment, testing, and debugging processes.
Verified References: [What is Low Code?] [Why Choose Oracle APEX?]
NEW QUESTION # 69
What three components must be considered whilemigrating an APEX app betweenenvironments?
- A. Move the database objects
- B. Move the images
- C. Move the sessions data
- D. Move the application definition and all associated files
Answer: A,B,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 # 70
Choose the three correct options in the given friendly URL syntax:
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?
- A. update-employees is the PL/SQL procedure to update the employee details.
- B. mycompany is the path-prefix which is by default the workspace name
- C. session=13766599855150 Ahr-app is the application alias.
- D. 13766599855150 is the session ID. A new ID is generated for each session.
Answer: B,C,D
Explanation:
Explanation
The friendly URL syntax
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?session=13766599855150 has the following components:
session=13766599855150 is the session ID. A new ID is generated for each session. This parameter identifies which session is associated with the request.
hr-app is the application alias. This parameter identifies which application is being requested. An application alias is a user-friendly name that can be used instead of an application ID.
mycompany is the path-prefix which is by default the workspace name. This parameter identifies which workspace is being requested. A path-prefix is a URL segment that can be used instead of a workspace ID.
updateemployees is the page alias. This parameter identifies which page is being requested. A page alias is a user-friendly name that can be used instead of a page number.
The other option is incorrect because:
update-employees is not the PL/SQL procedure to update the employee details. It is the page alias that identifies which page is being requested.
Verified References: [About Friendly URLs] [Understanding URL Syntax]
NEW QUESTION # 71
Which two of the following types can an end user save the customized Interactive report as?
- A. Cannot save the report
- B. Default report
- C. A Public report
- D. A private report
Answer: C,D
NEW QUESTION # 72
The APEX engine uses which component as a key for tracking each user's session state?
- A. APEX_USER
- B. LDAP_USER
- C. APP_USER
- D. HTTP_USER
Answer: C
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 # 73
Choose the statement that is TRUE about Universal Theme.
- A. Uses a 12-column grid layout system for arranging components on a page.Ships with a variety of pre-built theme styles
- B. All of them
- C. Features a responsive design and enables developers to create web applications without extensive knowledge of HTML, CSS, or JavaScript
- D. Universal theme is the default theme that is shipped with Oracle APEX
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 # 74
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 compilation
- B. Page Rendering
- C. Page Processing
- 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 # 75
Developers can use Template Options in which of the following ways?
- A. Applying different spacing and padding
- B. Displaying form fields with different alignments
- C. All of them
- D. Applying different colors or accents
- E. Rendering buttons in different styles, with and without icons
Answer: C
Explanation:
Explanation
Template options provide developers with a declarative approach to applying different styles to components on an Oracle APEX page. Developers can use template options to declaratively apply CSS modifiers to the templates they have chosen for pages, regions, reports, lists, breadcrumbs, items and buttons. Developers can use template options in all of the following ways:
Applying different colors or accents. Developers can use template options to change the color scheme or accent color of components, such as buttons, lists, or regions.
Rendering buttons in different styles, with and without icons. Developers can use template options to change the shape, size, style, and icon of buttons on a page.
Applying different spacing and padding. Developers can use template options to adjust the spacing and padding of components, such as regions, items, or reports.
Displaying form fields with different alignments. Developers can use template options to change the alignment of form fields and labels, such as left-aligned, right-aligned, or top-aligned.
NEW QUESTION # 76
To highlight certain rows in the interactive report based on a condition, you must:
- A. Rows cannot be highlighted in an Interactive report
- B. Provide a conditional SQL query
- 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 # 77
Which statement is true about using SQL Commands?
- A. You can design and prototype data models using a markdown-like shorthand syntax.
- B. In SQL Commands, you can view queries saved in Query Builder.
- C. You can search and filter database objects.
- D. You can unload data from the database.
Answer: D
Explanation:
Explanation
Commands allow you to execute SQL statements or PL/SQL blocks to create, edit, view, run, and delete database objects. One of the features of SQL Commands is the ability to unload data from the database to a CSV file. You can do this by clicking the Download button after running a query that returns data. Verified References: 34
NEW QUESTION # 78
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. Static LOV
- B. Cascading LOV
- C. Dynamic LOV
- D. Popup LOV
Answer: B
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 # 79
......
Oracle 1Z0-770 certification exam is intended for individuals who have experience using APEX and are looking to validate their skills and knowledge. Passing 1Z0-770 exam demonstrates that the individual has a strong understanding of APEX architecture, security, data modeling, and user interface design, among other concepts.
Pass Your 1Z0-770 Exam Easily With 100% Exam Passing Guarantee: https://www.exams-boost.com/1Z0-770-valid-materials.html
1Z0-770 Dumps are Available for Instant Access: https://drive.google.com/open?id=1m6nrPpS3kCQ-56ODsxoTGy4MmZZE2sns