[2025年最新] 高合格率な最新無料1Z0-771試験問題集アンサーを使おう [Q33-Q57]

[2025年最新] 高合格率な最新無料1Z0-771試験問題集アンサーを使おう

1Z0-771知能問題集PDF！Oracle 1Z0-771試験問セット

Oracle 1Z0-771 認定試験の出題範囲：

トピック	出題範囲
トピック 1	アプリケーションデータの管理：このセクションでは、データエンジニアがアプリケーションデータを処理するための専門知識を評価します。コレクションの使用、REST対応SQL参照の管理、RESTデータソースの統合、異なる環境間でのデータ同期などについて扱います。
トピック 2	テーマとテーマスタイルの使用：このセクションでは、UIデザイナーがアプリケーションにビジュアルテーマを適用する能力をテストします。テーマの選択とカスタマイズ、Theme Rollerを使用したデザイン調整、そして一貫したブランディングのためのテンプレートコンポーネントの作成などが含まれます。
トピック 3	プログレッシブウェブアプリの作成：このセクションでは、プログレッシブウェブアプリ（PWA）の構築におけるウェブ開発者のスキルを評価します。アプリケーションのアクセシビリティ向上、プッシュ通知の実装、そしてシームレスなクロスデバイスエクスペリエンスのためのアプリケーションの最適化などが含まれます。
トピック 4	ページと領域の管理：このセクションでは、UIデザイナーがアプリケーションレイアウトを構築する際の知識を評価します。さまざまな種類のページと領域の作成、Page Designer内でのページコンポーネントの管理、アプリケーションのユーザーインターフェースの最適化などについて学びます。
トピック 5	SQL Workshopの使用：このセクションでは、SQL Workshopを用いたデータベースオブジェクトの管理におけるデータベース開発者の専門知識を評価します。データベース構造の作成と変更、SQLコマンドとスクリプトの実行、そしてData Workshopユーティリティによる効率的なデータのロードとアンロードによるデータベース操作の簡素化などが含まれます。
トピック 6	アプリケーションページコントロールの作成：このセクションでは、フロントエンド開発者がインタラクティブなページ要素を実装する能力をテストします。APEXアプリケーション内のナビゲーションとユーザーインタラクションを強化するページレベルのアイテム、ボタン、コントロールの作成が含まれます。
トピック 7	動的アクションとプラグインの作成と使用：このセクションでは、開発者が動的アクションを実装する専門知識をテストします。イベント駆動型の動作の設定とプラグインの統合により、レスポンシブでインタラクティブなアプリケーション機能を作成する方法を網羅します。
トピック 8	Oracle APEXにおける生成AIの活用：このセクションでは、APEXアプリケーションにAIを活用した機能を統合するためのAI開発者の知識をテストします。APEXアシスタントを使用したコード生成、AI駆動型データモデルの作成、動的アクションを使用したAIを活用したテキスト生成の実装などが含まれます。
トピック 9	フォームの作成と使用：このセクションでは、フォーム開発者がユーザーフレンドリーなフォームを設計する能力を評価します。インタラクティブグリッドの作成、レポートにリンクされたシンプルなフォームの開発、効果的なデータ管理のためのマスター詳細フォームの実装などを網羅します。
トピック 10	アプリケーションへのナビゲーションの実装：このセクションでは、スムーズなアプリケーションナビゲーションを設計するUXデザイナーのスキルを評価します。共有コンポーネントの設定、検索機能の設定、直感的なナビゲーション構造によるユーザーエクスペリエンスの向上などが含まれます。
トピック 11	アプリケーション機能の拡張：このセクションでは、APEX開発者のアプリケーション機能拡張スキルを評価します。自動メールの送信、プラグインの実装、自動化機能の活用による効率性の向上と機能拡張などが含まれます。
トピック 12	アプリケーションへのページの追加：このセクションでは、アプリケーション開発者がアプリケーションの機能を拡張するスキルを評価します。Oracle JETのチャート、カレンダー、ツリー、マップを作成し、データの視覚化とユーザーインタラクションを強化するスキルが含まれます。
トピック 13	アプリケーションへのセキュリティの実装：このセクションでは、APEXアプリケーションのセキュリティ確保に関するセキュリティスペシャリストの知識を評価します。アプリケーションのセキュリティとユーザーアクセス管理を確保するための認証スキーム、認可制御、セッションステート保護について解説します。
トピック 14	APEXアプリケーションの作成：このセクションでは、アプリケーション開発者がAPEXアプリケーションを構築する能力をテストします。既存のテーブルや外部ファイルからアプリケーションを作成することに重点を置き、App Builderツールとアプリケーション開発におけるその役割に関する基本的な理解を深めます。
トピック 15	Oracle Autonomous DatabaseにおけるOracle APEX入門：このセクションでは、Oracle APEXとそのコアコンポーネントを理解するAPEX開発者のスキルを評価します。ワークスペースの作成と管理を網羅し、APEXがOracle Autonomous Databaseと統合してアプリケーション開発を効率化する方法の概要を示します。
トピック 16	計算、プロセス、検証、および分岐の追加：このセクションでは、バックエンド開発者がアプリケーションロジックを実装する知識を測定します。ワークフローを自動化し、データの整合性を確保するために、計算、プロセス、検証、およびページ分岐を構成することに重点を置いています。

 

