1z0-771 Oracle APEX Cloud Developer Professional Questions and Answers

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: ThePush 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.

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.

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.

Declarative options for downloading BLOB/CLOB content include:

Download Dynamic Action: A built-in action type to trigger downloads of BLOB/CLOB data.

Page Designer’s layout modes under Utilities adjust the workspace:

A. Two Pane: Splits into two vertical sections (e.g., tree and properties), ideal for focusedediting.

B. Three Pane: Adds a third section (e.g., tree, grid, properties), offering a balanced view for complex pages.

C. Four Pane: Not available; APEX limits to three for usability.

Faceted search pages in APEX provide dynamic filtering. The true statements are:

Faceted Search supports the ability to filter columns storing multiple values: Facets canhandle multi-value columns (e.g., comma-separated lists or JSON arrays) using appropriate SQL (e.g., INSTR or JSON_TABLE), enabling complex filtering scenarios like tags or categories.

Facets map to specific database columns: Each facet is tied to a column in the underlying query (e.g., DEPTNO or JOB), ensuring data-driven filtering.

Multiple charts are not visible in the same region: False; multiple facets can display charts within the same region, depending on settings.

To send push notifications to all subscribed users, you must:

Enable push notifications at the application level (a prerequisite).

Plugins extend APEX’s functionality beyond built-in components:

C. Process: A Process plugin executes custom server-side logic (e.g., PL/SQL) during page processing or AJAX calls. Example: A plugin to sync data with an external API after form submission. It’s defined with execution points and parameters.

D. Region: A Region plugin creates custom UI areas (e.g., a dynamic chart or carousel). Example: A plugin rendering a custom dashboard. It supports attributes, templates, and refresh events.

A. Validation: While validations are customizable, they’re not a plugin type; they’re declarative or PL/SQL-based within APEX.

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.

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.

In Oracle APEX Workflow, onlyone instanceof 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.

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.