Pass the Oracle Application Development 1z0-771 Questions and answers with CertsForce

Object Browser in SQL Workshop is a GUI for managing schema objects:

B. Browse database objects of the current schema: Displays tables, views, procedures, etc., in a tree view, allowing inspection of definitions (e.g., columns, constraints) and data previews.

D. Create a lookup table based on a column in the current table: From a table’s column (e.g., DEPTNO), you can generate a lookup table (e.g., DEPT_LOOKUP) with unique values, automating reference table creation.

A. Restore dropped objects: Not supported; this requires DBA tools (e.g., FLASHBACK TABLE).

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.

The "Check Syntax" process in APEX, typically used in SQL Workshop or when validating code, authenticates usingDatabase 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.

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.

The APEX_PWA package manages Push Notifications:

B. APEX_PWA.PUSH_QUEUE: This procedure forces immediate processing of the Push Notification queue, sending queued messages (added via APEX_PWA.SEND) to subscribed devices without waiting for the default scheduler (e.g., every 5 minutes). Example: APEX_PWA.PUSH_QUEUE; ensures a "Meeting now!" alert goes out instantly.

A. APEX_PWA.HAS_PUSH_SUBSCRIPTION: Checks if a user has an active subscription (returns BOOLEAN), not for sending.