Oracle APEX & Oracle Forms Quiz | 20 Questions, Instant Score

Published by AbairTech Solution · Reviewed November 2026 · Editorial policy

Test your Oracle knowledge before an interview or a project kickoff. This free quiz has 10 Oracle APEX questions and 10 Oracle Forms questions. Choose one answer per question, click Check my score, and you will see your result plus a short explanation for every question. Nothing is stored or sent anywhere – the quiz runs entirely in your browser.

Want to study first? Read our Oracle APEX interview questions and Oracle Forms interview questions.

Part 1: Oracle APEX

1. Which component acts as the web listener between the browser and the APEX engine?

Oracle Forms Services Oracle REST Data Services (ORDS) Oracle Net Listener only Oracle Reports Server

ORDS receives HTTP requests and passes them to the APEX engine inside the database.

2. What is the recommended way to reference page item P1_ID in a SQL query?

&P1_ID. :P1_ID #P1_ID# $P1_ID

Bind variables are safe against SQL injection and allow execution plans to be reused.

3. After a page is submitted, which of these runs first?

Branches Processes Validations Computations

The usual order is computations, validations, processes, then branches.

4. Which region type lets users edit many rows spreadsheet-style?

Classic Report Interactive Report Interactive Grid Cards

The Interactive Grid supports inline, multi-row editing plus reporting features.

5. Which API provides temporary, session-specific storage for rows (for example a shopping cart)?

APEX_COLLECTION APEX_MAIL DBMS_OUTPUT APEX_EXPORT

Collections hold rows per session until you save them to real tables.

6. Which feature stops users changing item values by editing the URL?

Theme Roller Build Options Session State Protection Lazy Loading

Session State Protection adds checksums to links and rejects tampered URLs.

7. To refresh a report on the parent page after a modal dialog closes, which Dynamic Action event do you use?

Change Dialog Closed Page Load Key Press

The Dialog Closed event fires on the parent page when the modal is closed.

8. Which package is used to send email from APEX?

APEX_MAIL APEX_JSON APEX_DEBUG APEX_LANG

APEX_MAIL.SEND places messages in the mail queue for delivery via SMTP.

9. Where should you store an API key used by REST Data Sources?

In a hidden page item In a JavaScript file In the region source query In Web Credentials

Web Credentials keep secrets out of page code and the browser.

10. Which statement about APEX security is true?

Hiding a button fully secures its process Authorization schemes can protect pages, regions, buttons and processes Authentication decides what a user may do Authorization only works with LDAP

Authentication checks who the user is; authorization schemes control what they can do, and must also protect server-side processes.

Part 2: Oracle Forms

11. What is the file extension of a compiled form module?

.fmb .fmx .pll .olb

.fmb is the source; .fmx is the compiled runtime file.

12. Which trigger is used for item-level validation when a value changes?

WHEN-VALIDATE-ITEM POST-QUERY PRE-FORM POST-COMMIT

WHEN-VALIDATE-ITEM fires when a changed item is validated, usually on leaving it.

13. How often does the POST-QUERY trigger fire?

Once before the query runs Once after all rows are fetched Once for each record fetched Only on commit

POST-QUERY runs per fetched record, so heavy SQL in it slows queries.

14. Which of these is a restricted built-in?

MESSAGE SET_ITEM_PROPERTY SHOW_ALERT GO_BLOCK

Navigation built-ins like GO_BLOCK are restricted and cannot run in triggers such as WHEN-VALIDATE-ITEM.

15. Which built-in exits the current form and replaces it with another?

CALL_FORM OPEN_FORM NEW_FORM EXECUTE_QUERY

CALL_FORM keeps the caller in the background, OPEN_FORM runs in parallel, NEW_FORM replaces the current form.

16. Where does an LOV get its data from?

A property class A record group A visual attribute An object library

An LOV displays rows from a record group, which can be based on a query.

17. In a master-detail relation, which delete behaviour removes detail records along with the master?

Cascading Isolated Non-isolated Deferred

Cascading deletes details too; non-isolated blocks the master delete; isolated deletes only the master.

18. Which exception stops trigger processing and keeps the cursor in place?

NO_DATA_FOUND FORM_TRIGGER_FAILURE VALUE_ERROR TOO_MANY_ROWS

RAISE FORM_TRIGGER_FAILURE is the standard way to fail a validation in Forms.

19. Which block property changes the WHERE clause for the next query only?

DEFAULT_WHERE ORDER_BY QUERY_DATA_SOURCE_NAME ONETIME_WHERE

ONETIME_WHERE applies once; DEFAULT_WHERE stays for later queries.

20. Which built-in runs an Oracle Report from web-deployed Forms?

RUN_PRODUCT HOST RUN_REPORT_OBJECT CALL_FORM

RUN_REPORT_OBJECT submits to the Reports Server; WEB.SHOW_DOCUMENT then displays the output. RUN_PRODUCT is the old client-server method.

Want more practice? Try the full 100 Oracle APEX MCQs and 100 Oracle Forms MCQs.

Next step: revise with the 25 Oracle APEX interview questions and the 25 Oracle Forms interview questions, or learn hands-on with our Dynamic Actions guide.

Oracle APEX and Oracle Forms Quiz: 20 Questions with Instant Score

Part 1: Oracle APEX

Part 2: Oracle Forms

Need Oracle APEX or Forms experts?