[2025年04月06日]1Z0-770テスト準備できるトレーニング練習テスト試験問題
試験問題解答ブレーン問題集で1Z0-770試験問題集PDFを使おう
1Z0-770試験の準備をするには、候補者は頂点アーキテクチャ、セキュリティ、データモデリング、Webサービス、およびSQLを強く理解する必要があります。また、APEXを使用してWebアプリケーションを設計および開発する実践的な経験が必要です。 Oracleは、オンラインコース、ワークショップ、練習試験など、候補者が試験の準備を支援するためのいくつかのトレーニングコースとリソースを提供しています。
Oracle Apex Developer Professional Certificationは、IT業界の貴重な資格です。それは世界的に認識されており、雇用市場の他の開発者から際立っているのを助けることができます。また、雇用主にとって魅力的な継続的な学習と専門能力開発へのあなたのコミットメントを示しています。
質問 # 62
Which two statements are true about creating and customizing Smart Filters pages?
- A. The search results report can be displayed as an interactive grid
- B. The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types.
- C. The search results report can be displayed as an interactive report.
- D. If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache.
正解：B、D
解説：
Explanation
Smart Filters is a component that allows end users to filter data by typing keywords in a single search field.
Some of the statements that are true about creating and customizing Smart Filters pages are:
If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache. You can also manually add or remove filters as needed.
The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types. For other filter types, such as Input or Range, the count is not displayed. The search results report cannot be displayed as an interactive report or an interactive grid. The supported report types are Classic Report, Cards, Map, or Calendar. Verified References: [Managing Smart Filters - Oracle Help Center],
[Creating Smart Filters Using the Create Page Wizard - Oracle Help Center]
質問 # 63
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. Only XML data format can be loaded to tables or collections
- C. Column mapping occurs at design time, removing the burden on end users.
- D. The APEX_DATA_LOADING PL/SQL API is available for custom processing.
正解：A、C、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.
質問 # 64
In a Classic Report, an end user can perform which two of the following actions?
- A. Rearrange the columns in the report
- B. Sort the columns of the report
- C. Filter values of a column in the report
- D. Create Control Breaks in the report
正解：B、C
解説：
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]
質問 # 65
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.
質問 # 66
Choose the two correct statements about PWA.
- A. Enables users to install the application on devices
- B. To download the app as PWA, one must visit the App Store
- C. An existing APEX app cannot be made a PWA
- D. Provides a customizable offline page when users areoffline and cannot request thenetwork.
正解：A、D
質問 # 67
Which two actions enable "hide and show" behavior of a data series in a bar chart when its corresponding legend item is clicked?
- A. Setting the Hide and Show Behavior attribute value to No Rescaling
- B. Setting the Hide and Show Behavior attribute value to None
- C. Setting the Hide and Show Behavior attribute value to Rescale
- D. Setting the on Data Change attribute value to slide to Left
正解：A、C
解説：
Explanation
A bar chart is a type of chart that displays data as horizontal or vertical bars with lengths proportional to the values they represent. A bar chart can have one or more data series, which are groups of data points that share the same color and legend item. To enable "hide and show" behavior of a data series in a bar chart when its corresponding legend item is clicked, you need to set the Hide and Show Behavior attribute value to either Rescale or No Rescaling. The Hide and Show Behavior attribute determines how the chart behaves when a data series is hidden or shown by clicking on its legend item. The possible values are:
None: The chart does not support hiding or showing data series by clicking on legend items.
Rescale: The chart supports hiding or showing data series by clicking on legend items, and rescales the axes accordingly.
No Rescaling: The chart supports hiding or showing data series by clicking on legend items, but does not rescale the axes. Setting the on Data Change attribute value to slide to Left will not affect the "hide and show" behavior of a data series in a bar chart. This attribute determines how the chart behaves when new data is loaded, such as when using dynamic actions or refresh actions. The possible values are:
None: The chart does not animate when new data is loaded.
Slide to Left: The chart slides to the left when new data is loaded.
Slide to Right: The chart slides to the right when new data is loaded. Verified References: [Creating Bar Charts - Oracle Help Center], [Bar Chart Attributes - Oracle Help Center]
質問 # 68
Choose the two statements that are TRUE about the Universal Theme in APEX.
- A. Easy customization
- B. The developers must have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme.
- C. Responsive UI
- D. Not designed to work on tablets
正解：A、C
解説：
Explanation
The Universal Theme is a responsive user interface design for Oracle APEX applications. It has the following features:
Responsive UI: The Universal Theme uses responsive design techniques to adapt to different screen sizes and orientations. It ensures that your applications look great and work well on any device, such as desktops, laptops, tablets, or smartphones.
Easy customization: The Universal Theme allows you to customize the appearance and behavior of your applications using various tools and options. You can use Theme Roller to change the colors, fonts, icons, and styles of your applications. You can also use Template Options to modify the layout and functionality of your components.
The other options are incorrect because:
Not designed to work on tablets: The Universal Theme is designed to work on tablets as well as other devices. It uses responsive design techniques to adapt to different screen sizes and orientations.
The developers must have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme: The developers do not need to have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme. They can use declarative tools such as Theme Roller and Template Options to customize their applications without coding.
Verified References: [About Universal Theme] [Using Theme Roller] [Using Template Options]
質問 # 69
Which two statements are true about Maps in Oracle APEX?
- A. Heat Map and Polygons are not supported Spatial geometry objects
- B. Background maps do not require any API keys.
- C. Maps support REST Enabled SQL
- D. Maps don't support REST Data Sources
正解：B、C
解説：
Explanation
A map is a type of component that enables you 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. Two of the statements that are true about maps in Oracle APEX are:
Background maps do not require any API keys. This statement is true because Oracle APEX provides several background map options that do not require any API keys or registration to use. These options include OpenStreetMap, Stamen Maps, CartoDB Maps, and Esri Maps.
Maps support REST Enabled SQL. This statement is true because Oracle APEX allows you to use REST Enabled SQL as a data source for your map regions. REST Enabled SQL is a feature of Oracle REST Data Services (ORDS) that enables you to execute SQL statements and PL/SQL blocks over HTTPS using REST endpoints.
質問 # 70
Choose the three correct options in the given friendly URL syntax:
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?
- A. update-employees is the PL/SQL procedure to update the employee details.
- B. mycompany is the path-prefix which is by default the workspace name
- C. session=13766599855150 Ahr-app is the application alias.
- D. 13766599855150 is the session ID. A new ID is generated for each session.
正解：B、C、D
解説：
Explanation
The friendly URL syntax
https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?session=13766599855150 has the following components:
session=13766599855150 is the session ID. A new ID is generated for each session. This parameter identifies which session is associated with the request.
hr-app is the application alias. This parameter identifies which application is being requested. An application alias is a user-friendly name that can be used instead of an application ID.
mycompany is the path-prefix which is by default the workspace name. This parameter identifies which workspace is being requested. A path-prefix is a URL segment that can be used instead of a workspace ID.
updateemployees is the page alias. This parameter identifies which page is being requested. A page alias is a user-friendly name that can be used instead of a page number.
The other option is incorrect because:
update-employees is not the PL/SQL procedure to update the employee details. It is the page alias that identifies which page is being requested.
Verified References: [About Friendly URLs] [Understanding URL Syntax]
質問 # 71
I want to hide a few columns in my interactive report. To do so, which option should I choose fromthe Actions menu?
- A. Filter
- B. columns
- C. Data
- D. Format
正解：B
解説：
Explanation
To hide a few columns in your interactive report, you should choose Columns from the Actions menu. This option allows you to select which columns to show or hide in your report by using checkboxes. You can also reorder or resize the columns from this option.
The other options are incorrect because:
Filter allows you to filter the data in your report by applying one or more conditions on the columns.
Data allows you to add, modify, or delete data in your report by using inline editing or modal dialog editing.
Format allows you to change the appearance of your report by applying conditional formatting rules or highlighting colors.
Verified References: [Customizing Interactive Reports] [Actions Menu]
質問 # 72
Which three of the following are use cases of Automations?
- A. Sending email alerts at a particular time of the week
- B. Approving specific requests
- C. Monitoring log tables and raising an alert when there is an issue
- D. Deleting a database record based on an end user's request
正解：A、B、C
解説：
Explanation
Automations are a sequential set of PL/SQL actions that are triggered by query results. They are used to monitor data and then perform the appropriate action2. Some use cases of automations are:
Monitoring log tables and raising an alert when there is an issue. For example, an automation can query a log table for any errors and send an email notification to the administrator if any errors are found2.
Approving specific requests. For example, an automation can query a table for any pending requests and approve them automatically based on some criteria2.
Sending email alerts at a particular time of the week. For example, an automation can query a table for any overdue tasks and send a reminder email to the assignees every Monday2.
Deleting a database record based on an end user's request is not a use case of automations, as it does not involve querying data and triggering actions based on the query results. This can be achieved by using a PL/SQL process or a dynamic action on the page where the user requests the deletion34.
質問 # 73
Select the two places from where you can access the Shared Components Page?
- A. Application homepage
- B. SQL Workshop
- C. Gallery
- D. Page Designer
正解：A、D
解説：
Explanation
You can access the Shared Components page from two places in App Builder: the Page Designer and the Application home page. In Page Designer, you can click on the Shared Components icon at the top of the page to open the Shared Components page in a new tab5. In the Application home page, you can click on the Shared Components link in the center of the page to navigate to the Shared Components page6. Gallery, SQL Workshop, and other pages do not have direct links to the Shared Components page.
質問 # 74
Which three of the following options are TRUE about a page in an APEX application?
- A. A page can contain buttons, page items and regions.
- B. A page can be viewed and edited in the Page Designer.
- C. An APEX application can have only one page.
- D. To view the rendered version of the page, you run or submit it to the Oracle APEX engine.
正解：A、B、D
質問 # 75
What are the three types of List of Values(LOV) you can create on a page?
- A. Popup LOV
- B. Dynamic LOV
- C. Static LOV
- D. Cascading 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.
質問 # 76
What three are the uses of Collections in APEX?
- A. Collections can be accessed, manipulated, or processed during a user's specific session.
- B. Use collections to temporarily capture one or more nonscalar Values.
- C. Collections enable you to store rows and columns in the current session into database tables
- D. You insert, update, and delete collection information using PL/SQL APIAPEX_COLLECTION.
正解：A、B、D
解説：
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.
質問 # 77
You have an interactive grid component and you are enabling the Save Public Report attribute. As what can end users save the report type?
- A. As Primary only
- B. As Public only
- C. As Private only
- D. As Private and public only
正解：D
解説：
Explanation
When you enable the Save Public Report attribute for an interactive grid, end users can save their report preferences as either private or public reports. Private reports are only visible to the user who created them, while public reports are visible to all users who have access to the interactive grid. You can also specify an authorization scheme to control who can save public reports. Verified References: Managing Interactive Grids
- Oracle Help Center, [Interactive Grid Attributes - Oracle Help Center]
質問 # 78
Which two statements are true about REST Data Sources?
- A. AREST Data Source can contain one or many Operations which are the references toa concrete external web service
- B. REST Data Sources doesn't support any authentication
- C. Oracle APEX supports the REST Enabled SQL Query REST Data Source type
- D. Oracle APEX doesn't provide direct integration of REST Data Sources in interactivereports
正解：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]
質問 # 79
Which two feature pages can you create using the Create Page Wizard?
- A. Access Control
- B. Feedback
- C. Unified Task List
- D. Search Page
正解：A、B
解説：
Explanation
The feature pages that can be created using the Create Page Wizard are About Page, Access Control, Activity Reporting, Configuration Options, Email Reporting, Feedback, Login Page, and Theme Style Selection. These pages provide application-level functionality that can be added to an existing application. Search Page and Unified Task List are not feature pages that can be created using the Create Page Wizard. Verified References: Managing Feature PagesFeature Page Types
質問 # 80
Which statement is true about the Link Column attribute of an interactive report?
- A. It is not possible to exclude Link Column.
- B. If you select Link Column, it is always displayed as the last column in the report.
- C. A Link Column cannot be sorted, hidden, or moved by an end user.
- D. It is not possible to include a custom target in Link Column
正解：C
解説：
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.
質問 # 81
Which three are the main components of APEX workspace homepage?
- A. Gallery
- B. RESTful Services
- C. SQL Workshop
- D. App Builder
正解：A、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]
質問 # 82
Which two functions can be used by an end user when pivoting an interactive report?
- A. Minimum
- B. list aggregate
- C. List aggregate
- D. Rank
- E. Median
正解：A、D
解説：
Explanation
When pivoting an interactive report, you can use different functions to aggregate or summarize the data in the pivot table. Some of the available functions are Minimum, Maximum, Average, Sum, Count, Median, and Rank. Minimum returns the smallest value in a set of values. Rank returns the rank of each value in a group of values. Verified References: 56
質問 # 83
......
Oracle 1Z0-770試験に合格した候補者は、Oracle APEX Developer Professional認定を受けることができます。この認定は世界的に認められており、Oracle APEX開発の専門知識を潜在的な雇用主に示すために使用することができます。さらに、この認定は2年ごとに更新する必要があり、最新のAPEX開発の変更やトレンドについて常に最新情報を得る必要があります。結論として、Oracle 1Z0-770（Oracle APEX Developer Professional）試験は、Oracle APEX開発の専門家を認定するために設計された業界標準の認定試験であり、真剣にOracle APEX開発者としてキャリアアップを目指す人にとって不可欠な部分です。
無料ダウンロードOracle 1Z0-770リアルな試験問題で合格しよう：https://www.jpntest.com/shiken/1Z0-770-mondaishu
1Z0-770試験問題集、1Z0-770練習テスト問題：https://drive.google.com/open?id=1IxtuinzwmovMUUG5JwBOG8Zn7QiVhTkL