Career upgrade: Learn practical AI skills for better jobs and higher pay.
Level up
PracticeVideosBlogFlashcardsEspañol
All Practice Exams

100+ Free 1Z0-771 Practice Questions

Pass your Oracle APEX Cloud Developer Professional (1Z0-771) exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
~65-75% Pass Rate
100+ Questions
100% Free
1 / 100
Question 1
Score: 0/0

Which of the following correctly describes an APEX 'Application Process' as opposed to a 'Page Process'?

A
B
C
D
to track
Same family resources

Explore More Oracle Certifications

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

Oracle SQL

Practice Questions1 blog

OCI AI Foundations

Practice Questions

OCI Architect

Practice Questions

OCI Foundations

Practice Questions

Oracle DBA

Practice Questions

OCI 2025 Data Science Professional (1Z0-1110-25)

Practice Questions

More From This Family

Videos and articles for deeper review.

ArticleOracle SQL 1Z0-071 Exam Guide 2026: Official Facts, Topic Traps, and Practice Plan12 min read
2026 Statistics

Key Facts: 1Z0-771 Exam

55

Exam Questions

Oracle

60%

Passing Score

Oracle

90 min

Exam Duration

Oracle

$245

Exam Fee

Oracle

2 years

Validity

Oracle

APEX 23.2

Exam Version

Oracle Education

The 1Z0-771 exam has 55 questions in 90 minutes with a 60% passing score. Key domains: Application Builder and Page Design (~25%), Page Processing and Logic including Dynamic Actions (~25%), Reports/Grids/Charts (~20%), Security (~15%), and REST/Integration (~15%). Certification valid 2 years. Exam fee is $245. Available in-person or online proctored via PSI/Pearson VUE.

Sample 1Z0-771 Practice Questions

