[2025年11月25日]1Z1-771問題集完全版問題、試験学習ガイド [Q29-Q45]

[2025年11月25日]1Z1-771問題集完全版問題、試験学習ガイド

Application Development無料認定試験材料Fast2testからの55問題

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

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

 

質問 # 29
Which statement is true about Theme Styles in Oracle APEX?

• A. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.
• B. The "Is Current" attribute of a Theme Style depends on the "Read Only" attribute.
• C. Theme Styles control the layout of a webpage.

正解：A

解説：
Theme Styles define visual aspects (e.g., colors, fonts) in APEX:
B . When the Is Public attribute is enabled: Setting "Is Public" to "Yes" allows end users to select from available Theme Styles at runtime (e.g., via a UI switcher), enhancing customization.
A . Control the layout: False; layout is managed by templates and regions, not Theme Styles, which focus on aesthetics.
C . "Is Current" depends on "Read Only": False; "Is Current" marks the active style, independent of "Read Only" (which locks editing).
Practical note: Public styles require multiple defined styles in Shared Components.

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

質問 # 31
Which two statements are true about Oracle APEX?

• A. You can build interactive reporting apps based on data from disparate systems.
• B. APEX eliminates middle tier application logic.
• C. Running an APEX app needs client software.
• D. Application definition is not stored in the database.

正解：A、B

解説：
Key truths about Oracle APEX:
APEX eliminates middle tier application logic: APEX runs entirely within the Oracle Database, using PL/SQL and SQL for logic, bypassing traditional middle-tier servers (e.g., Java EE). This simplifies architecture and boosts performance.
You can build interactive reporting apps based on data from disparate systems: Via REST Data Sources, database links, or ORDS, APEX integrates data from external systems, enabling unified reporting (e.g., combining on-premises and cloud data).
Needs client software: False; APEX is web-based, requiring only a browser.
Application definition not stored in database: False; definitions are stored as metadata in the database (e.g., APEX_APPLICATIONS).
This reflects APEX's database-centric, low-code philosophy.

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

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

正解：A、B

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

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

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

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

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

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

正解：C

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

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

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

正解：C

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

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

• A. Summarize or translate text
• B. Invoke a Workflow
• C. Draft an email
• 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.

質問 # 37
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. Enable push notifications at the application level and let APEX handle the subscription and delivery process automatically.
• C. 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. Create a REST Data Source to send push notifications to all the subscribed users.

正解：C

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

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

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

正解：C

質問 # 39
You must use a Static Content region type to display messages about the employee of the month. Which text, when placed in this region, will display the message correctly?

• A. Join me in congratulating V('P1_ENAME') as the new employee of the month!
• B. Join me in congratulating: &P1_ENAME. as the new employee of the month!
• C. Join me in congratulating: P1_ENAME as the new employee of the month!
• D. Join me in congratulating & P1_ENAME. as the new employee of the month!

正解：B

解説：
Static Content regions display fixed text with substitution:
B . &P1_ENAME.: The &ITEM_NAME. syntax substitutes the value of P1_ENAME at runtime (e.g., "Join me in congratulating: John as..."), correctly rendering the item's value. The dot ensures proper parsing.
A . P1_ENAME: Treated as literal text, not substituted.
C . V('P1_ENAME'): A PL/SQL function, invalid in static content; it's for server-side code.
D . & P1_ENAME.: Space before P1_ENAME breaks substitution syntax.
Pitfall: Ensure P1_ENAME is populated (e.g., via a page process) to avoid blank output.

質問 # 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. Side by Side
• B. Stacked
• C. Drill Down

正解：A

解説：
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
Which two tasks can be performed by the APEX Assistant when you create an application using the "Create App using Generative AI" option?

• A. Create a Generative AI service.
• B. Update the App icon with a custom image.
• C. Create the application blueprint.
• D. Add a Dashboard page.

正解：C、D

解説：
The "Create App using Generative AI" feature in APEX Assistant leverages natural language processing to automate application creation. When invoked:
Create the application blueprint: APEX Assistant generates a foundational structure (blueprint) for the application, including pages, regions, and navigation, based on the user's natural language input (e.g., "Create an app to manage employees"). This blueprint serves as the starting point, which developers can refine.
Add a Dashboard page: The Assistant can interpret requests for specific page types, such as dashboards, and include them in the generated app. Dashboards typically feature charts, summaries, or key metrics, and this is a common task supported by the AI-driven creation process.
Create a Generative AI service: This is not a task performed during app creation; instead, it's a prerequisite configuration step done separately in the Instance Administration settings.
Update the App icon: While app icons can be customized manually post-creation, this is not an automated task performed by APEX Assistant during the generative process.
This feature streamlines development by interpreting intent and building functional components, saving significant time compared to manual creation.

質問 # 42
In your application, you want to display data in a searchable, customizable report that supports inline editing at runtime using the mouse or keyboard. Which report type will you create?

• A. Interactive Grid
• B. Classic Report
• C. Smart Filters
• D. Interactive Report

正解：A

解説：
An Interactive Grid is the report type that supports searchable, customizable data display with inline editing at runtime using mouse or keyboard. Interactive Reports are searchable and customizable but lack inline editing. Classic Reports are static, and Smart Filters is a component, not a report type.

質問 # 43
Which two AI Service Providers are supported by Oracle APEX?

• A. OCI Generative AI
• B. Jarvis
• C. OpenAI
• D. DOC Document Generator pre-built function

正解：A、C

解説：
Oracle APEX integrates with external AI service providers to power features like Generative AI and text generation. The supported providers are:
OpenAI: A widely recognized AI provider offering models like GPT, integrated via API keys for tasks such as text generation, summarization, or SQL authoring in APEX.
OCI Generative AI: Oracle Cloud Infrastructure's native AI service, optimized for Oracle ecosystems, providing secure, scalable AI capabilities directly within the OCI environment.
DOC Document Generator: This is not an AI service provider; it's a hypothetical or misnamed option unrelated to APEX's AI integration.
Jarvis: While a fictional AI (e.g., from Iron Man), it's not a real provider supported by APEX.
These integrations require configuration in the Instance Administration settings, including credentials and endpoints, enabling APEX to leverage cutting-edge AI for app development and runtime features.

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

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

正解：B、D

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

質問 # 45
......

1Z1-771試験の問題集簡単まとめ：https://jp.fast2test.com/1Z1-771-premium-file.html