質問 # 33
In which two formats can the GetCurrentPosition Dynamic Action in Oracle APEX return coordinates?

• A. GeoJSON
• B. Function Body returning SQL Query
• C. State and Pincode
• D. Latitude and Longitude

正解：A、D

解説：
The GetCurrentPosition Dynamic Action retrieves geolocation data from the user's device. It supports:
Latitude and Longitude: Returns coordinates as separate numeric values (e.g., lat: 37.7749, lon: -122.4194).
GeoJSON: Returns coordinates in a structured JSON format compliant with the GeoJSON standard (e.g., { "type": "Point", "coordinates": [-122.4194, 37.7749] }).
Function Body returning SQL Query is a dynamic action type, not a coordinate format, and State and Pincode is unrelated to geolocation coordinates.

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

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

正解：B

解説：
The Data Workshop utility in APEX is designed to load and unload table data only, not other schema objects like procedures or views. Option A is false because XLSX files with multiple worksheets are supported (each worksheet can be mapped to a table). Option B is incorrect as it's limited to table data. Option D is partially true but not the most precise answer, as "multiple tables at a time" depends on the process, whereas C is universally accurate.

質問 # 35
Which two statements are true about creating and managing an APEX Workspace?

• A. New schemas cannot be created during workspace creation.
• B. During workspace creation, you can associate the workspace with an existing database schema.
• C. You can create only two workspaces in an APEX Service (APEX Application Development) instance.
• D. A workspace can be associated with only one schema.

正解：A、B

解説：
APEX Workspaces define development environments tied to database schemas:
A . During workspace creation, you can associate the workspace with an existing database schema: In the Workspace creation wizard (via Instance Administration), you select an existing schema (e.g., "HR") to link, enabling access to its objects. This is a standard step, ensuring immediate usability.
B . New schemas cannot be created during workspace creation: APEX doesn't provide a UI to create schemas here; schemas must pre-exist in the database, created via SQL (e.g., CREATE USER).
C . A workspace can be associated with only one schema: False; a workspace can associate with multiple schemas post-creation via "Manage Workspace to Schema Assignments." D . You can create only two workspaces: False; the limit depends on the APEX instance configuration (e.g., cloud service tier), not a fixed number like two.
Use case: Associating existing schemas is key for leveraging pre-built databases.

質問 # 36
In a faceted search page, facets can be displayed as different UI types. Which two facet item types are supported in the faceted search region?

• A. Checkbox Group
• B. Date Picker
• C. Range
• D. Popup LOV

正解：A、C

解説：
In Oracle APEX, a faceted search page allows users to filter data using facets, which are displayed as UI components in the Faceted Search region. According to the Oracle APEX documentation, the supported facet item types include:
Range: Used for numeric or date ranges, allowing users to filter data within a specified range (e.g., salary or hire date).
Checkbox Group: Used for multi-select options, enabling users to select multiple values from a list (e.g., departments).
Other types like Popup LOV and Date Picker are valid item types in APEX but are not natively supported as facet types in the Faceted Search region. Popup LOV is typically used for single-value selection in forms, and Date Picker is a standalone item type, not a facet-specific UI.

質問 # 37
You have defined a REST Data Source with ORDS as the REST Data Source Type. The Source is being used as source for an editable Interactive Grid. When a user updates an employee record in this Interactive Grid, which operation is performed on the Database?

• A. POST
• B. PUT
• C. GET

正解：B

解説：
An editable Interactive Grid synced with a REST Data Source (ORDS) maps CRUD operations to HTTP methods:
C . PUT: Updates an existing resource. When a user edits a row (e.g., changes SALARY), the grid sends a PUT request to the ORDS endpoint (e.g., /employees/101), updating the corresponding record.
A . POST: Creates new records, used for inserts, not updates.
B . GET: Retrieves data, used for initial grid population, not updates.
Technical note: ORDS maps PUT to an update operation on the underlying table, requiring the REST endpoint to support this method.

