[2024年09月02日] 最新1Z0-770試験問題集には高得点で一発合格 [Q45-Q69]

[2024年09月02日] 最新1Z0-770試験問題集には高得点で一発合格

無料提供中1Z0-770ブレーン問題集と1Z0-770リアル試験問題

Oracle 1Z0-770試験は、150分以内に完了する必要がある75の複数選択質問で構成されています。この試験では、Oracle Apexアーキテクチャ、ページ処理、データの読み込みと操作、セキュリティなど、幅広いトピックをカバーしています。試験に合格するには、Oracle Apexを強く理解する必要があります。また、このプラットフォームを使用してアプリケーションの開発と展開における実践的な経験が必要です。 Oracle Apex Developer Professional認定を取得することにより、開発者は潜在的な雇用主やクライアントにスキルと専門知識を紹介し、新しいキャリアの機会を開き、収益の可能性を高めることができます。

Oracle 1Z0-770認定は、Apex開発の専門知識を実証したいApex開発者にとって有益です。この認定は、複雑な頂点アプリケーションの設計、開発、テスト、展開における候補者の知識とスキルの検証を提供します。この認定は、候補者の専門能力開発に対するコミットメントと、最新のApexテクノロジーと傾向を最新の状態に保つ意欲を示しています。

 

質問 # 45
Select the two advantages of using One-click Remote Deployment.

• A. Directly deploy your app definition along with the objects from the source system to the target system
• B. You need to access your production environment to import the app directly.
• C. Deploy the app, and explicitly install the supporting objects in one-click.
• D. Simplify the process of deploying an application

正解：A、C

解説：
Explanation
One-click remote application deployment is a feature in Oracle APEX that simplifies the process of deploying an application from one APEX instance to another using REST Enabled SQL references. REST Enabled SQL references are shared components that work with an Oracle REST Data Services (ORDS) REST Enabled SQL Service. One-click remote application deployment can authenticate through first party authentication (Basic Authentication), Schema Authentication (database username and password), or OAuth 2 Client Credentials.
Two of the advantages of using one-click remote application deployment are:
Deploy the app, and explicitly install the supporting objects in one-click. This advantage allows you to package the app definition along with the database objects, images, and seed data necessary for your application to run correctly using the Supporting Objects functionality in APEX. You can then export and deploy this app and install the supporting objects in one-click without having to manually create or copy the database objects in the target system.
Directly deploy your app definition along with the objects from the source system to the target system.
This advantage allows you to avoid the intermediate step of exporting the app and its objects from the source system into files and then importing them into the target system. You can directly deploy your app and its objects from within your development environment to the remote production environment without having to access your production environment.

質問 # 46
Generally, clicking on the hamburger menu in the upper-left corner of an APEX application displays a list of pages. What is this navigation called?

• A. Lists
• B. Navigation Bar List
• C. Navigation Menu
• D. Breadcrumbs

正解：C

解説：
Explanation
The navigation menu is the list of pages that displays when you click on the hamburger menu in the upper-left corner of an APEX application. The navigation menu is a shared component that can be created and edited in the Shared Components page3. Lists, breadcrumbs, and navigation bar entries are other types of navigation components in APEX, but they are not the same as the navigation menu.

質問 # 47
What are the three types of List of Values(LOV) you can create on a page?

• A. Static LOV
• B. Cascading LOV
• C. Popup LOV
• D. Dynamic LOV

正解：A、B、D

解説：
Explanation
A list of values (LOV) is a definition that provides a set of display values and return values for a page item or a report column. A LOV can be created at the application level as a shared component or at the page level as a local component. There are three types of LOVs that you can create on a page:
Static LOV: A static LOV is based on a fixed list of display values and return values that you specify when you create the LOV. A static LOV does not change unless you edit it manually.
Cascading LOV: A cascading LOV is based on another parent LOV that determines the values of the child LOV. A cascading LOV changes dynamically depending on the selection made in the parent LOV.
Dynamic LOV: A dynamic LOV is based on a SQL query that returns display values and return values from the database. A dynamic LOV changes dynamically depending on the data in the database.

質問 # 48
Which three are the main components of APEX workspace homepage?

• A. RESTful Services
• B. App Builder
• C. SQL Workshop
• D. Gallery

