Get Oracle 1Z0-771 Exam Dumps

Answer : A, B

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 focused editing.

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.

D . Single Pane: Not an option; the minimum is two panes.

Developers toggle these via the Utilities menu to optimize screen real estate based on task complexity.

Answer : D

To run multiple processes in the background:

D . Execution Chain: This process type allows chaining multiple processes (e.g., PL/SQL, REST calls) to execute sequentially or conditionally in the background, managed via the Process Chain framework. It's ideal for complex, asynchronous tasks (e.g., batch updates).

A . Execute Code: Not a process type in APEX; likely a misnomer.

B . Execute Server-side Code: Runs a single PL/SQL block synchronously, not multiple background tasks.

C . Execute JavaScript Code: Client-side, not suited for background server processes.

Use case: Chain processes like data validation, logging, and email sending without blocking the UI.

Answer : C

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.

B . GET: Retrieves data, used for initial grid population, not updates.

Technical note: ORDS maps PUT to an update operation on the underlying table, requiring the REST endpoint to support this method.

Answer : A, C

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.

Answer : B, D

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

C . Create and run SQL scripts: This is a SQL Scripts feature, not Object Browser.

Practical tip: Use 'Create Lookup Table' to normalize data efficiently.