1z1-770認定の有効な試験問題集解答学習ガイド！（最新の144問題)
1z1-770問題集で時間限定！無料アクセスせよ
Oracle 1Z0-770（Oracle Apex Developer Professional）認定試験は、Apexを使用してWebアプリケーションの開発においてスキルと知識を証明したいApex開発者にとって不可欠な資格です。 Apex開発に関連する幅広いトピックをカバーし、Pearson Vueテストセンターまたはオンラインで監督済みの試験形式を使用して取得できます。この認定を取得することにより、Apex開発者はキャリアの見通しを強化し、貴重なリソースとトレーニングの機会にアクセスできます。
Oracle 1Z0-770（Oracle Apex Developer Professional）認定試験は、Oracle Application Express（APEX）を使用してアプリケーションを開発するスキルと知識を検証したい専門家向けに設計されています。 Apexは、開発者がSQLとPL/SQLを使用してWebアプリケーションをすばやく構築および展開できるようにする低コード開発プラットフォームです。この認定試験では、セキュリティ、データモデリング、ユーザーインターフェイス設計、アプリケーションの展開など、頂点開発に関連する幅広いトピックをカバーしています。
質問 # 11
When a table or a SQL query returns many rows, an Interactive Grid is best displayed to the user with pagination. The two types of pagination available are:
- A. No Pagination
- B. Scroll
- C. Page
- D. Page and Scroll
正解：D
解説：
Explanation
When a table or a SQL query returns many rows, an interactive grid is best displayed to the user with pagination. Pagination enables users to navigate through large data sets by displaying a subset of data at a time3. The two types of pagination available for interactive grids are Page and Scroll3. Page pagination displays a fixed number of rows per page and provides controls to navigate between pages. Scroll pagination displays rows as the user scrolls down the grid and fetches more data as needed
質問 # 12
Which two statements are true about REST Data Sources?
- A. Oracle APEX supports the REST Enabled SQL Query REST Data Source type
- B. Oracle APEX doesn't provide direct integration of REST Data Sources in interactivereports
- C. AREST Data Source can contain one or many Operations which are the references toa concrete external web service
- D. REST Data Sources doesn't support any authentication
正解：A、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]
質問 # 13
To highlight certain rows in the interactive report based on a condition, you must:
- A. Edit the rows in the report and select a color
- B. Provide a conditional SQL query
- C. Choose a condition in Format > Highlight
- D. Rows cannot be highlighted in an Interactive report
正解：C
解説：
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]
質問 # 14
What three are the key features of Data Load Definition?
- A. Column mapping occurs at design time, removing the burden on end users.
- B. Easy workflow for end users: upload the file, verify the preview, and load data
- C. Only XML data format can be loaded to tables or collections
- D. The APEX_DATA_LOADING PL/SQL API is available for custom processing.
正解：A、B、D
解説：
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.
質問 # 15
Select the three types of Card Layout you can create in APEX.
- A. Vertical(Column)
- B. Horizontal(Row)
- C. Grid
- D. Float
正解：B、C、D
解説：
Explanation
You can create two types of card layout in APEX: Float and Grid. Float layout displays cards in a single row that wraps to the next row when the available space is filled. Grid layout displays cards in a fixed number of columns that can be responsive to the screen size1. Vertical and Horizontal are not valid card layout types in APEX.
質問 # 16
What three are the uses of Collections in APEX?
- A. You insert, update, and delete collection information using PL/SQL APIAPEX_COLLECTION.
- B. Collections can be accessed, manipulated, or processed during a user's specific session.
- C. Use collections to temporarily capture one or more nonscalar Values.
- D. Collections enable you to store rows and columns in the current session into database tables
正解：A、B、C
解説：
Explanation
Collections are temporary tables that store session-specific data in memory. They can be used for various purposes in APEX applications. Some uses of collections are:
You insert, update, and delete collection information using PL/SQL API APEX_COLLECTION. This API provides several procedures and functions to manipulate collections and their members.
Use collections to temporarily capture one or more nonscalar values. For example, you can use collections to store the results of a query, the values of page items, or the selections of a report.
Collections can be accessed, manipulated, or processed during a user's specific session. For example, you can use collections to pass data between pages, perform calculations on collection members, or create reports based on collections.
Collections do not enable you to store rows and columns in the current session into database tables.
Collections are stored in memory and are not persistent across sessions.
質問 # 17
Which two statements are true about the Create Application Wizard?
- A. It allows application pages to be reordered.
- B. It allows the application authorization to be changed
- C. It allows the uploading of JavaScript or CSS files required for an application.
- D. It allows application pages to be added or deleted.
正解：A、D
解説：
Explanation
The Create Application Wizard is a tool that allows developers to create a new application by following a series of steps. Some of the actions that you can perform using the Create Application Wizard are:
Reorder application pages. You can use the Reorder Pages option in the Pages step to change the order of the pages in your application by dragging and dropping them.
Add or delete application pages. You can use the Add Page or Delete Page options in the Pages step to add new pages or delete existing pages from your application. You can also use the Create Page Wizard to create additional pages after creating the application. You cannot upload JavaScript or CSS files required for an application or change the application authorization using the Create Application Wizard.
You can use other features in App Builder to perform these actions, such as Shared Components > User Interface > Files and Shared Components > Security > Authentication Schemes. Verified References:
[Creating an Application Using the Create Application Wizard - Oracle Help Center], [Create Application Wizard - Oracle APEX]
質問 # 18
What three are the building blocks of Approvals Component?
- A. Task Details Page
- B. Automations
- C. Unified Task List
- D. Task Definition
正解：A、C、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.
質問 # 19
What are Task definitions that exist on the application level inthe Shared Components section made up of?
- A. Particpants
- B. All of them
- C. Actions
- D. Task Settings
- 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.
質問 # 20
You can create an APEX workspace and build APEX apps on which of the following platforms?
- A. Microsoft Azure
- B. Amazon RDS
- C. All of the above
- D. Oracle Autonomous Cloud
- E. Oracle XE
正解：C
解説：
Explanation
You can create an APEX workspace and build APEX apps on any of the following platforms:
Oracle Autonomous Cloud: This is a cloud platform that provides various services such as Autonomous Database, Oracle Cloud Infrastructure, and Oracle APEX Application Development. You can create an APEX workspace and build APEX apps on an Autonomous Database instance or an APEX Service instance.
Oracle XE: This is a free edition of Oracle Database that supports up to 12 GB of user data. You can install Oracle XE on your local machine and use it to create an APEX workspace and build APEX apps.
Amazon RDS: This is a cloud service that provides managed relational databases. You can create an APEX workspace and build APEX apps on an Amazon RDS for Oracle instance that supports Oracle APEX.
Microsoft Azure: This is a cloud platform that provides various services such as virtual machines, storage, and networking. You can create an APEX workspace and build APEX apps on a Microsoft Azure VM that runs Oracle Database and Oracle APEX.
Verified References: Oracle Autonomous CloudOracle XEAmazon RDSMicrosoft Azure
質問 # 21
Which two layout options are available for Page Designer under Utilities?
- A. Four Pane Mode
- B. Two Pane Mode
- C. Three Pane Mode
- D. Single Pane Mode
正解：B、D
解説：
Explanation
Page Designer is a tool that allows developers to create and edit pages in Oracle APEX using a graphical user interface. Page Designer has three main panes: Rendering, Processing, and Property Editor. You can change the layout of Page Designer under Utilities by selecting one of the following options:
Single Pane Mode - This option displays only one pane at a time. You can switch between the Rendering, Processing, and Property Editor panes by using the buttons on the toolbar or the keyboard shortcuts.
Two Pane Mode - This option displays two panes side by side. You can choose which panes to display by using the buttons on the toolbar or the keyboard shortcuts. You can also resize the panes by dragging the splitter bar between them. There is no Three Pane Mode or Four Pane Mode option for Page Designer layout. Verified References: [Managing Pages in Page Designer - Oracle Help Center], [Page Designer Layout Options - Oracle Help Center]
質問 # 22
Which two among the following are TRUE about Low Code Apps?
- A. Scalable
- B. Provide Rich Functionality with Less Code
- C. Not Mobile Friendly
- D. Expensive
正解：A、B
解説：
Explanation
Low Code Apps are applications that are developed using a low-code development platform such as Oracle APEX. Low Code Apps have the following characteristics:
Scalable: Low Code Apps can handle large volumes of data and users without compromising performance or reliability. They can also leverage the scalability features of the underlying database or cloud platform.
Provide Rich Functionality with Less Code: Low Code Apps can provide complex business logic, user interface, security, and integration features with minimal or no coding. They use declarative tools, visual editors, drag-and-drop components, and pre-built templates to speed up the development process.
The other options are incorrect because:
Not Mobile Friendly: Low Code Apps are mobile friendly by default. They use responsive design techniques to adapt to different screen sizes and orientations. They also support touch gestures, device features, and offline capabilities.
Expensive: Low Code Apps are not expensive to develop or maintain. They reduce the cost of development by requiring less time, resources, and skills. They also reduce the cost of maintenance by simplifying the deployment, testing, and debugging processes.
Verified References: [What is Low Code?] [Why Choose Oracle APEX?]
質問 # 23
Which statement is true about Unified Task List in the Approvals component?
- A. It is a page that shows details for a specific task, which can include metadata, history, comments, and actions.
- 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 shared component used to configure task parameters, participants, actions, and due dates.
正解：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]
質問 # 24
What are the three types of List of Values(LOV) you can create on a page?
- A. Popup LOV
- B. Dynamic LOV
- C. Cascading LOV
- D. Static LOV
正解：B、C、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.
質問 # 25
What are the three features of a calendar in APEX?
- A. Next - Navigates to the next month.
- B. Previous - Navigates to the previous month.
- C. Reminders - Displays the reminders set by the users
- D. Month, Week, Day - Displays a monthly, weekly and daily view.
正解：A、B、D
解説：
Explanation
A calendar is a type of component that enables users to view and manage data based on dates. A calendar can display data in different views, such as monthly, weekly, daily, or list. Users can also interact with the calendar by creating, editing, or deleting events, or by using drag and drop functionality. Three of the features of a calendar in Oracle APEX are:
Next - Navigates to the next month. This feature allows users to move forward in time and see the events for the following month.
Previous - Navigates to the previous month. This feature allows users to move backward in time and see the events for the previous month.
Month, Week, Day - Displays a monthly, weekly and daily view. These features allow users to switch between different views of the calendar and see the events for a specific month, week, or day.
質問 # 26
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 turn off the show Facet Name attribute.
- B. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute
- C. Navigate to each facet and then 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. Then, navigate to each facet and in the Property Editor, turn on client-Side Filtering.
正解：B
解説：
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]
質問 # 27
Select the three types of Facets you can create in APEX.
- A. Input Field
- B. Text Area
- C. Range
- D. Checkbox Group
正解：A、C、D
解説：
Explanation
A facet is a type of component that provides a set of display values and return values for a faceted search region or a smart filters region. A facet can be based on either static values or dynamic values from a list of values (LOV). A facet can also have different display styles depending on its type and settings. Three of the types of facets that you can create in APEX are:
Range: A range facet displays numeric values in either buckets or sliders that users can select or adjust to filter the search results. A range facet can have either static values or dynamic values based on an LOV or SQL query.
Checkbox Group: A checkbox group facet displays multiple options that users can select or deselect to filter the search results. A checkbox group facet can have either static values or dynamic values based on an LOV or SQL query.
Input Field: An input field facet displays a text field that users can enter text to filter the search results.
An input field facet does not have any values but uses an operator to compare the user input with the data.
質問 # 28
Choose the three requirements for creating a REST Enabled SQL Reference.
- A. Configure and enable the REST Enabled SQL service feature
- B. Install Oracle REST Data Services (ORDS) 19.x or later.
- C. Set up any remote database
- D. Activate REST Enabled SQL for the target schema on the remote database
正解：A、B、D
解説：
Explanation
To create a REST Enabled SQL Reference, you need to meet the following requirements:
Install Oracle REST Data Services (ORDS) 19.x or later. ORDS is a Java application that enables developers to create, publish, and manage RESTful web services for Oracle databases1.
Activate REST Enabled SQL for the target schema on the remote database. REST Enabled SQL is a feature of ORDS that allows you to execute any SQL or PL/SQL through a REST endpoint. You need to enable this feature for the schema that contains the data you want to access2.
Configure and enable the REST Enabled SQL service feature. This is a workspace-level setting that allows you to use REST Enabled SQL references in your APEX applications. You need to specify a path prefix and a secret for the REST Enabled SQL service3.
You do not need to set up any remote database, as long as it meets the ORDS and REST Enabled SQL requirements. You can use any Oracle database or MySQL database as a remote data source2.
質問 # 29
Which statement is true about the Approvals component?
- A. APEX_APPROVAL is Page processes that create andact on task instances in yourpages.
- B. Unified Task List is a shared component used to configure task parameters,participants, actions, and due dates.
- C. You can set up task approvers and administrators at design time or determine themdynamically at runtime based on data related to the task.
- D. Task Definition is a page that shows details for a specific task, which can include metadata, history, comments, and actions.
正解：C
解説：
Explanation
The Approvals Component is a feature in Oracle APEX that enables you to create and manage tasks for user approval. The Approvals Component deals with all aspects of human approval in Oracle APEX, allowing you to put approval functionality into your applications. The Approvals Component creates one or more tasks for items that require approval based on a pre-configured template, known as the Task Definition. The Task Definition specifies the data source, display attributes, potential owners, business administrators, and available actions for the tasks. You can set up task approvers and administrators at design time or determine them dynamically at runtime based on data related to the task. For example, you can use a SQL query or a PL/SQL function to return the list of potential owners or business administrators for each task based on some criteria, such as department, role, or location.
質問 # 30
What are the three types of Master Detail Form you can create in APEX?
- A. One Below the other
- B. Two Page Drill Down
- C. Side by Side
- D. Stacked
正解：B、C、D
解説：
Explanation
A master detail form is a type of form that enables users to query, insert, update, and delete values from two related tables or views. A master detail form reflects a one-to-many relationship between tables in a database.
Typically, a master detail form displays a master row and multiple detail rows. In APEX, you can create three types of master detail forms using the Create Page Wizard or the Create Application Wizard:
Stacked: A stacked master detail form contains a single page with editable interactive grids based on two related tables or views. Users select a row in the master grid to update the detail grid. Developers can create a stacked master detail with either the Create Application Wizard or the Create Page Wizard.
Side by Side: A side by side master detail form contains a single page with two editable interactive grids based on two related tables or views. Users can see and edit both the master and detail grids at the same time. Developers can create a side by side master detail with either the Create Application Wizard or the Create Page Wizard.
Two Page Drill Down: A two page drill down master detail form contains two pages based on two related tables or views. The first page is a non-editable interactive grid for the master table. Users click the Edit icon on the first page to edit details on the second page. The second page includes both a standard form for the master and an editable interactive grid for the detail. Developers can create a two page drill down master detail with only the Create Page Wizard.
質問 # 31
......
Oracle 1Z0-770認定試験に備えるためには、SQLとPL/SQLの強い理解、およびOracleデータベースの経験が推奨されます。さらに、Oracleは、練習問題を含むトレーニングコースや学習資料を提供して、試験に備えるための支援を行っています。
Oracle 1z1-770試験実践テスト問題：https://www.jpntest.com/shiken/1z1-770-mondaishu
1z1-770問題集で2024年最新のOracle 1z1-770試験問題：https://drive.google.com/open?id=1EsU4upI1-MV0A0Jg12Nz5H7WBAXDJf1O