正解：B、C、D

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

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

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

正解：B

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

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

• A. The APEX_DATA_LOADING PL/SQL API is available for custom processing.
• B. Column mapping occurs at design time, removing the burden on end users.
• C. Easy workflow for end users: upload the file, verify the preview, and load data
• 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.

質問 # 51
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. Multiple REST Data Sources can reference a single remote server.
• C. The remote server should mandatorily be an APEX instance.
• D. A single REST Data Source can use multiple remote servers.

正解：A、B

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

質問 # 52
The Movies faceted search report is filtered only when the Apply button for a selected facet is clicked. What must be done in the Page Designer so that report filtering is automatically executed when any facet value changes?

• A. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute
• B. Navigate to each facet and then in the Property Editor, turn on client-Side Filtering.
• C. Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute. Then, navigate to each facet and in the Property Editor, turn on client-Side Filtering.
• D. Navigate to the faceted search region Attributes, and turn off the show Facet Name attribute.

正解：A

解説：
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. By default, when end users select a facet value, they need to click on an Apply button for that facet to apply the filter to the report. To make report filtering automatically executed when any facet value changes, you need to navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute. The Batch Facet Changes attribute determines whether end users need to click on an Apply button for each facet or not. When this attribute is disabled, the report is automatically refreshed when any facet value changes. The other options are not relevant to the report filtering behavior. Verified References: [Faceted Search Attributes - Oracle Help Center], [Batch Facet Changes - Oracle APEX]

質問 # 53
Which three of the following statements are TRUE about Faceted Search?

• A. After the end user changes a facet, the results, dependent facets, and occurrence counts refresh immediately.
• B. The facets are displayed on the left and upper part of the screen
• C. You can create only 5 facets per page
• D. The right side of the page features a Search Results region, which can display as a classic report or a cards report.

正解：A、B、D

解説：
Explanation
A faceted search is a type of component that enables users to filter information easily and intuitively by selecting the options in each facet. A faceted search consists of a faceted search region and a search results region. The faceted search region displays on the left and upper part of the screen and shows possible values and occurrence counts for each facet. The search results region displays on the right side of the screen and shows the data that matches the selected facet values. The search results region can display as either a classic report or a cards report. Three of the statements that are true about faceted search are:
After the end user changes a facet, the results, dependent facets, and occurrence counts refresh immediately. This feature provides instant feedback to the user and allows them to refine their search criteria without reloading the page.
The right side of the page features a Search Results region, which can display as a classic report or a cards report. A classic report displays data in a tabular format with columns and rows. A cards report displays data in a grid of cards with images and text.
The facets are displayed on the left and upper part of the screen. This layout provides a clear separation between the facets and the results and allows users to see and access all the facets without scrolling.

質問 # 54
Which statement is true about Unified Task List in the Approvals component?

• A. It is a shared component used to configure task parameters, participants, actions, and due dates.
• B. It is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox.
• C. It is a page that shows details for a specific task, which can include metadata, history, comments, and actions.

正解：B

解説：
Explanation
The Approvals component in Oracle APEX is a feature that allows developers to create approval workflows for business processes that require human intervention or decision making. The Approvals component consists of three main elements: Tasks, Task List Page, and Task Details Page. The Unified Task List is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox for end users.
The Unified Task List displays all tasks assigned to or created by an end user along with their status, priority, due date, etc. End users can filter, sort, search, view details, and perform actions on tasks from this page.
Verified References: [Using Approvals - Oracle Help Center], [Creating a Unified Task List Page - Oracle Help Center]

質問 # 55
Choose the two options provided in a Column Heading menu of an Interactive Report.

• A. Hide
• B. Delete
• C. Control Break
• D. Group By

正解：A、C

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

質問 # 56
Which is a valid method of logging messages to the execution log in APEX automation?

• A. apex error.add error ( p_message => 'SAL for || :ENAME || increased by 1%.', p_display_location => apex_error.c_inline_in_notification );
• B. apex_automation.log_info('SAL for || :ENAME || increased by 18.');
• C. apex_debug.info ('SAL for ' || :ENAME || ' increased by 1%.');

正解：C