Try these sample questions to test your 1Z0-771 exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1Which APEX built-in substitution string returns the current application ID?
A.APP_ID
B.APP_SESSION
C.APP_USER
D.APP_PAGE_ID
Explanation: APP_ID is the built-in APEX substitution string that resolves to the numeric ID of the currently running application. It is commonly used in dynamic SQL, URLs, and conditional logic. APP_SESSION returns the unique session identifier, APP_USER returns the authenticated username, and APP_PAGE_ID returns the current page number.
2In Oracle APEX, a workspace is best described as:
A.A schema-level database user
B.A shared environment where developers build applications
C.A single APEX application instance
D.A PL/SQL package namespace
Explanation: A workspace in Oracle APEX is a shared, named work area that groups one or more developers and maps to one or more Oracle database schemas. It provides isolation between different development teams and projects. Multiple applications can exist within a single workspace.
3Which page component type in APEX is used to display tabular data returned by a SQL query with built-in sorting and pagination?
A.Classic Report
B.Interactive Report
C.Form Region
D.List View
Explanation: An Interactive Report in Oracle APEX automatically provides end users with controls for sorting, filtering, highlighting, grouping, aggregating, and downloading data. Classic Reports display data with developer-defined formatting but lack these end-user customization features. Form Regions collect input, and List Views display data in a list layout.
4What is the correct PL/SQL syntax to set the value of an APEX page item P2_ENAME from a page process?
A.APEX_APPLICATION.G_F01(1) := 'SMITH';
B.APEX_UTIL.SET_SESSION_STATE('P2_ENAME', 'SMITH');
C.:P2_ENAME := 'SMITH';
D.DBMS_SESSION.SET_CONTEXT('APEX','P2_ENAME','SMITH');
Explanation: Within a PL/SQL page process, APEX page items are accessible directly as bind variables using colon-prefix notation (e.g., :P2_ENAME). Assigning a value to :P2_ENAME updates the session state for that item. APEX_UTIL.SET_SESSION_STATE is a valid alternative API but the bind variable syntax is the idiomatic approach inside PL/SQL processes.
5In an APEX Dynamic Action, which built-in action type executes a PL/SQL block on the server and optionally returns values to page items?
A.Execute JavaScript Code
B.Set Value
C.Execute Server-side Code
D.Refresh
Explanation: The 'Execute Server-side Code' action in a Dynamic Action submits one or more page items to the server, runs a PL/SQL block, and can return updated values back to specified page items via the 'Items to Return' attribute. This is the standard way to perform server-side logic in response to client-side events.
6Which APEX validation type checks that a page item's value matches a regular expression?
A.Item is NOT NULL
B.Item matches Regular Expression
C.Function Returns Boolean
D.SQL Expression
Explanation: The 'Item matches Regular Expression' validation type allows you to specify a POSIX regular expression pattern. APEX evaluates the item value against the pattern and fires the validation error when the value does not match. This is useful for format checks such as email addresses, phone numbers, or zip codes.
7An APEX computation set on a page item with a Computation Point of 'After Submit' runs at what stage?
A.Before the page is rendered
B.Before validations execute
C.After validations pass and before page processes run
D.After page processes complete
Explanation: Computations with a Computation Point of 'After Submit' run after the page is submitted, after validations have passed, and before page processes execute. This ordering ensures that computed values are available to page processes and that invalid data does not trigger computations unnecessarily.
8In Oracle APEX, a List of Values (LOV) defined at the application level and reused across multiple pages is called a:
A.Dynamic LOV
B.Shared Component LOV
C.Page-Level LOV
D.Static LOV
Explanation: A Shared Component LOV (found under Shared Components > Lists of Values) is defined once at the application level and can be referenced by any page item or column in the application. This promotes reuse and centralizes maintenance. Page-Level LOVs and inline definitions are scoped to a single page or item.
9Which APEX region type provides a spreadsheet-like interface with inline editing, row selection, and full DML support?
A.Classic Report
B.Interactive Report
C.Interactive Grid
D.Faceted Search
Explanation: The Interactive Grid region type in Oracle APEX renders data in an editable grid that supports inline cell editing, row addition, row deletion, bulk operations, and declarative DML (INSERT, UPDATE, DELETE) against the underlying table or view. Interactive Reports are read-focused, Classic Reports have no inline editing, and Faceted Search is a filtering UI.
10What APEX feature allows you to define REST endpoints that expose APEX application logic or database data to external consumers?
A.REST Data Sources
B.RESTful Services (ORDS)
C.Web Credentials
D.Remote Servers
Explanation: Oracle REST Data Services (ORDS), integrated with APEX, enables developers to create RESTful Services that expose database queries, PL/SQL procedures, and APEX resources as HTTP endpoints consumable by external clients. REST Data Sources in APEX are for consuming external REST APIs, not publishing them.

About the 1Z0-771 Exam

The Oracle APEX Cloud Developer Professional (1Z0-771) exam validates intermediate-to-advanced Oracle APEX development skills. It covers application design, page processing, Dynamic Actions, Interactive Grids, security schemes, REST Data Sources, ORDS integration, APEX Automations, and plug-in development using APEX 23.2.

Questions

55 scored questions

Time Limit

90 minutes

Passing Score

60%

Exam Fee

$245 (Oracle / PSI / Pearson VUE)

1Z0-771 Exam Content Outline

~25%

Application Builder and Page Design

Workspaces, application creation wizard, page types, region types (Form, Report, Chart, Tree, Calendar, Cards, Kanban), page items, buttons, grid layout, Page 0 (Global Page), Universal Theme templates, Template Options, Theme Roller, Style Switcher

~25%

Page Processing and Logic

Computations (computation points, source types), validations (item not null, regex, SQL, PL/SQL), page processes (DML, fetch row, PL/SQL, on-demand Ajax callback), branches (redirect to page, redirect to URL), Dynamic Actions (events, conditions, true/false actions, JavaScript API)

~20%

Reports, Grids, and Charts

Interactive Reports (toolbar, saved reports, download), Interactive Grids (inline editing, DML process, column attributes), Classic Reports, Faceted Search, Tree Region, Calendar, JET Charts (bar, line, pie, scatter, SQL source conventions), Cards Region

~15%

