Oracle 1z0-771 - Oracle APEX Cloud Developer Professional

Push notifications in Oracle APEX are enabled at theapplication 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.

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 dynamic List of Values (LOV) in APEX populates options based on a query source. The supported types include:

Function Returning SQL Query: A PL/SQL function that returns a SQL query string (e.g., RETURN 'SELECT ename, empno FROM emp';). This offers flexibility for dynamic conditions or complex logic.

SQL Query: A direct SQL statement (e.g., SELECT ename, empno FROM emp) executedat runtime to fetch LOV values. It’s the simplest and most common approach.

Procedure: Procedures execute logic but don’t return query results in the format required for an LOV (they don’t produce a result set directly).

TheShow AI Assistant Dynamic Actionin 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").

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).