解説：
Explanation
APEX automation is a feature that allows you to automate tasks such as data loading, data synchronization, application export and import, and REST API calls by using declarative actions or PL/SQL code blocks. You can create automation tasks by using the Database Actions interface or by using the APEX_AUTOMATION package. To log messages to the execution log in APEX automation, you can use the APEX_DEBUG package with any of its logging levels (info, warning, error, etc.). The other options are not valid methods of logging messages in APEX automation. Verified References: [Using APEX Automation - Oracle Help Center],
[APEX_DEBUG - Oracle Help Center]

質問 # 57
An application includes a report and form on the PRODUCTS table.
The form page includes page items P21 PRODUCT NAME and P21_UNIT_PRICE.
P21_UNIT_PRICE is currently displayed below P21_PRODUCT_NAME.
Now, you need to reposition the items and display P21 UNIT_PRICE next to P21_PRODUCT_NAME.
Which two statements are true?

• A. In Page Designer, use the Middle Pane, click P21 UNIT PRICE and drag the item until it is directly next to P21 PRODUCT_NAME.
• B. In Page Designer, right-click P21_UNIT_PRICE and select Start New Row.
• C. In Page Designer, select P21_UNIT_PRICE and then in the Property Editor, under Layout set Start New Row to Yes.
• D. In Page Designer, select P21_PRODUCT_NAME and then in the Property Editor, under Layout set Start New Row to Yes.

正解：A、C

解説：
Explanation
To reposition the page items and display P21_UNIT_PRICE next to P21_PRODUCT_NAME, you can use either of these methods:
In Page Designer, use the Middle Pane, click P21_UNIT_PRICE and drag the item until it is directly next to P21_PRODUCT_NAME. This method allows you to visually arrange the items on the page layout.
In Page Designer, select P21_UNIT_PRICE and then in the Property Editor, under Layout set Start New Row to Yes. This method changes the attribute of the item to start a new row in the grid layout. The other options, A and D, are incorrect because they would not achieve the desired result. Setting Start New Row to Yes for P21_PRODUCT_NAME would move it to a new row, not next to P21_UNIT_PRICE. Right-clicking P21_UNIT_PRICE and selecting Start New Row would not change the attribute of the item, but only move it to a new position in the Layout tab. Verified References: Positioning Page ItemsLayout Tab

質問 # 58
There is a page with an interactive grid region based on this statement: SELECT EMPNO, ENAME, COMM from EMP; In the Interactive Grid attributes, under the Edit group, the Enabled switch is turned Off. Which are two of the actions that you must perform to make an employee's commission editable in the grid?

• A. Ensure that the "Primary Key" switch is turned "On" for the EMPNO column.
• B. In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group.
• C. Set EMPNO, ENAME to "Display Only".
• D. In the Interactive Grid attributes, select COMM for "Allowed Row Operations Column".

正解：A、B

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

質問 # 59
Which two statements are true about REST Data Source Synchronization?

• A. If the local table is not in sync with the Data Profile, Data Synchronization doesn't work.
• B. The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties
• C. If the local table is not in sync with the Data Profile, Data Synchronization continues to work for columns present in both the table and the Data Profile.
• D. You cannot trigger Data Synchronization on a regular schedule using a scheduler job.
• E. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.

正解：C、E

解説：
Explanation
REST Data Source Synchronization is a feature that enables developers to automatically sync the contents of a local table with the data from an external REST service. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema, which allows APEX to create a DBMS_SCHEDULER job for each scheduled synchronization task. If the local table is not in sync with the Data Profile, which defines the columns and data types of the REST service response, Data Synchronization continues to work for columns present in both the table and the Data Profile (other columns are ignored). However, APEX generates SQL DDL statements to sync table columns back to the Data Profile, which can be added to the application as supporting objects. Verified References: Managing Data Synchronization - Oracle Help Center, Synchronize Data from REST Services to Local Table - Oracle Blogs

質問 # 60
Which two Query Source types can be used to create a dynamic Navigation Bar List?

• A. SQL Query
• B. Procedure
• C. Function Returning SQL Query
• D. Select List

正解：A、C

解説：
Explanation
The Query Source types for a Navigation Bar List are SQL Query and Function Returning SQL Query. These types allow you to define the list entries using a SQL statement or a PL/SQL function that returns a SQL statement. The other options, Select List and Procedure, are not valid for a Navigation Bar List. Verified References: Create Page Wizard: Navigation Bar List AttributesCreating Lists

