1Z0-771 Exam Questions & Answers
Oracle APEX Cloud Developer Professional • Oracle
100% money-back guarantee
Sample 1Z0-771 Questions
Practice with real exam-style questions, each with the verified correct answer and explanation.
Which three data types are supported by Oracle APEX Workflow parameters and item types?
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.
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?
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.
Which two statements are true about the APEX_MAIL API?
The APEX_MAIL API facilitates email functionality:
A . You can add files as attachments: Using APEX_MAIL.ADD_ATTACHMENT (e.g., APEX_MAIL.ADD_ATTACHMENT(p_mail_id, p_attachment, p_filename)), you can attach BLOBs (e.g., PDFs) to emails.
C . You can send emails: APEX_MAIL.SEND (e.g., APEX_MAIL.SEND(p_to => 'user@example.com', p_body => 'Hello')) sends emails from APEX, leveraging the configured mail server.
B . You can receive emails: False; APEX_MAIL is send-only; receiving requires custom integration (e.g., IMAP).
D . Only to Oracle database users: False; emails can go to any valid address, not just database users.
Pitfall: Ensure the mail queue is processed (APEX_MAIL.PUSH_QUEUE) for timely delivery.
Which statement is true about the Link Column attributes of an Interactive Report?
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.
You created a custom theme for an application. Examine these requirements: (Assuming requirements mandate syncing changes). Which solution guarantees that any changes to the master theme are reflected in the copied theme?
Theme subscription links a copied theme to its master:
A . Subscribing and refreshing: Subscribing the copied theme (in Shared Components > Themes) to the master ensures it inherits updates. 'Refresh Theme' (via Theme Roller or Utilities) syncs changes (e.g., CSS, templates) from the master, guaranteeing consistency.
B . Refreshing templates: Only updates individual templates, not the entire theme.
C . Copying changes: Manual, error-prone, and not guaranteed.
D . Verifying subscription: Confirms the link but doesn't sync changes.
Use case: Ideal for maintaining branded consistency across apps.
Get access to all 53 verified questions with detailed answers.
Unlock All 1Z0-771 Questions