[2025年09月] 最新のApplication Development 1Z1-771試験解答豪華セット問題集 [Q18-Q41]

[2025年09月] 最新のApplication Development 1Z1-771試験解答豪華セット問題集

Oracleコンテンツをマスターして1Z1-771試験合格保証つき問題集！

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

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

正解：A

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

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

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

正解：A、C

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

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

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

正解：A

解説：
Regenerating Push Notification credentials updates the VAPID keys (public/private pair) in the PWA settings:
A . Existing Push Subscriptions invalidated: Subscriptions (in APEX_APPL_PUSH_SUBSCRIPTIONS) are tied to the old keys. New keys break this link, requiring users to re-subscribe (e.g., via browser prompts), as the push service (e.g., Firebase) can't authenticate old subscriptions.
B . New notification server: False; the server configuration remains; only credentials change.
C . Disabled for the app: False; notifications remain enabled but won't work for old subscriptions until re-established.
Technical Insight: Regeneration updates APEX_PWA_VAPID_PUBLIC_KEY and APEX_PWA_VAPID_PRIVATE_KEY, triggering a subscription refresh cycle.
Use Case: Security breach requires key rotation.
Pitfall: Users must re-opt-in, potentially losing some subscribers.

質問 # 21
Which two tasks can be performed by using the Generate Text with AI Dynamic Action?

• A. Draft an email
• B. Invoke a Workflow
• C. Summarize or translate text
• D. Update the underlying database tables

正解：A、C

解説：
The "Generate Text with AI" Dynamic Action uses Generative AI to:
Draft an email: Creates text content like emails based on prompts.
Summarize or translate text: Processes existing text to summarize or translate it.
It does not update database tables or invoke workflows, as it's focused on text generation.

質問 # 22
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. GET
• B. POST
• C. PUT

正解：C

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

質問 # 23
What do you achieve by performing the "Refresh Working Copy" task?

• A. Merge the Working Copy changes with the Main application.
• B. Update the changes from one Working Copy to another.
• C. Get the latest updates from the Main application.

正解：C

解説：
Working Copies in APEX allow safe experimentation:
C . Get the latest updates from the Main application: "Refresh Working Copy" (in App Builder > Working Copies) pulls changes from the Main application into the Working Copy, ensuring it reflects the latest state (e.g., new pages, fixes) without overwriting Working Copy changes.
A . Merge with Main: Merging is a separate "Merge Working Copy" task.
B . Update between Working Copies: Not supported; refreshing is Main-to-Working only.
Practical note: Use this to sync collaborative development efforts.

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

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

正解：B、D

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

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

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

正解：A、C

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

質問 # 26
Which is NOT an available Geometry Column data type for the map region?

• A. GeoJSON
• B. JSON OBJECT
• C. SDO_GEOMETRY
• D. Latitude/Longitude

正解：B

解説：
The Map Region in APEX supports spatial data via:
GeoJSON: A JSON-based standard for geographic data (e.g., points, polygons).
SDO_GEOMETRY: Oracle's native spatial data type for storing geometry (e.g., SDO_GEOMETRY(2001, 4326, SDO_POINT_TYPE(-122, 37, NULL), NULL, NULL)).
Latitude/Longitude: Separate columns for lat/long coordinates, mapped to points.
JSON OBJECT: Not a supported geometry type; while JSON can store data, it's not a specific spatial format recognized by the Map Region without GeoJSON structure.
This ensures compatibility with Oracle Spatial and common GIS standards.

質問 # 27
Which two actions are performed by using the Object Browser?

• A. Restore dropped database objects.
• B. Browse database objects of the current schema.
• C. Create and run SQL scripts.
• D. Create a lookup table based on a column in the current table.

正解：B、D

解説：
Object Browser in SQL Workshop is a GUI for managing schema objects:
B . Browse database objects of the current schema: Displays tables, views, procedures, etc., in a tree view, allowing inspection of definitions (e.g., columns, constraints) and data previews.
D . Create a lookup table based on a column in the current table: From a table's column (e.g., DEPTNO), you can generate a lookup table (e.g., DEPT_LOOKUP) with unique values, automating reference table creation.
A . Restore dropped objects: Not supported; this requires DBA tools (e.g., FLASHBACK TABLE).
C . Create and run SQL scripts: This is a SQL Scripts feature, not Object Browser.
Practical tip: Use "Create Lookup Table" to normalize data efficiently.

質問 # 28
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.

質問 # 29
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).

質問 # 30
Which API can be used to send Push Notifications immediately in Oracle APEX?

• A. APEX_PWA.HAS_PUSH_SUBSCRIPTION
• B. APEX_PWA.PURGE_QUEUE
• C. APEX_PWA.PUSH_QUEUE

正解：C

