Which APEX built-in substitution string returns the current application ID?
Apex Fundamentals
Question · Easy
In Oracle APEX, a workspace is best described as:
Which page component type in APEX is used to display tabular data returned by a SQL query with built-in sorting and pagination?
Reports And Grids
Tech Exam Prep Podcast
Listen on Spotify
Podcast
What is the correct PL/SQL syntax to set the value of an APEX page item P2_ENAME from a page process?
Page Processes
Question · Medium
In an APEX Dynamic Action, which built-in action type executes a PL/SQL block on the server and optionally returns values to page items?
Dynamic Actions
Which APEX validation type checks that a page item's value matches a regular expression?
Validations
An APEX computation set on a page item with a Computation Point of 'After Submit' runs at what stage?
Computations
In Oracle APEX, a List of Values (LOV) defined at the application level and reused across multiple pages is called a:
Shared Components
Which APEX region type provides a spreadsheet-like interface with inline editing, row selection, and full DML support?
What APEX feature allows you to define REST endpoints that expose APEX application logic or database data to external consumers?
Rest And Integration
In APEX page designer, what is the purpose of the 'Condition' attribute on a region, item, or button?
Page Design
Which JavaScript API call in an APEX Dynamic Action sets the value of page item P1_STATUS to 'ACTIVE'?
The APEX Universal Theme feature that lets users switch between a light and dark appearance without developer intervention is called:
Themes And Ui
In APEX, which built-in process type inserts or updates a row in a table based on the current values of page items mapped to columns?
Which APEX security feature defines a named set of privileges that controls what application resources a user can access?
Security
What does enabling 'Session State Protection' on a page item with 'Restricted - May not be set from browser' do?
In APEX Faceted Search, what component is placed alongside the report region to provide the filter panel with checkboxes, range sliders, and search fields?
Which APEX feature automates scheduled execution of SQL or PL/SQL without requiring an external scheduler like DBMS_SCHEDULER?
Automations
What is the correct way to reference the value of APEX page item P3_DEPTNO inside a SQL query used as a region source?
Which page branch type in APEX causes the browser to perform a full HTTP redirect to a new URL after page processing?
In APEX Universal Theme, which layout component creates a responsive card-based display often used for dashboard tiles?
Which APEX API package is used to send emails from a PL/SQL page process?
In APEX Interactive Grid, what attribute do you set on a column to make it editable by the end user?
What APEX mechanism provides pre-built application templates with sample data, pages, and functionality that can be installed into a workspace with one click?
Which APEX chart type is most appropriate for showing the proportion of each category relative to the total, displayed as slices?
Charts
In APEX, a REST Data Source defined under Shared Components is used to:
Which APEX authentication scheme type relies on the web server or Oracle Single Sign-On to validate user identity before APEX processes the request?
Question · Hard
In Oracle APEX 23.2, the 'Unified Theme' approach means that all pages in an application share which common asset?
What is the primary purpose of the APEX_UTIL.GET_SESSION_STATE function?
In APEX Page Designer, a 'Page Template' controls:
Which APEX component allows developers to extend APEX with custom item types, region types, or process types that can be reused across applications?
Plugins
What attribute on an APEX page controls whether anonymous (unauthenticated) users can access that page?
In APEX, which type of Application Item is best suited to store a value that must persist across all pages in a user's session?
Which SQL function in an APEX Interactive Report column formula would you use to display a clickable URL link for each row?
In APEX, the 'Lost Update Detection' feature on a form page protects against:
What is the default behavior of the APEX_COLLECTION.CREATE_COLLECTION_FROM_QUERY procedure?
Apex Collections
Which APEX page-level attribute specifies the PL/SQL anonymous block or function that runs before page regions are rendered?
In an APEX Dynamic Action, to execute JavaScript only when a text field value is greater than 100, you would use which event?
Which APEX feature generates a unique token for each form submission to prevent CSRF (Cross-Site Request Forgery) attacks?
What does the APEX_DEBUG.MESSAGE procedure do during application execution?
Debugging
Which of the following correctly describes an APEX 'Application Process' as opposed to a 'Page Process'?
In APEX, what is a 'Branch' component used for?
Which APEX 23.2 feature allows you to build a page that displays records in a Kanban-style board view?
What is the purpose of the APEX_ITEM.CHECKBOX2 function in a PL/SQL region or report column query?
Which APEX export format preserves the full application definition including all pages, shared components, and supporting objects as a single file?
In APEX, which region type is specifically designed for data entry with automatic mapping between a single database row and page items?
Which APEX API enables sending a structured notification (toast message) to the user's browser from a page process after an AJAX call?
Loading more…