Buy Latest Aug 12, 2024 1z1-770 Exam Q&A PDF – One Year Free Update [Q19-Q35]

August 12, 2024 admin 0

Categories : 1z1-770 , Oracle

Rate this post

Buy Latest Aug 12, 2024 1z1-770 Exam Q&A PDF – One Year Free Update

Download the Latest 1z1-770 Dump – 2024 1z1-770 Exam Questions

Oracle 1Z0-770 Exam is a professional-level certification program that focuses on the development of Oracle Application Express (APEX) applications. Oracle APEX Developer Professional certification is designed for individuals who want to showcase their advanced skills and knowledge in developing APEX applications. It tests the candidate’s ability to work with complex APEX components and integrate them with other Oracle technologies.

NEW QUESTION 19
What are Task definitions that exist on the application level inthe Shared Components section made up of?

Particpants

All of them

Task Settings

Parameters

Actions

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 20
In a faceted search page, facets can be displayed as different UI types. Which two facet item types are supported in the faceted search region?

Date Picker

Range

Checkbox Group

Popup LOV

Explanation
In a faceted search page, facets can be displayed as different UI types depending on the data type and cardinality of the facet column or expression. The facet item types are the UI components that are used to render the facets in the faceted search region. The supported facet item types are Range, Checkbox Group, Radio Group, List, Star Rating, and Switch. Date Picker and Popup LOV are not valid facet item types.
Verified References: [Faceted Search Attributes – Oracle Help Center], [Facet Item Types – Oracle APEX]

NEW QUESTION 21
Plug-ins can be used declaratively in which of the following components in APEX?

Dynamic Actions

Regions

Items

Process Type

All of them

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 22
Examine this code used in Quick SQL:
students
name
roll no num
Quick SQL is using default settings.
Which table creation script or other output is produced?

An Invalid column definition error message will be displayed.

create table students (
id number generated by default on null as identity constraint students id pk primary key, name varchar2 (255 char) not null, roll no number )
;

create table students (
id number generated by default on null as identity constraint students_id_pk primary key, name varchar2 (255 char), roll_no number )
;

Explanation
The table creation script produced by Quick SQL is:
create table emp_salary ( id number generated by default on null as identity constraint emp_salary_id_pk primary key, name varchar2 (255 char) not null, salary number, commission_yn varchar2 (1 char) check (commission_yn in (‘Y’,’N’)) default ‘N’ not null ); The commission_yn column will default to ‘N’ because of the default clause in the column definition. It will also restrict acceptable values to ‘Y’ or ‘N’ because of the check constraint. The other options are incorrect because they do not match the output of Quick SQL. Verified References: Using Quick SQLAbout Quick SQL Shorthand Syntax

NEW QUESTION 23
Choose the three types of aggregations you can apply on a column.

Average

Standard Deviation

Sum

Count

NEW QUESTION 24
You created a custom theme for an application. Examine these requirements: 1. The theme must be utilized by another application in the same workspace. 2. The master theme may still require changes. Which solution guarantees that any changes to the master theme are reflected in the copied theme?

Refreshing the templates

Verifying the theme subscription

Subscribing the copied theme to the master theme and refreshing the theme

Copying the changes made in the master theme to the copied theme

Explanation
A theme is a collection of templates and stylesheets that define the layout and appearance of an application.
You can create a custom theme for an application by using the Create Theme Wizard or by copying an existing theme. If you want to use a custom theme for anotherapplication in the same workspace, you can copy the theme to that application by using the Copy Theme option in Shared Components. However, if the master theme (the original theme) may still require changes, you need to subscribe the copied theme to the master theme and refresh the theme whenever there are changes in the master theme. This solution guarantees that any changes to the master theme are reflected in the copied theme by using a synchronization process that updates templates and stylesheets based on their subscription status. Verified References: [Creating Themes – Oracle Help Center], [Managing Theme Subscriptions – Oracle Help Center]

NEW QUESTION 25
Which three of the following statements are TRUE about saved Public Interactive Grids?

Public reports are available to all users

To enable an end user to save a public interactive grid, the user must have the required permission

Any user may save public interactive grids

Only the user who creates a public interactive grid can save, rename, or delete it

Explanation
Public reports are available to all users who can access the interactive grid1. However, to enable an end user to save a public interactive grid report, the user must have the required permission. By default, only developers can save public reports1. Any user may save private interactive grid reports, but only the user who creates a private report can view, save, rename, or delete it12. Verified References: 12

NEW QUESTION 26
Select the three ways in which you can create a Form in APEX.

Using the Create Page wizard

Using Shared Components

Create a Form region in Page Designer

Using the Create Application Wizard

Explanation
A form is a type of component that is part of an HTML form and can accept user input or display output.
There are many types of forms that can be created in APEX, such as forms on tables, forms on procedures, forms on web sources, and so on. Each type of form has different properties and attributes that affect its appearance and functionality. Three of the ways in which you can create a form in APEX are:
Using the Create Page wizard: This method allows you to create a new page with a form component using a guided wizard. You can choose from different types of forms, such as report with form, editable interactive grid, single page master detail, two page master detail, form on table, form on procedure, and so on. You can also specify various options for your form, such as data source, display style, validations, processes, and branches.
Create a Form region in Page Designer: This method allows you to create a complex form region that includes multiple form items and processes on an existing page. You can use the Create Form Region wizard in Page Designer to create a form region based on a table, view, procedure, web source module, or SQL query. You can also customize your form region by adding or modifying items, buttons, validations, computations, processes, and dynamic actions.
Using the Create Application Wizard: This method allows you to create a new application that contains one or more forms using a guided wizard. You can choose from different types of applications, such as database application, web source application, blueprint application, or from scratch application. You can also specify various options for your application and forms, such as name, icon, theme style, features, data source, navigation menu entry, and so on.

