[2024年01月]更新のOracle 1Z0-770テストエンジンとPDFで完全版無料問題集を無料提供 [Q80-Q105]

[2024年01月]更新のOracle 1Z0-770テストエンジンとPDFで完全版無料問題集を無料提供

最新版を今すぐ試そう1Z0-770認定有効な試験問題集

Oracle 1Z0-770 認定試験は、Oracle Application Express（APEX）を使用してウェブアプリケーションを開発するプロフェッショナルの知識とスキルをテストするために設計されています。Oracle APEX 開発者プロフェッショナルとして、組織のビジネス要件を満たす複雑なウェブアプリケーションを設計、開発、展開することができます。試験は、APEXアーキテクチャ、セキュリティ、データモデリング、アプリケーション設計、パフォーマンスチューニングなど、幅広いトピックをカバーしています。

Oracle Apex Developer Professional認定を獲得することは、Oracle Apexアプリケーションを開発および維持するために必要なスキルと知識を持っていることを潜在的な雇用主とクライアントに示しています。この認定は、混雑した雇用市場で際立っており、収益の可能性を高めるのに役立ちます。さらに、Oracle Apex Developmentの分野における継続的な学習と専門能力開発へのコミットメントを示しています。

Oracle 1Z0-770 認定試験は、Oracle Application Express（APEX）開発の専門知識を検証するために設計されたプロフェッショナルレベルの試験です。この試験は、Oracleデータベース技術の競争が激しい分野で際立つために必要な認定資格です。この試験に合格することで、プロフェッショナルは、Oracle APEX開発で使用される最新の技術とプログラミング手法に熟練していることを簡単に証明できます。

 

質問 # 80
What three are the building blocks of Approvals Component?

• A. Task Details Page
• B. Task Definition
• C. Automations
• D. Unified Task List

正解：A、B、D

解説：
Explanation
The Approvals Component is Oracle APEX's new offering as part of the 22.1 Release. It allows seamless management of approvals across APEX Applications. Approvals are commonly used in business situations involving Expense Reimbursements, Leave Requests, Purchase Requisitions, On-boarding of Employees to name a few. The Approvals Component provides the following building blocks for the approvals functionality:
Task Definition: A shared component for configuring task parameters, participants, and actions. A task definition defines the template for creating tasks based on a specific type of approval request, such as Leave Approval or Purchase Requisition. A task definition specifies the data source, display attributes, potential owners, business administrators, and available actions for the tasks.
Task Details Page: A page that shows task details, which can include metadata, history, comments, and actions. A task details page allows users to view and take action on a specific task, such as approve, reject, reassign, or escalate. A task details page can be created using the Create Page Wizard or the Quick SQL tool in APEX.
Unified Task List: A page type in the Create Page Wizard, used to create a summary of a user's tasks that functions like an inbox. A unified task list allows users to see and manage all their tasks in one place. Users can filter, sort, search, claim, release, or open tasks from the unified task list.

質問 # 81
In APEX, you can choose which three of the following Authentication methods?

• A. Authorization Scheme
• B. Custom Authentication Scheme
• C. No Authentication
• D. Built-in Authentication Scheme

正解：B、C、D

解説：
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.

質問 # 82
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. Interactive Grid
• B. Cards
• C. Master Detail
• D. Unified Task List

正解：B

解説：
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

質問 # 83
Which two of the following capabilities are TRUE for both Interactive Report and Interactive Grid?

• A. End user can rearrange the report interactively using the mouse.
• B. End user can customize how and what data is displayed.
• C. End user can add, modify, and refresh data directly on the report.
• D. End user can save the report

正解：B、C

解説：
Explanation
An Interactive Report and an Interactive Grid are two types of regions that allow end users to customize how and what data is displayed. They have some common capabilities such as:
End users can add, modify, and refresh data directly on the report by using the Edit option. This option enables inline editing or modal dialog editing depending on the region settings.
End users can customize how and what data is displayed by using the Actions menu. This menu provides various options such as Filter, Highlight, Aggregate, Chart, Group By, Pivot, etc.
The other options are incorrect because:
End users cannot rearrange the report interactively using the mouse in an Interactive Report. This capability is only available in an Interactive Grid by using the Reorder option in the Actions menu.
End users cannot save the report in an Interactive Grid. This capability is only available in an Interactive Report by using the Save Report option in the Actions menu.
Verified References: [About Interactive Reports] [About Interactive Grids]

