Give You Free Regular Updates on 1z1-770 Exam Questions Mar 25, 2024
Achieve the 1z1-770 Exam Best Results with Help from Oracle Certified Experts
NEW QUESTION # 40
Choose the three Form types that you can create using the Create Page wizard.
- A. Interactive Grid
- B. Form
- C. Interactive Report
- D. Master Detail
Answer: A,B,D
Explanation:
Explanation
The Create Page wizard supports three form types that you can create: Interactive Grid, Form, and Master Detail4. An interactive grid is a report that allows users to view and edit data in a tabular format. A form is a page that enables users to update a single row in a database table or view. A master detail is a page that reflects a one-to-many relationship between two tables or views4. An interactive report is not a form type, but a report type that allows users to customize the report layout and filter data interactively5.
NEW QUESTION # 41
In an Employee form, the 'Commission' and 'Hire Date' fields are enabled only if the Job is
'Salesman'. This can be achieved by which feature of APEX?
- A. Conditional SQL
- B. PL/SQL procedure
- C. Processing
- D. Dynamic Actions
Answer: D
Explanation:
Explanation
In an Employee form, the 'Commission' and 'Hire Date' fields are enabled only if the Job is 'Salesman'. This can be achieved by using Dynamic Actions in APEX. Dynamic Actions are declarative components that define client-side behavior without writing JavaScript code. You can create Dynamic Actions on items, buttons, or regions of a page by specifying an event, a condition, an action, and other properties. In this scenario, you can create a Dynamic Action on Job item with Change as event, Execute JavaScript Code as action, and use jQuery to enable or disable Commission and Hire Date fields based on Job value. Processing, Conditional SQL, and PL/SQL procedure are not features of APEX that can achieve this requirement without writing JavaScript code.
NEW QUESTION # 42
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. Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type.
- D. Use the context sensitive menu in the Gallery pane.
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 # 43
Which three of the following are use cases of Automations?
- A. Monitoring log tables and raising an alert when there is an issue
- B. Sending email alerts at a particular time of the week
- C. Deleting a database record based on an end user's request
- D. Approving specific requests
Answer: A,B,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 # 44
Which of the following are preconfigured authentication schemes?
- A. HTTP Header Variables
- B. Open Door Credentials
- C. All of them
- D. LDAP Directory
- E. Social Sign In
Answer: C
Explanation:
Explanation
Oracle APEX provides several preconfigured authentication schemes that follow a standard behavior for authentication and session management. You can select a preconfigured authentication scheme from the gallery when you create an authentication scheme for your application. The preconfigured authentication schemes are:
Open Door Credentials: This scheme enables anyone to access your application using a built-in login page that captures a user name.
LDAP Directory: This scheme authenticates a user and password with an authentication request to a LDAP server.
HTTP Header Variable: This scheme authenticates users externally by storing the username in a HTTP Header variable set by the web server.
Social Sign-In: This scheme supports authentication with Google, Facebook, and other social networks that support OpenID Connector OAuth2 standards.
Oracle APEX Accounts: This scheme authenticates users against Oracle APEX user accounts that are created within and managed in the APEX user repository.
Custom Authentication: This scheme allows you to create a custom authentication scheme from scratch to have complete control over your authentication interface.
Database Accounts: This scheme authenticates users using database schema accounts.
Oracle Application Server Single Sign-On Server: This scheme delegates authentication to the Oracle AS Single Sign-On (SSO) Server.
SAML Sign-In: This scheme delegates authentication to the Security Assertion Markup Language (SAML) Sign In authentication scheme.
NEW QUESTION # 45
The APEX engine uses which component as a key for tracking each user's session state?
- A. HTTP_USER
- B. APP_USER
- C. APEX_USER
- D. LDAP_USER
Answer: B
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 # 46
Which three statements are TRUE about Shared Components?
- A. Once you create a Shared Component, you can add them to any page within an APEX application in any workspace.
- B. Shared components are common elements that can be displayed or applied on any page within an application
- C. Once you create a Shared Component, you can add them to any page within your APEX application
- D. Breadcrumbs, Lists, and Navigation Bar entries are examples of shared components
Answer: B,C,D
Explanation:
Explanation
Shared components are common elements that can be displayed or applied on any page within an application.
Once you create a shared component, you can add them to any page within your APEX application. However, shared components are specific to each application and workspace, so you cannot add them to any page in any workspace4. Breadcrumbs, lists, and navigation bar entries are examples of shared components that can be used for navigation purposes4.
NEW QUESTION # 47
Which two statements are true about the APEX MAIL API?
- A. You can send emails using the APEX MAIL package from an Oracle APEX application.
- B. You can add files as attachments to your emails using the APEX_MAIL package.
- C. You can receive emails using the APEX_MAIL package in an Oracle APEX application
- D. The APEX_MAIL package supports sending emails only to Oracle database users.
Answer: A,B
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 # 48
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. REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
- D. On the remote Oracle Database, install ORDS 19.x or later.
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 # 49
When you create an Access Control Page, which three of the following Access Roles get created?
- A. Reader
- B. Administrator
- C. Contributor
- D. Developer
Answer: A,B,C
Explanation:
Explanation
When you create an Access Control Page using the Create Page Wizard, three of the following Access Roles get created: Reader, Administrator, and Contributor. These roles are predefined by APEX and correspond to the authorization schemes that control the access to the application, pages, or page components1. Reader role grants read-only access to the application. Administrator role grants full access to the application, including administrative and edit privileges. Contributor role grants edit privileges to the application, but not administrative privileges2. Developer role is not a default Access Role created by the wizard, but you can create your own custom roles and assign them to users on the Application Access Control page.
NEW QUESTION # 50
While migrating apps, once the database objects are created in the target environment, you canload the data using which of the components?
- A. App Builder
- B. Data Generator
- C. Quick SQL
- D. Data Workshop
Answer: D
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 # 51
Which client credentials are utilized for authentication during the One-Click Remote ApplicationDeployment process?
- A. PEX Developer credentials
- B. APEX Workspace Admin credentials
- C. Database schema credentials
Answer: B
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 # 52
Choose the two options provided in a Column Heading menu of an Interactive Report.
- A. Delete
- B. Hide
- C. Group By
- D. Control Break
Answer: B,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 # 53
Which is NOT a valid Geometry Column Data Type available for maps region?
- A. Latitude/Longitude
- B. SDO_GEOMETRY
- C. GeoJSON
- D. JSON_OBJECT
Answer: D
Explanation:
Explanation
The valid Geometry Column Data Types for maps region are Latitude/Longitude, GeoJSON, and SDO_GEOMETRY. These types represent different ways of storing spatial data in Oracle Database.
Latitude/Longitude uses two numeric columns for longitude and latitude values. GeoJSON uses a VARCHAR2 or CLOB column that contains geometry information in GeoJSON format. SDO_GEOMETRY uses an object type that stores spatial data using Oracle Spatial features. JSON_OBJECT is not a valid Geometry Column Data Type for maps region. Verified References: About Supported MapsEditing Maps
NEW QUESTION # 54
Which statement is true about creating and using a faceted search page?
- A. If you create a faceted search page on a view or a SQL query, the facets are auto-discovered.
- B. If you create a faceted search page based on a table, the facets are not auto-discovered.
- C. The Search Results region can be displayed as a Classic Report or Cards.
- D. The Search Results region can be displayed as an interactive report.
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. You can create a faceted search page by using the Create Page Wizard or by adding a faceted search region to an existing page. If you create a faceted search page based on a table, view, or SQL query, the facets are auto-discovered by analyzing the data source. The Search Results region can be displayed as a Classic Report or Cards, but not as an interactive report. You can also customize the appearance and behavior of the facets and the search results by using various attributes.
Verified References: [Creating Faceted Search Pages - Oracle Help Center], [Faceted Search Attributes - Oracle Help Center]
NEW QUESTION # 55
Which two Plugin types can be created in Oracle APEX?
- A. Email Template
- B. Region
- C. Validation
- D. Process
Answer: B,D
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 # 56
Which two statements are true about the generated SQL?
- A. Creates DEPARTMENTS table with 2 columns
- B. Creates EMPLOYEES table with 4 columns
- C. Inserts 10 rows of random sample data into the DEPARTMENTS table
- D. Both DEPARTMENTS and EMPLOYEES tables will have a primary key in each and a foreign key relationship linking EMPLOYEES to DEPARTMENTS.
Answer: A,B
Explanation:
Explanation
The generated SQL script creates two tables: DEPARTMENTS and EMPLOYEES, with the specified columns and data types. It does not insert any data into the tables, nor does it create any primary or foreign keys. The script only creates the tables and their columns. References: Creating a Desktop Database Application and Using SQL Workshop
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 Processing
- B. Page compilation
- C. Page Rendering
- 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
In your application, you want to include a master aetall containing two pages based on two related tables or views. The first page contains an interactive report for the master table. The second page features a standard form for the master and interactive grids for the detail. Which master detail form will you create?
- A. Editable Interactive Grid
- B. Stacked Master Detail
- C. Side by Side Master Detail
- D. Drill down Master Detail
Answer: D
Explanation:
Explanation
A drill down master detail form allows you to create a master detail form that contains two pages based on two related tables or views. The first page contains an interactive report for the master table. The second page features a standard form for the master and interactive grids for the detail. You can use the Create Page wizard to create a drill down master detail form. References: Creating Master Detail Forms and [Creating a Drill Down Master Detail Form]
NEW QUESTION # 59
Which two statements are true about the usage of a Remote Server in the context of REST Data Sources?
- A. The remote server determines the base URL of the REST Data Source.
- B. A single REST Data Source can use multiple remote servers.
- C. Multiple REST Data Sources can reference a single remote server.
- D. The remote server should mandatorily be an APEX instance.
Answer: A,C
Explanation:
Explanation
A remote server in the context of REST Data Sources is a configuration that defines how to connect to an external server that hosts one or more REST services. The remote server determines the base URL of the REST Data Source, which is used to construct the full URL of each REST operation. Multiple REST Data Sources can reference a single remote server, which simplifies the maintenance and security of accessing external REST services. Verified References: Managing Remote Servers - Oracle Help Center, Creating REST Data Sources - Oracle Help Center
NEW QUESTION # 60
When you create a Dynamic Action, you specify the event that causes the dynamic action to fire.
Choose the categories these events are classified into.
- A. Framework Events
- B. Component Events
- C. All of them
- D. Custom Events
- E. Browser Events
Answer: C
Explanation:
Explanation
The events that cause the dynamic action to fire are classified into five categories: Browser Events, Component Events, Custom Events, Framework Events, and jQuery Events1. Browser events are triggered by user interactions with the browser window, such as resize, scroll, or unload. Component events are triggered by user interactions with specific APEX components, such as interactive grids, interactive reports, or trees.
Custom events are user-defined events that can be triggered by other dynamic actions or JavaScript code.
Framework events are triggered by APEX framework actions, such as page load, page submit, or dialog close. jQuery events are triggered by user interactions with jQuery UI widgets, such as accordion, tabs, or date picker1.
NEW QUESTION # 61
Choose the two correct statements about PWA.
- A. Provides a customizable offline page when users areoffline and cannot request thenetwork.
- B. To download the app as PWA, one must visit the App Store
- C. An existing APEX app cannot be made a PWA
- D. Enables users to install the application on devices
Answer: A,D
NEW QUESTION # 62
Which three are the main components of APEX workspace homepage?
- A. App Builder
- B. Gallery
- C. RESTful Services
- D. SQL Workshop
Answer: A,B,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 # 63
......
Detailed New 1z1-770 Exam Questions for Concept Clearance: https://braindumps.actual4exams.com/1z1-770-real-braindumps.html