1z0-771 Oracle APEX Cloud Developer Professional Free Practice Exam Questions (2025 Updated)

APEX Workspaces define development environments tied to database schemas:

A. During workspace creation, you can associate the workspace with an existing database schema: In the Workspace creation wizard (via Instance Administration), you select an existing schema (e.g., "HR") to link, enabling access to its objects. This is a standard step, ensuring immediate usability.

B. New schemas cannot be created during workspace creation: APEX doesn’t provide a UI to create schemas here; schemas must pre-exist in the database, created via SQL (e.g., CREATE USER).

C. A workspace can be associated with only one schema: False; a workspace can associate with multiple schemas post-creation via "Manage Workspace to Schema Assignments."

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.

The "Generate Text with AI" Dynamic Action uses Generative AI to:

Draft an email: Creates text content like emails based on prompts.

AnInteractive Gridis the report type that supports searchable, customizable data display withinline editingat runtime using mouse or keyboard. Interactive Reports are searchable and customizable but lack inline editing. Classic Reports are static, and Smart Filters is a component, not a report type.

The "Create Data Model using AI" feature in APEX Assistant leverages AI to generate data models based on natural language input. The supported SQL format options are:

Quick SQL: A shorthand syntax for defining database objects, which APEX can convert into full DDL.

An editable Interactive Grid synced with a REST Data Source (ORDS) maps CRUD operations to HTTP methods:

C. PUT: Updates an existing resource. When a user edits a row (e.g., changes SALARY), the grid sends a PUT request to the ORDS endpoint (e.g., /employees/101), updating the corresponding record.

A. POST: Creates new records, used for inserts, not updates.

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.

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.

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.

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

The "Create App using Generative AI" feature in APEX Assistant leverages natural language processing to automate application creation. When invoked:

Create the application blueprint: APEX Assistant generates a foundational structure (blueprint) for the application, including pages, regions, and navigation, based on the user's natural language input (e.g., "Create an app to manage employees"). This blueprint serves as the starting point, which developers can refine.

Add a Dashboard page: The Assistant can interpret requests for specific page types, such as dashboards, and include them in the generated app. Dashboards typically feature charts, summaries, or key metrics, and this is a common task supported by the AI-driven creation process.

Create a Generative AI service: This is not a task performed during app creation; instead, it’s a prerequisite configuration step done separately in the Instance Administration settings.

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.

The Data Workshop utility in APEX is designed to load and unloadtable 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.

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.