100%無料Application Development 1Z1-771問題集PDFお試しサンプル認定ガイドカバー率
PDF試験材料2025年最新の実際に出る1Z1-771問題集
質問 # 12
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. Classic Report
- B. Interactive Grid
- C. Column Toggle 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.
質問 # 13
Which client credentials are used for authentication during the 'Check Syntax' process?
- A. APEX Developer credentials
- B. APEX Workspace Admin 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).
質問 # 14
Which two are valid evaluation points for Authorization Schemes?
- A. Once per page view
- B. Once per session
- C. Once per user
- D. Never
正解：A、B
解説：
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.
質問 # 15
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 & P1_ENAME. as the new employee of the month!
- B. Join me in congratulating V('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!
正解：C
解説：
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.
質問 # 16
Which two approaches can be used to create custom stored procedures in SQL Workshop?
- A. Using Object Browser
- B. Using Data Workshop
- C. Using SQL Scripts
- D. Using Quick SQL
正解：A、C
解説：
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.
質問 # 17
Which two tasks can be performed by using the Generate Text with AI Dynamic Action?
- A. Summarize or translate text
- B. Update the underlying database tables
- C. Draft an email
- D. Invoke a Workflow
正解：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.
質問 # 18
Which statement is true about importing an existing application into your workspace?
- A. You cannot change the application ID during the import process.
- B. The import process does not import the supporting objects defined during the export.
- C. You cannot import an APEX application exported from the latest APEX version to an old APEX version.
正解：C
解説：
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.
質問 # 19
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 REST Data Source 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 Dynamic Action of Send Push Notification type 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.
質問 # 20
Which three statements are true about Data Workshops in Oracle APEX?
- A. You can load or unload a single table at a time.
- B. You can unload data from a new or existing table.
- C. You can load or unload multiple tables at a time.
- D. You can load data into a new or existing table.
正解：A、B、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.
質問 # 21
How many instances of a Workflow can exist in the "In Development" state?
- A. Unlimited
- B. 0
- C. 1
正解：B
解説：
In Oracle APEX Workflow, only one instance of a workflow can exist in the "In Development" state at a time. This ensures that developers work on a single draft version before publishing it. Multiple instances are allowed in other states (e.g., "Published"), but not during development.
質問 # 22
What happens when you regenerate credentials for Push Notifications in Oracle APEX?
- A. Push Notifications will be disabled for the application.
- B. Existing Push Subscriptions for the application will be invalidated.
- C. A new notification server must be created.
正解：B
解説：
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.
質問 # 23
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 Primary only
- B. As Primary
- C. As Private and Public only
正解：C
解説：
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.
質問 # 24
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. Setting Display Location to Inline in Notification
- C. Removing P1_SALARY from the validation Associated Item.
正解：B
解説：
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.
質問 # 25
Which two declarative options in Oracle APEX allow you to download BLOB/CLOB content?
- A. Share Dynamic Action
- B. Download Dynamic Action
- C. APEX_UTIL.DOWNLOAD PL/SQL API
- D. Download Page Process
正解：B、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.
質問 # 26
What do you achieve by performing the "Refresh Working Copy" task?
- A. Get the latest updates from the Main application.
- B. Update the changes from one Working Copy to another.
- C. Merge the Working Copy changes with the Main application.
正解：A
解説：
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.
質問 # 27
Which statement is true about Theme Styles in Oracle APEX?
- A. Theme Styles control the layout of a webpage.
- B. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.
- C. The "Is Current" attribute of a Theme Style depends on the "Read Only" attribute.
正解：B
解説：
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.
質問 # 28
Which two statements are true about creating and using dynamic actions?
- A. If no client-side condition is defined, true actions will not fire.
- B. If a client-side condition is defined, the true action will fire when the condition is met.
- C. After you create a dynamic action, you cannot add more true actions.
- D. You can execute JavaScript code by creating a dynamic action.
正解：B、D
解説：
Dynamic Actions in APEX enable responsive behavior:
If a client-side condition is defined, the true action will fire when the condition is met: A condition (e.g., this.browserEvent === 'click') ensures the true action (e.g., Show, Hide) executes only when true, enhancing precision in event handling.
You can execute JavaScript code by creating a dynamic action: The "Execute JavaScript Code" action type allows custom scripts (e.g., alert('Clicked!');), extending functionality beyond declarative options.
Cannot add more true actions: False; multiple true actions can be added post-creation.
No condition, true actions won't fire: False; without a condition, true actions fire unconditionally on the event.
Dynamic Actions are a cornerstone of interactive UIs in APEX.
質問 # 29
Which statement is true about the Data Workshop utility?
- A. You cannot load data from an XLSX file with multiple worksheets.
- B. The wizards load and unload table data only.
- C. You can load or unload multiple tables at a time.
- D. The wizards load and unload all types of schema objects.
正解：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.
質問 # 30
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. Region
- C. Application
- D. Instance
正解：C
解説：
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.
質問 # 31
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. Range
- B. Date Picker
- C. Popup LOV
- D. Checkbox Group
正解：A、D
解説：
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.
質問 # 32
......
更新されたのはOracle 1Z1-771問題集PDFオンラインエンジン：https://jp.fast2test.com/1Z1-771-premium-file.html