質問 # 38
Which two SQL format options does the APEX Assistant provide when using the "Create Data Model using AI" feature?

• A. Quick SQL
• B. Oracle SQL
• C. MySQL
• D. Oracle PL/SQL

正解：A、B

解説：
The "Create Data Model using AI" feature in APEX Assistant leverages AI to generate data models based on natural language input. The supported SQL format options are:
Quick SQL: A shorthand syntax for defining database objects, which APEX can convert into full DDL.
Oracle SQL: Standard SQL syntax compatible with Oracle Database for creating tables and other objects.
MySQL is not supported as it's specific to a different database system, and Oracle PL/SQL is a procedural language, not a format for defining data models in this context.

質問 # 39
What are two reasons to enable the "Used by App Builder" option while creating a Generative AI Server?

• A. To create a Working Copy of your application
• B. To build applications using natural language powered by Generative AI
• C. To create a REST-enabled database object
• D. To author SQL powered by Generative AI

正解：B、D

解説：
Enabling "Used by App Builder" for a Generative AI Server allows:
Author SQL powered by Generative AI: Integrates AI-driven SQL generation in App Builder.
Build applications using natural language: Enables natural language prompts to create app components.
Options A and B are unrelated to this setting, as it's specific to AI integration in App Builder.

質問 # 40
You must create a single master detail page where users can select a row in the master region and see the corresponding details in the detail region. Users must also interact with the master or the detail without leaving the page. Which type of master detail implementation should you use?

• A. Drill Down
• B. Side by Side
• C. Stacked

正解：B

解説：
Master-detail pages in APEX link a master dataset (e.g., list of orders) to its details (e.g., order items). The requirements demand:
C . Side by Side: This layout places the master region (e.g., an Interactive Report) and detail region (e.g., a Form or Grid) horizontally on the same page. Selecting a master row updates the detail region via AJAX, allowing interaction with both regions without navigation. It's ideal for workflows needing simultaneous visibility (e.g., editing details while browsing masters).
A . Drill Down: Master links to a separate detail page, requiring navigation, which violates the "without leaving the page" condition.
B . Stacked: Master and detail are vertically stacked, but interaction is less fluid than side-by-side due to scrolling, though still on one page. Side-by-side is preferred for its clarity and accessibility.
Pitfall: Ensure the detail region's "Server-side Condition" uses the master's selected key (e.g., P1_ID).

質問 # 41
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 is selected?

• 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.

正解：A

解説：
By default, faceted search can "batch" changes, requiring an "Apply" button click to filter the report. To enable automatic filtering:
Disable the Batch Facet Changes attribute: In Page Designer, under the Faceted Search region's Attributes, setting "Batch Facet Changes" to "No" ensures the report refreshes immediately when a facet value is selected, improving responsiveness. This triggers an AJAX call to update the report without a manual submit.
Show Facet Name: This controls facet label visibility, unrelated to filtering behavior.
Client-Side Filtering: This applies to Interactive Reports/Grids, not faceted search regions, and isn't the correct solution here.
This adjustment enhances the user experience by providing instant feedback.

質問 # 42
What happens when you regenerate credentials for Push Notifications in Oracle APEX?

• A. Push Notifications will be disabled for the application.
• B. A new notification server must be created.
• C. Existing Push Subscriptions for the application will be invalidated.

正解：C

質問 # 43
Which two Query Source types can be used to create a dynamic LOV?

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

正解：A、B

解説：
A dynamic List of Values (LOV) in APEX populates options based on a query source. The supported types include:
Function Returning SQL Query: A PL/SQL function that returns a SQL query string (e.g., RETURN 'SELECT ename, empno FROM emp';). This offers flexibility for dynamic conditions or complex logic.
SQL Query: A direct SQL statement (e.g., SELECT ename, empno FROM emp) executed at runtime to fetch LOV values. It's the simplest and most common approach.
Procedure: Procedures execute logic but don't return query results in the format required for an LOV (they don't produce a result set directly).
Select List: This is a UI component, not a query source type for defining an LOV.
Dynamic LOVs enhance user interaction by providing real-time, data-driven options, critical for forms and filters.

質問 # 44
An APEX e-commerce application is being used by 50 users. You have a promotional offer, and you need to send a push notification to all the subscribed users on their devices. Which step must be performed in Oracle APEX to achieve this?

• A. Create a Dynamic Action of Send Push Notification type to send push notifications to all the subscribed users.
• B. Create a REST Data Source to send push notifications to all the subscribed users.
• C. Enable push notifications at the application level and let APEX handle the subscription and delivery process automatically.
• D. Create a PL/SQL block to fetch all the subscribed users and send push notifications by using APEX_APPL_PUSH_SUBSCRIPTIONS & APEX_PWA.SEND.