解説：
The APEX_PWA package manages Push Notifications:
B . APEX_PWA.PUSH_QUEUE: This procedure forces immediate processing of the Push Notification queue, sending queued messages (added via APEX_PWA.SEND) to subscribed devices without waiting for the default scheduler (e.g., every 5 minutes). Example: APEX_PWA.PUSH_QUEUE; ensures a "Meeting now!" alert goes out instantly.
A . APEX_PWA.HAS_PUSH_SUBSCRIPTION: Checks if a user has an active subscription (returns BOOLEAN), not for sending.
C . APEX_PWA.PURGE_QUEUE: Clears the queue, discarding unsent messages, not sending them.
Technical Insight: PUSH_QUEUE triggers a job to contact the push service (e.g., Firebase), using VAPID keys from the PWA configuration.
Use Case: Urgent alerts (e.g., system outage) need immediate delivery, bypassing delays.
Pitfall: Overuse can strain the server; use judiciously for time-sensitive messages.

質問 # 31
There is a validation of type Item is Numeric on the P1_SALARY item. When the page is submitted, this error message is displayed both as a notification and inline with the item. What will cause the validation error to appear only in the Notification area?

• A. Setting Value Required to Yes on P1_SALARY.
• B. Removing P1_SALARY from the validation Associated Item.
• C. Setting Display Location to Inline in Notification

正解：C

解説：
Validation errors in APEX default to both inline (next to the item) and notification (top of page):
C . Setting Display Location to Inline in Notification: In the validation's properties, changing "Display Location" to "Inline in Notification" ensures the error appears only in the notification area, suppressing inline display. This centralizes feedback for a cleaner UI.
A . Removing Associated Item: Breaks the validation's link to P1_SALARY, stopping it entirely.
B . Value Required: Adds a separate check, unrelated to display location.
Pitfall: Test with non-numeric input (e.g., "abc") to confirm behavior.

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

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

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

質問 # 33
You created a custom theme for an application. Examine these requirements: (Assuming requirements mandate syncing changes). Which solution guarantees that any changes to the master theme are reflected in the copied theme?

• A. Copying the changes made in the master theme to the copied theme.
• B. Verifying the theme subscription.
• C. Refreshing the templates.
• D. Subscribing the copied theme to the master theme and refreshing the theme.

正解：D

解説：
Theme subscription links a copied theme to its master:
A . Subscribing and refreshing: Subscribing the copied theme (in Shared Components > Themes) to the master ensures it inherits updates. "Refresh Theme" (via Theme Roller or Utilities) syncs changes (e.g., CSS, templates) from the master, guaranteeing consistency.
B . Refreshing templates: Only updates individual templates, not the entire theme.
C . Copying changes: Manual, error-prone, and not guaranteed.
D . Verifying subscription: Confirms the link but doesn't sync changes.
Use case: Ideal for maintaining branded consistency across apps.

質問 # 34
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.

質問 # 35
Which client credentials are used for authentication during the 'Check Syntax' process?

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

正解：C

解説：
The "Check Syntax" process in APEX, typically used in SQL Workshop or when validating code, authenticates using Database schema credentials. These are the credentials of the schema associated with the APEX workspace (e.g., username/password of the schema like "HR"). This ensures the process has access to parse and validate SQL or PL/SQL against the database objects in that schema.
APEX Workspace Admin credentials: These are for managing workspaces, not executing database-level syntax checks.
APEX Developer credentials: These authenticate developers into the APEX IDE, not the database runtime environment.
This design aligns with APEX's security model, where database operations are tied to the schema, ensuring accurate validation and error reporting (e.g., missing privileges or invalid objects).

質問 # 36
At what level does a developer enable push notifications so that end users can receive them on their devices from an APEX application?

• A. Page
• B. Instance
• C. Region
• D. Application

正解：D

解説：
Push notifications in Oracle APEX are enabled at the application level. This allows the application to register with the Progressive Web App (PWA) framework and manage subscriptions for all end users. Once enabled in the Application Definition under "Progressive Web App" settings, APEX handles the subscription process, and developers can use APIs like APEX_PWA.SEND to send notifications. Enabling at the region, page, or instance level is not supported for this feature.

質問 # 37
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.

質問 # 38
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).

質問 # 39
Which two approaches can be used to create custom stored procedures in SQL Workshop?

• A. Using SQL Scripts
• B. Using Object Browser
• C. Using Data Workshop
• D. Using Quick SQL

正解：A、B

解説：
In SQL Workshop, custom stored procedures can be created using:
SQL Scripts: Allows developers to write and execute PL/SQL code directly to define stored procedures.
Object Browser: Provides a GUI to create and edit database objects, including stored procedures, by defining their specifications and bodies.
Quick SQL is for generating table DDL, not stored procedures, and Data Workshop is for loading/unloading data, not creating procedures.

質問 # 40
......

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

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

 

あなたを合格させるOracle 1Z1-771試験専門問題集はここにある：https://jp.fast2test.com/1Z1-771-premium-file.html