質問 # 61
Which two are valid evaluation points for Authorization Schemes?

• A. Once per page view
• B. Once per session
• C. Once per user
• D. Never

正解：A、D

解説：
Explanation
An authorization scheme is a rule that determines if a user is authorized to access a specific component or feature of an application, such as a page, region, button, item, etc. An authorization scheme can be evaluated at different points in time depending on its evaluation point attribute. The valid evaluation points for authorization schemes are:
Never: The authorization scheme is never evaluated and always returns false.
Once per session: The authorization scheme is evaluated only once per user session and caches the result for subsequent requests.
Once per page view: The authorization scheme is evaluated once per page view and caches the result for subsequent requests within the same page view.
On each new page view or partial page refresh: The authorization scheme is evaluated on each new page view or partial page refresh (for example, when using dynamic actions) and caches the result until the next page view or partial page refresh.
On each request (not cached): The authorization scheme is evaluated on each request and does not cache the result. Once per user and Once per page load are not valid evaluation points for authorization schemes. Verified References: [Creating Authorization Schemes - Oracle Help Center], [Authorization Scheme Attributes - Oracle Help Center]

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

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

正解：D

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

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

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

正解：A、B、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.

質問 # 64
You added Access Control feature pages to your application. Which two actions can you perform as an Administrator using the Administration page?

• A. Assign roles to users
• B. Create Authorization schemes
• C. Create new application roles
• D. Add Users

正解：A、D

解説：
Explanation
The Access Control feature pages are a set of pages that allow developers to implement role-based access control for an application. The Access Control feature pages consist of four pages: Administration, Users, Roles, and Role Assignments. The Administration page allows administrators to perform various tasks related to managing users and roles, such as:
Add Users: Administrators can add new users to the application by entering their username, email address, password, status, etc.
Assign roles to users: Administrators can assign one or more roles to users by selecting them from a list of available roles.
Edit Users: Administrators can edit user details such as username, email address, password, status, etc.
Delete Users: Administrators can delete users from the application by selecting them from a list of existing users.
Lock/Unlock Users: Administrators can lock or unlock users by changing their status from active to locked or vice versa. You cannot create authorization schemes or create new application roles using the Administration page. You can create authorization schemes by using Shared Components > Security > Authorization Schemes. You can create new application roles by using Shared Components > Security > Access Control > Roles. Verified References: [Using Access Control - Oracle Help Center], [Creating an Administration Page - Oracle Help Center]

質問 # 65
Which two of the following types can an end user save the customized Interactive report as?

• A. A Public report
• B. A private report
• C. Default report
• D. Cannot save the report

正解：A、B

質問 # 66
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]

質問 # 67
The Page Designer Toolbar allows you to perform which two of the following actions?

• A. Create a new page
• B. Navigate to Shared Components
• C. Delete the application
• D. Export the application

正解：A、B

解説：
Explanation
The Page Designer Toolbar allows you to perform various actions related to the development of an APEX page. Two of the actions that you can perform are:
Navigate to Shared Components: This option lets you access the shared components of your application, such as lists, breadcrumbs, navigation menus, and so on. You can edit, create, or delete shared components from this option. To access this option, click the icon that resembles a puzzle piece on the Page Designer Toolbar.
Create a new page: This option lets you create a new page for your application using the Create Page Wizard. You can choose from different page types, such as blank page, form, report, chart, calendar, and so on. To access this option, click the icon that resembles a plus sign (+) on the Page Designer Toolbar.

質問 # 68
To highlight certain rows in the interactive report based on a condition, you must:

• A. Choose a condition in Format > Highlight
• B. Rows cannot be highlighted in an Interactive report
• C. Provide a conditional SQL query
• D. Edit the rows in the report and select a color

正解：A

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

質問 # 69
......

1Z0-770合格させる問題集でOracle24時間で試験合格できます：https://www.jpntest.com/shiken/1Z0-770-mondaishu

Oracle 1Z0-770実際の問題とブレーン問題集：https://drive.google.com/open?id=1EREIeBKLOOeo06vg0X_k155RSU8YYzeV