正解：D

解説：
To send push notifications to all subscribed users, you must:
Enable push notifications at the application level (a prerequisite).
Use a PL/SQL block with APEX_APPL_PUSH_SUBSCRIPTIONS to fetch subscribers and APEX_PWA.SEND to send the notifications.
Option A is incorrect as there's no "Send Push Notification" Dynamic Action type. Option B is incomplete as enabling alone doesn't send notifications. Option C is unrelated to push notifications.

質問 # 45
Which three statements are true about Data Workshops in Oracle APEX?

• A. You can load data into a new or existing table.
• B. You can load or unload multiple tables at a time.
• C. You can load or unload a single table at a time.
• D. You can unload data from a new or existing table.

正解：A、C、D

解説：
Data Workshop in SQL Workshop is a powerful tool for importing/exporting table data:
B . You can load or unload a single table at a time: The wizard focuses on one table per operation. For loading, you upload a file (e.g., CSV) and map it to a single table; for unloading, you select one table to export (e.g., EMP to CSV). This granularity ensures precision and simplicity.
C . You can unload data from a new or existing table: Unloading (exporting) works on any table in the schema, whether newly created (e.g., via Quick SQL) or pre-existing (e.g., DEPT). The "Unload" option generates a file (e.g., CSV, JSON) from the table's data.
D . You can load data into a new or existing table: Loading supports creating a new table from the uploaded file (e.g., CSV defines NEW_EMP) or appending/overwriting an existing one (e.g., EMP). The wizard prompts for table creation or selection.
A . You can load or unload multiple tables at a time: False; Data Workshop processes one table per wizard run. Multiple tables require separate operations or custom SQL scripts.
Technical Insight: Loading uses APEX_DATA_LOADING internally, parsing files into rows, while unloading leverages APEX_DATA_EXPORT. For example, uploading emp.csv with "Create New Table" generates a table with inferred columns.
Use Case: Migrating EMP data from a legacy system (CSV) into APEX, then exporting it later for analysis.
Pitfall: Multi-table operations need SQL Scripts or external tools like SQL Developer.

質問 # 46
Which three Theme Components are available out-of-the-box with the Universal Theme?

• A. REST Data Sources
• B. Badge
• C. Calendar
• D. Comments

正解：B、C、D

解説：
The Universal Theme (Theme 42) provides pre-built components:
A . Calendar: A region type for date-based displays (e.g., events), styled with Universal Theme templates (e.g., FullCalendar integration).
B . Comments: A region type for user feedback or notes, with built-in styling and moderation options.
C . Badge: A UI component for displaying counts or statuses (e.g., "5 New"), often in navigation or lists, styled via CSS classes.
D . REST Data Sources: A data feature, not a theme component; it's a Shared Component, not a UI element tied to Universal Theme.
Technical Insight: These components leverage Universal Theme's CSS (e.g., t-Badge, t-Calendar) and JavaScript for interactivity, reducing custom coding.
Use Case: A dashboard with a Calendar for schedules, Comments for feedback, and Badges for unread alerts.
Pitfall: Customizing requires Theme Roller or CSS overrides.

質問 # 47
Which two declarative options in Oracle APEX allow you to download BLOB/CLOB content?

• A. Download Dynamic Action
• B. APEX_UTIL.DOWNLOAD PL/SQL API
• C. Share Dynamic Action
• D. Download Page Process

正解：A、D

解説：
Declarative options for downloading BLOB/CLOB content include:
Download Dynamic Action: A built-in action type to trigger downloads of BLOB/CLOB data.
Download Page Process: A process type that declaratively handles BLOB/CLOB downloads from a table.
APEX_UTIL.DOWNLOAD is a PL/SQL API, not a declarative option, and Share Dynamic Action is for sharing URLs, not downloading files.

質問 # 48
You use the Create Page Wizard to create a faceted search page on the EMP table. What is the default report type generated for this page?

• A. Interactive Grid
• B. Column Toggle Report
• C. Classic Report
• D. Interactive Report

正解：D

解説：
When creating a faceted search page via the Create Page Wizard, the default report type is an Interactive Report. This pairs with the faceted search region to provide a searchable, filterable, and customizable report, leveraging the facets for dynamic filtering.

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

