O R A C L E C E R T I F I C A T I O N
1Z0-770 Oracle APEX Cloud Developer Professional Practice Exam
Exam Number: 4832 | Last updated April 19, 2026 | 700+ questions across 4 vendor-aligned objectives
The 1Z0-770 Oracle APEX Cloud Developer Professional exam is written for low-code developers and database programmers who build data-driven applications on Oracle APEX. Candidates validate the ability to model data, design application pages, build interactive reports and charts, add dynamic actions and plug-ins, apply security with authentication and authorization schemes, and integrate APEX apps with REST services and Autonomous Database.
The heaviest content is Application Development and Page Design (roughly 35%), covering pages, regions, items, interactive reports, interactive grids, forms, computations, processes, and validations. Dynamic Actions, Plug-ins, and Custom Code contributes another 25% with JavaScript, CSS, PL/SQL callbacks, and the plug-in architecture.
Security, Authentication, and Authorization sits near 20% and drills into authentication schemes, authorization schemes, session state protection, and Access Control lists. REST, Integration, and Administration rounds out the remaining weight with REST data sources, ORDS, workspace administration, and the APEX on Autonomous Database runtime model.
Every answer links to the source. Each explanation below includes a hyperlink to the exact Oracle documentation page the question was derived from. PowerKram is the only practice platform with source-verified explanations. Learn about our methodology →
272
practice exam users
91.2%
satisfied users
87.9%
passed the exam
4.2/5
quality rating
Test your 1Z0 770 APEX Cloud Dev Pro knowledge
10 of 700+ questions
Question #1 - Application Development and Page Design
An APEX developer at a university is building a course-catalog maintenance screen. Staff should be able to inline-edit rows, add new courses, and see updates without leaving the page. The table has 20 columns and 5,000 rows.
Which APEX region type best supports inline row editing with built-in DML?
A) An Interactive Grid region with Save enabled.
B) An Interactive Report (read-only).
C) A static HTML region with hand-written SQL.
D) A Classic Report.
Show solution
Correct answers: A – Explanation:
Interactive Grid supports inline editing, save-in-place, and built-in DML — the designed pattern for spreadsheet-style editing. Options B and D are read-only. Option C requires reinventing row-level DML. Source: Check Source
Question #2 - Application Development and Page Design
A developer wants a page to compute a running total when the user edits quantity in an Interactive Grid — without a server trip on each keystroke.
Which APEX capability delivers client-side responsiveness on Interactive Grid edits?
A) An interactive report with column breaks.
B) A dynamic action on the change event executing JavaScript on the client.
C) A page process that runs after submit.
D) A PL/SQL trigger on the underlying table.
Show solution
Correct answers: B – Explanation:
Dynamic actions with client-side execution (JavaScript) react to events like change without a server round-trip, which is the described requirement. Option C runs on submit. Option D runs in the database, not the browser. Option A is a different region. Source: Check Source
Question #3 - Application Development and Page Design
An APEX form validation requires that a proposed course start date is never earlier than today. The validation should fire when the user tries to save, blocking submission if it fails.
Which APEX mechanism enforces this server-side validation?
A) A visible help text asking the user to double-check.
B) A JavaScript alert only.
C) A page validation of type PL/SQL Expression or Function Returning Error Text, evaluated before processing.
D) A database trigger unrelated to APEX.
Show solution
Correct answers: C – Explanation:
APEX page validations evaluate server-side before DML, returning error text to block the submit when the rule fails. Option B can be bypassed. Option D is server-side but not tied to the page submit flow. Option A is not a control. Source: Check Source
Question #4 - Dynamic Actions, Plug-ins, and Custom Code
A developer finds a polished signature-capture widget on the APEX community site distributed as a plug-in. She wants to use it in her app without copying source code all over the pages.
Which APEX feature supports reusable installable components?
A) Pasting the widget source into every page.
B) A static image on each page.
C) A BI Publisher report.
D) Importing the plug-in into the application and using it as a region or item type.
Show solution
Correct answers: D – Explanation:
APEX plug-ins are packaged reusable components that developers import and consume as first-class regions, items, or processes — the designed extensibility model. Option A violates DRY. Option B is not interactive. Option C is reporting. Source: Check Source
Question #5 - Security, Authentication, and Authorization
An APEX team builds an internal app for HR that must authenticate against the corporate Azure AD/Microsoft Entra ID tenant so employees sign in with their work credentials.
Which APEX authentication scheme supports SSO against an external IdP?
A) A Social Sign-In / OAuth 2.0 authentication scheme configured for Microsoft Entra ID, or a SAML scheme through a federation provider.
B) Database user accounts for each employee.
C) No authentication — anyone on the corporate network may log in.
D) APEX Accounts only, with each employee creating a new password.
Show solution
Correct answers: A – Explanation:
APEX supports OAuth 2.0 / Social Sign-In with Microsoft Entra ID and SAML for federated SSO — the standard corporate SSO pattern. Option D creates duplicate credentials. Option B is unmanageable. Option C is insecure. Source: Check Source
Question #6 - Security, Authentication, and Authorization
A developer needs to ensure an APEX page parameter passed in the URL (like a primary key) cannot be tampered with by the user to access other rows they do not own.
Which APEX feature protects URL-borne page item values?
A) A JavaScript alert asking users to not change the URL.
B) Session State Protection with a checksum on page items.
C) Printing the parameter as a hidden comment.
D) Relying on the user not to edit the URL.
Show solution
Correct answers: B – Explanation:
Session State Protection with checksums validates URL and session state items, rejecting tampered values — the designed defense against URL tampering. Option C does not protect. Option D is naive. Option A is not a control. Source: Check Source
Question #7 - REST, Integration, and Administration
An APEX application needs to display real-time data from an external weather API. The developer wants to model the API like a table in APEX so she can use Interactive Reports on top of it.
Which APEX feature lets external REST endpoints be queried like a local table?
A) A local table populated by a nightly job.
B) A static HTML region with hard-coded values.
C) A REST Data Source (formerly Web Source) registered in the APEX workspace.
D) An Oracle Forms module embedded in APEX.
Show solution
Correct answers: C – Explanation:
REST Data Sources let APEX consume REST APIs as virtual tables, exposing them to Interactive Reports and other native APEX components — the described requirement. Option A is stale. Option B is not live. Option D is not an APEX feature. Source: Check Source
Question #8 - REST, Integration, and Administration
A workspace administrator wants to expose a REST endpoint that returns a list of students from a table, with filtering and pagination, so another system can consume it.
Which tool is used to publish this REST endpoint against the Oracle Database?
A) A static CSV file downloaded nightly.
B) A BI Publisher template.
C) An APEX page with HTML only.
D) Oracle REST Data Services (ORDS) with REST modules defined from APEX or SQL Developer Web.
Show solution
Correct answers: D – Explanation:
ORDS publishes database resources as REST endpoints with filtering, pagination, and authentication, managed via APEX or SQL Developer Web. Option B is a reporting engine. Option A is not REST. Option C is a UI page, not an API. Source: Check Source
Question #9 - Dynamic Actions, Plug-ins, and Custom Code
A developer wants a dynamic action that first runs a PL/SQL block server-side, then uses the returned value to update a page item client-side without a full page refresh.
Which dynamic action design supports this mixed server-then-client flow?
A) A dynamic action with an Execute PL/SQL Code true action returning values, followed by a Set Value action on the client.
B) A JavaScript-only action with no server interaction.
C) A server-only action that cannot update page items.
D) A page process after submit.
Show solution
Correct answers: A – Explanation:
Dynamic actions chain true actions: Execute PL/SQL Code can return values via Items to Return, and subsequent Set Value or Refresh actions update the UI on the client — the designed chain. Option D waits for submit. Option B misses the PL/SQL. Option C is limiting. Source: Check Source
Question #10 - Application Development and Page Design
A page developer wants to display the total course enrollment count in a dashboard card, refreshing every 30 seconds, without rebuilding the whole page.
Which APEX configuration fits this auto-refresh pattern?
A) A manual Refresh button for the user to click.
B) A full page reload on a timer.
C) A card or chart region with the dynamic action set to refresh on a timer using Execute JavaScript Code and apex.region().refresh().
D) A static HTML region with a hardcoded number.
Show solution
Correct answers: C – Explanation:
A timer-triggered dynamic action that calls apex.region().refresh() reruns the region’s query and updates just that region — the efficient live-refresh pattern. Option B is heavy. Option A is not auto-refresh. Option D is static. Source: Check Source
Get 700+ more questions with source-linked explanations
Every answer traces to the exact Oracle documentation page — so you learn from the source, not just memorize answers.
Exam mode & learn mode · Score by objective · Updated April 19, 2026
Learn more...
What the 1Z0 770 APEX Cloud Dev Pro exam measures
- Application development and page design (35%) — build pages with regions, items, interactive reports, interactive grids, forms, computations, processes, and validations.
- Dynamic actions, plug-ins, and custom code (25%) — extend APEX with dynamic actions, JavaScript, CSS, PL/SQL callbacks, and reusable plug-ins.
- Security, authentication, and authorization (20%) — apply authentication schemes, authorization schemes, session state protection, and Access Control lists.
- REST, integration, and administration (20%) — configure REST data sources, publish ORDS REST endpoints, and administer workspaces on APEX on Autonomous Database.
How to prepare for this exam
- Review the official 1Z0-770 exam page for the current objectives and weights.
- Complete the Oracle University Oracle APEX Cloud Developer Professional learning path on MyLearn.
- In an OCI always-free Autonomous Database with APEX, build a full CRUD app against the sample dataset, add an Interactive Grid with inline editing, and publish a REST endpoint with ORDS.
- Apply the skills on real work: rebuild a spreadsheet as an APEX app, add an authorization scheme to a public prototype, or plug-in a custom reusable component to your workspace.
- Master one objective at a time, starting with application development and page design since it carries the most weight.
- Run PowerKram learn mode to see feedback after every question with sourced links back to Oracle documentation.
- Finish with PowerKram exam mode across all objectives until you pass three back-to-back full-length attempts.
Career paths and salary outlook
APEX developer skills support low-code and data-application careers:
- APEX Developer — $90,000–$130,000 (Glassdoor).
- Low-Code Application Developer — $95,000–$135,000 (PayScale).
- Oracle Cloud Application Engineer — $115,000–$160,000 (U.S. Bureau of Labor Statistics).
Official resources
Follow the Oracle APEX Cloud Developer Professional Learning Path on Oracle MyLearn. Reinforce with the Oracle APEX documentation and the apex.oracle.com free workspace for sandbox practice.