合格させる1Z0-771ブレーン問題集で更新されたのは認定サンプル問題
オンライン1Z0-771テストブレーン問題集とテストエンジン
Oracle 1Z0-771 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
| トピック 6 |
|
| トピック 7 |
|
| トピック 8 |
|
| トピック 9 |
|
| トピック 10 |
|
| トピック 11 |
|
| トピック 12 |
|
質問 # 19
Which statement is true about Theme Styles?
- A. The "Is Current" attribute of a Theme Style depends on the "Read Only" attribute.
- B. Theme Styles control the layout of a webpage.
- C. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.
正解：C
解説：
Theme Styles define visual themes in APEX:
A . When the Is Public attribute is enabled: Setting "Is Public" to "Yes" in Shared Components > Theme Styles allows runtime selection (e.g., via a dropdown in the app UI), letting users switch between styles (e.g., "Vita" to "Vita - Dark").
B . Control layout: False; layout is managed by templates and regions; Theme Styles handle colors, fonts, etc.
C . "Is Current" depends on "Read Only": False; "Is Current" marks the default style, independent of "Read Only" (which locks editing).
Technical Insight: Public styles require multiple defined styles and a UI component (e.g., Dynamic Action) to expose the switcher.
Use Case: Offering light/dark mode options to users.
Pitfall: Without a switcher, "Is Public" has no visible effect.
質問 # 20
Which component of the Push Notifications feature stores the messages that are ready to be sent?
- A. Subscription
- B. Application
- C. Queue
正解：C
解説：
Push Notifications in Oracle APEX enable real-time messaging to users' devices via Progressive Web App (PWA) capabilities. The component responsible for storing messages is:
A . Queue: The Push Notification Queue (managed internally by APEX and accessible via APIs like APEX_PWA.PUSH_QUEUE) temporarily holds messages scheduled for delivery. When a notification is created (e.g., via APEX_PWA.SEND), it's added to this queue, awaiting processing by the APEX mail system or an external push service. The queue ensures reliable delivery, even if the user is offline temporarily, as messages are dispatched once connectivity is restored.
B . Application: The application defines the PWA settings and logic but doesn't store messages; it's the container, not the storage mechanism.
C . Subscription: Represents user device registrations (stored in APEX_APPL_PUSH_SUBSCRIPTIONS), not the messages themselves. Subscriptions link devices to the app for delivery, not queuing.
Technical Insight: The queue is a database-backed structure, leveraging Oracle's job scheduling (e.g., DBMS_SCHEDULER) to process entries. For example, calling APEX_PWA.SEND(p_message => 'Promo Alert!') adds an entry to the queue, which is then pushed to subscribed devices.
Use Case: A retail app queues a "Sale starts now!" message for 1,000 users, ensuring orderly delivery without overwhelming the server.
Pitfall: If the queue isn't periodically pushed (e.g., via APEX_PWA.PUSH_QUEUE), messages may delay.
質問 # 21
You have an Interactive Grid component and you are enabling the Save Report functionality. As what can end users save the report type?
- A. As Private and Public only
- B. As Primary
- C. As Private and Primary only
正解：A
解説：
In an Interactive Grid, the "Save Report" functionality allows end users to save customizations (e.g., filters, column order). The available options are:
Private: Saved for the individual user only, visible only to them.
Public: Saved and shared with all users of the application, if permitted by the developer.
Primary: This is a developer-defined default report, not an end-user save option. End users cannot overwrite the Primary report; they can only save as Private or Public (if enabled via the "Allow Public Reports" attribute).
This flexibility empowers users to personalize grids while allowing shared configurations, enhancing collaboration and usability.
質問 # 22
Which two tasks can be performed by using the Generate Text with AI Dynamic Action?
- A. Draft an email
- B. Summarize or translate text
- C. Update the underlying database tables
- D. Invoke a Workflow
正解：A、B
解説：
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.
質問 # 23
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 each facet and then in the Property Editor, turn on Client-Side Filtering.
- B. Navigate to the faceted search region Attributes, and turn off the Show Facet Name attribute.
- C. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute.
正解：C
解説：
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.
質問 # 24
Which client credentials are used for authentication during the 'Check Syntax' process?
- A. Database schema credentials
- B. APEX Developer credentials
- C. APEX Workspace Admin credentials
正解：A
解説：
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).
質問 # 25
You need to ensure that "How may I help you today?" is the first message displayed by the AI assistant. Which attribute of the Show AI Assistant Dynamic Action should be configured in the Property Editor to achieve this?
- A. AI Assistant Name
- B. Initial Prompt
- C. Welcome Message
正解：C
解説：
The Show AI Assistant Dynamic Action in Oracle APEX triggers the display of the AI Assistant interface. To customize the first message users see:
Welcome Message: This attribute in the Property Editor defines the initial text displayed when the AI Assistant appears. Setting it to "How may I help you today?" ensures this exact phrase greets users, enhancing user experience by setting a friendly tone. It's a static, developer-defined string, distinct from AI-generated responses.
Initial Prompt: This attribute defines the starting input or context sent to the AI model, not the visible message shown to users. It's typically hidden and used to guide the AI's behavior (e.g., "Act as a support agent").
AI Assistant Name: This sets the assistant's identity (e.g., "Alex"), displayed in the UI, but it's not the greeting message.
This configuration is critical for branding or guiding user interaction from the outset, and it's adjustable per dynamic action instance, offering flexibility across pages.
質問 # 26
Which statement is true about Theme Styles in Oracle APEX?
- A. The "Is Current" attribute of a Theme Style depends on the "Read Only" attribute.
- B. Theme Styles control the layout of a webpage.
- C. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.
正解：C
解説：
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.
質問 # 27
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. Classic Report
- B. Interactive Report
- C. Smart Filters
- D. Interactive Grid
正解：D
解説：
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.
質問 # 28
Which two SQL format options does the APEX Assistant provide when using the "Create Data Model using AI" feature?
- A. MySQL
- B. Quick SQL
- C. Oracle PL/SQL
- D. Oracle 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.
質問 # 29
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 PL/SQL block to fetch all the subscribed users and send push notifications by using APEX_APPL_PUSH_SUBSCRIPTIONS & APEX_PWA.SEND.
- C. Create a REST Data Source to send push notifications to all the subscribed users.
- D. Enable push notifications at the application level and let APEX handle the subscription and delivery process automatically.
正解：B
解説：
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.
質問 # 30
What are two reasons to enable the "Used by App Builder" option while creating a Generative AI Server?
- A. To author SQL powered by Generative AI
- B. To build applications using natural language powered by Generative AI
- C. To create a REST-enabled database object
- D. To create a Working Copy of your application
正解：A、B
解説：
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.
質問 # 31
Which statement is true about the Link Column attributes of an Interactive Report?
- A. If you select Link Column, it is always displayed as the last column in the report.
- B. It is not possible to include a custom target in Link Column.
- C. It is not possible to exclude Link Column.
- D. A Link Column cannot be sorted, hidden, or moved by an end user.
正解：C
解説：
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.
質問 # 32
Which three data types are supported by Oracle APEX Workflow parameters and item types?
- A. Image
- B. VARCHAR
- C. NUMBER
- D. CLOB
正解：B、C、D
解説：
Workflow parameters and page items in APEX support:
B . NUMBER: For numeric values (e.g., 123.45), used in calculations or IDs.
C . CLOB: For large text (e.g., descriptions), stored as character large objects.
D . VARCHAR: For variable-length strings (e.g., EMPLOYEE_NAME), capped at 4000 characters in most cases.
A . Image: Not a supported data type for parameters or items; images are handled as BLOBs or file uploads, not directly as a Workflow parameter type.
These types align with Oracle Database, ensuring robust data handling in workflows.
質問 # 33
Which two approaches can be used to create custom stored procedures in SQL Workshop?
- A. Using Object Browser
- B. Using SQL Scripts
- 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.
質問 # 34
Which statement is true about importing an existing application into your workspace?
- A. You cannot change the application ID during the import process.
- B. You cannot import an APEX application exported from the latest APEX version to an old APEX version.
- C. The import process does not import the supporting objects defined during the export.
正解：B
解説：
Importing an APEX application involves transferring its definition (exported as a .sql file):
C . You cannot import an APEX application exported from the latest APEX version to an old APEX version: APEX enforces backward compatibility limits. An app exported from 23.2 (latest features like AI Assistants) can't import into 19.2, as older versions lack support for newer metadata (e.g., APEX_AI tables). The import wizard checks the version and rejects incompatible files.
A . You cannot change the application ID: False; the import wizard prompts for a new ID if there's a conflict or if you choose to override.
B . Supporting objects not imported: False; if included in the export (via "Include Supporting Objects"), they're imported (e.g., tables, triggers), unless skipped explicitly.
Technical Insight: Export files contain a version check (e.g., apex_version := '23.2';), causing rejection if the target instance's APEX_VERSION is lower.
Use Case: Moving an app from a dev instance (23.2) to prod (23.2) works, but not to an outdated test instance (19.1).
Pitfall: Always match versions or upgrade the target instance first.
質問 # 35
Which two declarative options in Oracle APEX allow you to download BLOB/CLOB content?
- A. Download Dynamic Action
- B. Share Dynamic Action
- C. APEX_UTIL.DOWNLOAD PL/SQL API
- 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.
質問 # 36
......
リアルOracle 1Z0-771試験問題集には正解55問題と解答があります：https://jp.fast2test.com/1Z0-771-premium-file.html