• A. apex_automation.log_info ('SAL for ' || :ENAME || ' increased by 19.');
• B. apex_debug.info ('SAL for :ENAME ||' increased by 19.');
• C. apex_error.add_error ('SAL for ' || :ENAME || ' increased by 19.');

正解：A

解説：
Logging in APEX tracks runtime activity:
A . apex_automation.log_info: Correctly logs an informational message to the execution log for automation tasks (e.g., workflows). The syntax || :ENAME || concatenates the item value (e.g., "JOHN") into "SAL for JOHN increased by 19." It's stored in APEX_AUTOMATION_LOG, viewable in Monitoring.
B . apex_debug.info: Logs to debug output, but the syntax is flawed (:ENAME || isn't concatenated properly; should be 'SAL for ' || :ENAME || ...). It's valid only when debugging is enabled (e.g., APEX_DEBUG.ENABLE).
C . apex_error.add_error: Adds an error to the error stack for user display, not a log message.
Technical Insight: log_info is non-intrusive, unlike apex_debug, which requires debug mode, or apex_error, which signals failure.
Use Case: Logging salary updates in a scheduled job without debug overhead.
Pitfall: Ensure :ENAME is in scope (e.g., page item).

質問 # 50
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 is selected?

• 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.

正解：A

解説：
By default, faceted search can "batch" changes, requiring an "Apply" button click to filter the report. To enable automatic filtering:
Disable the Batch Facet Changes attribute: In Page Designer, under the Faceted Search region's Attributes, setting "Batch Facet Changes" to "No" ensures the report refreshes immediately when a facet value is selected, improving responsiveness. This triggers an AJAX call to update the report without a manual submit.
Show Facet Name: This controls facet label visibility, unrelated to filtering behavior.
Client-Side Filtering: This applies to Interactive Reports/Grids, not faceted search regions, and isn't the correct solution here.
This adjustment enhances the user experience by providing instant feedback.

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

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

正解：B、D

解説：
Authorization Schemes in APEX can be evaluated at:
Once per page view: Checks authorization each time a page is rendered.
Once per session: Checks once per user session, caching the result.
Once per user and Never are not valid evaluation points in the Authorization Scheme settings.

質問 # 52
Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?

• A. Create a database link to the remote Oracle Database in the local APEX schema.
• B. Install Oracle APEX in the remote Oracle Database.
• C. REST-enable the schema in the remote Oracle Database by using ORDS.ENABLE_SCHEMA.
• D. Install ORDS 19.x or later on the remote Oracle Database.

正解：C、D

解説：
To use REST-enabled SQL in APEX:
Install ORDS 19.x or later: Oracle REST Data Services (ORDS) must be installed and configured on the remote database.
REST-enable the schema: The schema on the remote database must be REST-enabled using ORDS.ENABLE_SCHEMA to allow SQL execution via REST.
A database link is not required, and installing APEX on the remote database is unnecessary since REST-enabled SQL connects APEX to a remote schema via ORDS.

質問 # 53
Which statement is true about the Link Column attributes of an Interactive Report?

• A. It is not possible to exclude Link Column.
• B. It is not possible to include a custom target in 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.

正解：A

解説：
The Link Column in an Interactive Report adds a clickable link to each row. The true statement is:
It is not possible to exclude Link Column: Once defined in the report attributes, the Link Column is mandatory and cannot be hidden or excluded via end-user controls (e.g., Column Management). It's always rendered unless removed by the developer.
Custom target: False; custom targets (e.g., URLs, pages) can be defined.
Always last column: False; its position is configurable.
Cannot be sorted/hidden/moved: False; end users can sort or move it, though hiding is restricted.
This behavior ensures consistent navigation in reports.

質問 # 54
Which search type in keywords do they represent in Oracle Text?

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

正解：A

解説：
In Oracle APEX, when configuring search functionality (e.g., in reports or faceted search), "Oracle Text" refers to a specific search type leveraging the Oracle Text engine. This is a powerful full-text search capability built into Oracle Database, supporting keyword-based searches, fuzzy matching, and indexing.
Standard: A basic SQL-based search (e.g., LIKE), not tied to Oracle Text.
List: Not a search type; it might refer to a UI component or LOV, not a search mechanism.
Oracle Text: Explicitly uses the CONTAINS operator and text indexes (e.g., CONTEXT or CTXCAT) for advanced search features, ideal for large datasets or complex queries.
This choice impacts performance and accuracy, especially in text-heavy applications.

質問 # 55
......

Oracle 1Z0-771問題集PDFを使ってベストオプションを目指そう：https://www.jpntest.com/shiken/1Z0-771-mondaishu

2025年最新の1Z0-771サンプル問題は頼もしい1Z0-771テストエンジン：https://drive.google.com/open?id=1DM0rr62Tzv8XNWQncHc0HVxW7eHltht4