質問 # 84
Developers can use Template Options in which of the following ways?

• A. Displaying form fields with different alignments
• B. Applying different spacing and padding
• C. Applying different colors or accents
• D. Rendering buttons in different styles, with and without icons
• E. All of them

正解：E

解説：
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.

質問 # 85
Which two statements are true about Faceted Search pages?

• A. Facets map to specific database columns.
• B. A facet's chart can be seen only in a nonmodal dialog.
• C. Multiple charts are not visible in the same region.
• D. Faceted Search supports the ability to filter columns storing multiple values as one string.

正解：A、D

解説：
Explanation
Faceted Search is a feature 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. Faceted Search supports the ability to filter columns storing multiple values as one string, such as comma-separated values or JSON arrays, by using the Split Values attribute. Facets map to specific database columns or expressions that are defined in the Data Source attribute of the faceted search region. The other statements are false because Faceted Search supports displaying multiple charts in the same region by using the Chart View attribute, and a facet's chart can be seen either in a nonmodal dialog or inline by using the Chart Display Mode attribute. Verified References: [Creating Faceted Search Pages - Oracle Help Center], [Facet Attributes - Oracle APEX]

質問 # 86
Which two tasks can you perform using App Builder?

• A. Create and manage database objects.
• B. Create join queries using drag and drop.
• C. Import previously exported apps.
• D. Create and manage apps.
• E. Generate data definition language (DDL) statements from the Oracle data dictionary.

正解：C、D

解説：
Explanation
App Builder is the main interface of Oracle APEX that allows developers to create and manage web applications. App Builder provides various features and tools to design, develop, test, debug, deploy, and maintain applications. Some of the tasks that you can perform using App Builder are importing previously exported apps, creating new apps from scratch or from predefined templates or blueprints, editing app properties and attributes, adding pages and regions, creating shared components, running and debugging apps, exporting apps to files or workspaces, etc. You cannot create join queries using drag and drop or generate DDL statements from the Oracle data dictionary using App Builder. Verified References: [Using App Builder
- Oracle Help Center], [App Builder Concepts - Oracle Help Center]

質問 # 87
Which two statements are true about creating and using dynamic actions?

• A. 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
• B. You can execute JavaScript code by creating a dynamic action.
• C. Once you create a dynamic action, you cannot add additional true actions.
• D. If no client-side condition is defined, true actions will not fire.

正解：A、B

解説：
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]

質問 # 88
Which statement is true about the Link Column attribute of an interactive report?

• A. A Link Column cannot be sorted, hidden, or moved by an end user.
• B. It is not possible to exclude Link Column.
• C. It is not possible to include a custom target in Link Column
• D. If you select Link Column, it is always displayed as the last column in the report.

正解：A

解説：
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.

質問 # 89
Choose the three supported spatial geometry objects in Maps.

• A. Bars
• B. Polygons
• C. Heat map
• D. Points

正解：B、C、D

解説：
Explanation
A map is a type of component that enables users 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. Three of the supported spatial geometry objects in Oracle APEX are:
Polygons: A polygon is a closed shape that consists of three or more vertices connected by straight line segments. A polygon can represent an area on a map, such as a country, a state, a city, or a building. A polygon can have different colors, patterns, or borders to indicate different attributes or categories of the data.
Heat map: A heat map is a type of visualization that uses color gradients to show the density or intensity of data values in a geographic area. A heat map can represent the distribution or variation of a numeric variable on a map, such as population, income, crime rate, or temperature.
Points: A point is a zero-dimensional shape that represents a single location on a map. A point can have different symbols, sizes, or colors to indicate different attributes or categories of the data. A point can also have a label or a tooltip to display additional information about the data.

質問 # 90
Using Data Workshop, you can perform which three tasks:

• A. Delete data from the database
• B. Load data using various file formats such as XLSX, CSV, XML, and JSON
• C. Export vast amount of data from the database into a file
• D. Load vast amount of data into the database

正解：B、C、D

解説：
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]

質問 # 91
Choose from the following the different kinds of page components you can create in APEX.

• A. Smart Filters
• B. Interactive Grid
• C. Faceted Search
• D. Search Page
• E. All of them