NEW QUESTION 27
You can create a report in which of the three following methods?

Create a report as a new page in an application

Create a report when you create a new database application

Create a report from Object Browser

Create a report region on a page in an application

Explanation
You can create a report in any of these three methods:
Create a report as a new page in an application by using the Create Page Wizard. This wizard guides you through the steps of selecting a page type, defining attributes, selecting a source (such as SQL query or table), and adding items or buttons.
Create a report when you create a new database application by using the Create Application Wizard.
This wizard allows you to generate one or more reports based on existing tables or views in your schema. You can also create a report and form on the same table or view.
Create a report region on a page in an application by using the Page Designer. This tool allows you to drag and drop a region type (such as Classic Report, Interactive Report, or Interactive Grid) onto the page and define its attributes and source.
The other option is incorrect because:
You cannot create a report from Object Browser. Object Browser is a tool that allows you to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can only run SQL queries or scripts from this tool, not create reports.
Verified References: [Creating Database Applications] [Creating Pages] [Creating Regions] [Using Object Browser]

NEW QUESTION 28
Which two actions can you perform using the Object Browser?

Browse database objects of the current schema.

Restore dropped database objects.

Create and run SQL scripts.

Create a lookup table based on a column in the current table.

Export and import SQL scripts.

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 29
In APEX, you can choose which three of the following Authentication methods?

Custom Authentication Scheme

No Authentication

Built-in Authentication Scheme

Authorization Scheme

Explanation
In Oracle APEX, you can choose from different authentication methods to establish a user’s identity and control access to your application. Authentication may require a user to provide some type of credentials, such as a user name and password, or could involve the use of digital certificates or a secure key. Three of the authentication methods that you can choose in Oracle APEX are:
Custom Authentication Scheme: This method allows you to create your own authentication logic using PL/SQL code or an external web service. You can also customize the login page and session management for your application.
No Authentication (using DAD): This method adopts the current database user as the authenticated user.
This approach can be used in combination with a mod_plsql Database Access Descriptor (DAD) configuration that uses basic authentication to set the database session user.
Built-in Authentication Scheme: This method allows you to use one of the preconfigured authentication schemes that ship with Oracle APEX, such as Open Door Credentials, LDAP Directory, Social Sign-In, and so on.

NEW QUESTION 30
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?

It will default to FALSE.

It will restrict acceptable values to TRUE or FALSE.

It will default to TRUE.

It will restrict acceptable values to Y or N.

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 31
Which two are true when the Edit option is NOT enabled for an Interactive Grid?

The end user cannot edit the underlying data in the database

The end user can edit the underlying data in the database

The end user can customize the report

The end user cannot create charts

Explanation
An interactive grid is a component that displays data in a tabular format and allows users to perform various actions on the data, such as sorting, filtering, grouping, highlighting, and editing. However, the editing feature is optional and can be enabled or disabled by the developer. When the Edit option is not enabled for an interactive grid, the following statements are true:
The end user cannot edit the underlying data in the database. The interactive grid becomes read-only and does not allow users to add, modify, or delete rows. The Add Row and Save buttons are hidden from the toolbar and the cells are not editable.
The end user can customize the report. The interactive grid still allows users to change the appearance and behavior of the report using the Actions menu. Users can perform actions such as changing column order, resizing column width, hiding or showing columns, applying filters or highlights, creating control breaks or charts, and saving reports.

NEW QUESTION 32
Choose the two correct statements about PWA.

Provides a customizable offline page when users areoffline and cannot request thenetwork.

To download the app as PWA, one must visit the App Store

An existing APEX app cannot be made a PWA

Enables users to install the application on devices

NEW QUESTION 33
Which three of the following options are TRUE about a page in an APEX application?

A page can contain buttons, page items and regions.

An APEX application can have only one page.

To view the rendered version of the page, you run or submit it to the Oracle APEX engine.

A page can be viewed and edited in the Page Designer.

NEW QUESTION 34
Which two Plugin types can be created in Oracle APEX?

Process

Validation

Email Template

Region

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 35
In a Classic Report, an end user can perform which two of the following actions?

Create Control Breaks in the report

Rearrange the columns in the report

Filter values of a column in the report

Sort the columns of the report

Explanation
In a Classic Report, an end user can perform the following actions:
Filter values of a column in the report by using the Search Bar. This bar allows the user to enter a search string and apply it to one or more columns in the report.
Sort the columns of the report by clicking on the column headers. This action toggles the sort order between ascending and descending for the selected column.
The other options are incorrect because:
Create Control Breaks in the report is not an action that an end user can perform in a Classic Report.
This action is only available in an Interactive Report by using the Control Break option in the Actions menu.
Rearrange the columns in the report is not an action that an end user can perform in a Classic Report.
This action is only available in an Interactive Grid by using the Reorder option in the Actions menu.
Verified References: [About Classic Reports] [Searching Classic Reports] [Sorting Classic Reports]

Loading …