Security and Authentication

Authentication schemes (APEX Accounts, Database Accounts, HTTP Header Variable, Social Sign-In), Authorization Schemes, Session State Protection, Lost Update Detection, CSRF prevention, XSS/output escaping, Content Security Policy, public pages

~15%

Integration and Advanced Features

REST Data Sources (consuming external APIs), ORDS RESTful Services (modules, templates, handlers), APEX Automations (scheduling, row actions), APEX Collections API, APEX_MAIL, APEX_DATA_EXPORT, Plug-ins (item, region, process, dynamic action types)

How to Pass the 1Z0-771 Exam

What You Need to Know

  • Passing score: 60%
  • Exam length: 55 questions
  • Time limit: 90 minutes
  • Exam fee: $245

Keys to Passing

  • Complete 500+ practice questions
  • Score 80%+ consistently before scheduling
  • Focus on highest-weighted sections
  • Use our AI tutor for tough concepts

1Z0-771 Study Tips from Top Performers

1Focus on Dynamic Actions: know the difference between client-side (Execute JavaScript Code) and server-side (Execute Server-side Code) actions and when to use each
2Understand Interactive Grid DML: know how 'Interactive Grid - Automatic Row Processing (DML)' differs from 'Form - Automatic Row Processing (DML)'
3Memorize session state patterns: bind variables (:P1_ITEM) in SQL, &P1_ITEM. in static text, apex.item().getValue() in JavaScript
4Study authorization vs authentication schemes: authentication verifies identity (who), authorization controls access (what they can do)
5Practice APEX_COLLECTION API: CREATE_COLLECTION_FROM_QUERY, ADD_MEMBER, UPDATE_MEMBER for wizard/multi-step patterns
6Know ORDS object hierarchy: Module > Resource Template (URL pattern) > Resource Handler (HTTP method + code)
7Review APEX 23.2 new features: Kanban Board Region, enhanced PWA support, improved Faceted Search, and JET chart enhancements

Frequently Asked Questions

What is the Oracle 1Z0-771 exam?

The 1Z0-771 (Oracle APEX Cloud Developer Professional) exam validates practical Oracle APEX development skills at an intermediate-to-advanced level. It covers the full APEX development lifecycle: application design, page processing, Dynamic Actions, reporting, security, and REST integration using APEX 23.2.

How many questions are on the 1Z0-771 exam?

The 1Z0-771 exam has 55 multiple-choice and multiple-select questions in 90 minutes. The passing score is 60%. Questions test both conceptual understanding and practical APEX development scenarios, including PL/SQL code reading and JavaScript API usage.

What are the prerequisites for the 1Z0-771 exam?

There are no formal prerequisites, but Oracle recommends hands-on Oracle APEX development experience and familiarity with SQL and PL/SQL. Candidates with at least 6-12 months of active APEX development are best positioned. Oracle University offers APEX training courses that align with exam objectives.

What is the most important domain on the 1Z0-771 exam?

Application Builder/Page Design and Page Processing/Logic are each ~25%, making them the two highest-weight areas. Together they cover 50% of the exam. Dynamic Actions (client-server AJAX patterns, JavaScript API) and Interactive Grid DML are consistently reported as high-frequency topics by exam takers.

How should I prepare for the 1Z0-771 exam?

Plan 40-60 hours over 4-8 weeks. Build several APEX applications hands-on using APEX 23.2. Focus on Dynamic Actions (Execute Server-side Code, Items to Submit/Return), Interactive Grid editing and DML, authorization/authentication scheme configuration, REST Data Sources, and APEX Automations. Complete 100+ practice questions and aim for 75%+ before scheduling.

What jobs can I get with 1Z0-771 certification?

The 1Z0-771 certification validates Oracle APEX development skills sought for roles including: Oracle APEX Developer, Low-Code Application Developer, Oracle Cloud Application Developer, Enterprise Application Developer (Oracle stack), and database-centric full-stack developer roles. It is particularly valued in organizations running Oracle Database or Oracle Cloud Infrastructure.