正解：E

解説：
Explanation
All of the options listed are different kinds of page components that you can create in APEX. A page component is an area of a page that serves as a container for content. Each page component contains a different type of content, such as HTML, a report, a form, a chart, a list, a breadcrumb, PL/SQL, a tree, a URL, or a calendar. You can create page components by using the Create Page Wizard, dragging and dropping from the Gallery pane in Page Designer, or using the context-sensitive menu in the Rendering tree in Page Designer.

質問 # 92
Which client credentials are utilized for authentication during the One-Click Remote ApplicationDeployment process?

• A. APEX Workspace Admin credentials
• B. Database schema credentials
• C. PEX Developer credentials

正解：A

解説：
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]

質問 # 93
What three are the key features of Data Load Definition?

• A. Easy workflow for end users: upload the file, verify the preview, and load data
• B. Column mapping occurs at design time, removing the burden on end users.
• C. The APEX_DATA_LOADING PL/SQL API is available for custom processing.
• D. Only XML data format can be loaded to tables or collections

正解：A、B、C

解説：
Explanation
Data Load Definition is a feature that enables developers to create pages with data loading capability. Users can upload files and load data into tables or collections. Some key features of Data Load Definition are:
The APEX_DATA_LOADING PL/SQL API is available for custom processing. Developers can use this API to programmatically load data by calling an application data loading definition .
Column mapping occurs at design time, removing the burden on end users. Developers can define SQL expressions, SQL queries, lookups, or transformation rules for each data profile column.
Easy workflow for end users: upload the file, verify the preview, and load data. Users can follow a simple three-step process to load data from a file into a table or a collection.
Data Load Definition does not support only XML data format. It also supports CSV, JSON, XLSX, and XML formats.

質問 # 94
Which two statements are true about loading data from the "Create an Application From a File" wizard?

• A. Data from remote web services can be uploaded.
• B. CSV, XLSX, XML, TXT, or JSON files can be uploaded.
• C. Seed data from a SQL script can be uploaded.
• D. A sample data set from the sample list can be uploaded.
• E. XML and JSON data can be pasted and loaded.

正解：B、D

解説：
Explanation
The "Create an Application From a File" wizard is a tool that allows developers to create an application based on an existing spreadsheet file or sample data set. Some of the statements that are true about loading data from this wizard are:
A sample data set from the sample list can be uploaded. You can use the Sample Data Sets option to select a predefined data set from a list of available samples, such as Employees, Products, Projects, etc.
CSV, XLSX, XML, TXT, or JSON files can be uploaded. You can use the Upload a File option to upload a spreadsheet file in one of these formats and create an application based on its data. You cannot upload seed data from a SQL script, paste and load XML and JSON data, or upload data from remote web services using this wizard. You can use other features in App Builder or SQL Workshop to perform these actions, such as SQL Scripts, RESTful Services, etc. VerifiedReferences: [Creating an Application From a File - Oracle Help Center], [Creating an Application Based on Sample Data Sets - Oracle Help Center]

質問 # 95
Which search type in Search Configurations provides linguistic and fuzzy search capabilities?

• A. Oracle Text
• B. List
• C. Standard

正解：A

解説：
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]

質問 # 96
Which three statements are TRUE about Shared Components?

• A. Breadcrumbs, Lists, and Navigation Bar entries are examples of shared components
• B. Once you create a Shared Component, you can add them to any page within your APEX application
• C. Shared components are common elements that can be displayed or applied on any page within an application
• D. Once you create a Shared Component, you can add them to any page within an APEX application in any workspace.

正解：A、B、C

解説：
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.

質問 # 97
Which statement is true about the Data Workshop utility?

• A. You cannot load data from an XLSX file with multiple worksheets.
• B. The wizards load and unload table data only.
• C. You can load or unload multiple tables at a time.
• D. The wizards load and unload all types of schema objects.

正解：B

解説：
Explanation
Data Workshop is a utility in SQL Workshop that enables developers to load and unload data to and from the database. The wizards load and unload table data only. They do not load or unload other kinds of schema objects. You can load data from an XLSX file with multiple worksheets by selecting the worksheet name in the Load Data Wizard. You can load or unload only a single table at a time using the wizards. Verified References: [Using Data Workshop - Oracle Help Center], [Loading Data - Oracle Help Center]

質問 # 98
The APEX engine uses which component as a key for tracking each user's session state?

• A. LDAP_USER
• B. APP_USER
• C. HTTP_USER
• D. APEX_USER

正解：B

解説：
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.

質問 # 99
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 Rendering
• C. Page rendering and processing
• D. Page compilation

正解：C

解説：
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.

質問 # 100
Plug-ins can be used declaratively in which of the following components in APEX?

• A. Dynamic Actions
• B. Regions
• C. Process Type
• D. Items
• E. All of them

正解：E

解説：
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.

質問 # 101
Which two statements are true about REST Data Sources?

• A. REST Data Sources doesn't support any authentication
• B. Oracle APEX supports the REST Enabled SQL Query REST Data Source type
• C. AREST Data Source can contain one or many Operations which are the references toa concrete external web service
• D. Oracle APEX doesn't provide direct integration of REST Data Sources in interactivereports

正解：B、C

解説：
Explanation
A REST Data Source is a logical representation of an external web service in Oracle APEX. It can contain one or many Operations, which are the references to a concrete external web service endpoint. Oracle APEX supports three types of REST Data Sources: REST Enabled SQL Query, Web Source Module, and Generic REST Data Source. Oracle APEX provides direct integration of REST Data Sources in interactive reports and grids, as well as other components. REST Data Sources can support various authentication methods, such as Basic, OAuth2, or Custom. References: [Understanding REST Data Sources] and [Creating a REST Data Source]

質問 # 102
What are Task definitions that exist on the application level inthe Shared Components section made up of?

• A. Actions
• B. Particpants
• C. Task Settings
• D. All of them
• E. Parameters

正解：D

解説：
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.

質問 # 103
Which two are true about Oracle APEX?

• A. Is declarative. It requires no code generation.
• B. Requires developers to be proficient in Java, Python and other programming languages.
• C. Requires no additional client software. A web browser is the app development IDE.
• D. Performs the data processing in a middle-tier server

正解：A、C

解説：
Explanation
Oracle APEX is a low-code development platform that enables you to build database-centric web applications using only a web browser. Oracle APEX has the following features:
Requires no additional client software. A web browser is the app development IDE: You can use any modern web browser to access the Oracle APEX development environment and build your applications.
You do not need to install or configure any additional software or tools on your client machine.
Is declarative. It requires no code generation: You can use declarative tools, visual editors, drag-and-drop components, and pre-built templates to define your application logic, user interface, security, and integration features. You do not need to write or generate any code for your applications.
The other options are incorrect because:
Performs the data processing in a middle-tier server: Oracle APEX performs the data processing in the database server. It uses SQL and PL/SQL to access and manipulate the data stored in the database. It does not rely on any middle-tier server or framework for data processing.
Requires developers to be proficient in Java, Python and other programming languages: Oracle APEX does not require developers to be proficient in Java, Python or other programming languages. It uses SQL and PL/SQL as the primarylanguages for data processing. It also supports HTML, CSS, JavaScript, and jQuery for user interface development.
Verified References: [About Oracle APEX] [Oracle APEX Architecture]

質問 # 104
Which two types of pages behave similarly in functionality?

• A. Map
• B. Smart Filter
• C. Faceted Search
• D. Cards

正解：B、C

解説：
Explanation
A Faceted Search and a Smart Filter are two types of pages that behave similarly in functionality. They both allow users to filter data based on multiple criteria and see the results in real time. They differ in the following aspects:
A Faceted Search uses facets to filter data. A facet is a set of filters based on a column or expression. A facet can be displayed as a list, a range slider, a star rating, or a chart.
A Smart Filter uses conditions to filter data. A condition is a logical expression that evaluates to true or false. A condition can be based on a column, an item, or a function.
The other options are incorrect because:
A Map is a type of region that displays spatial data on an interactive map. It allows users to zoom, pan, and select features on the map.
A Cards is a type of region that displays data in a grid of cards. Each card represents one row of data and can contain text, images, icons, or buttons.
Verified References: [About Faceted Search] [About Smart Filter] [About Maps] [About Cards]

質問 # 105
......

100%合格保証付きの素晴らしい1Z0-770試験問題PDF：https://jp.fast2test.com/1Z0-770-premium-file.html