Oracle APEX Shared Components 1 — Questions and Answers
Question 1: Where in Oracle APEX are Shared Components primarily accessed?
- SQL Workshop → Utilities
- Workspace Administration → Manage
- Application Builder → Application Home (Correct answer)
- Team Development → Dashboard
Correct answer: Application Builder → Application Home
Shared Components are accessed from the Application Builder's application home page, where they appear as a dedicated section for reusable application-level objects.
Question 2: What is the main purpose of a Static List of Values (LOV) in APEX Shared Components?
- To query a database table dynamically at runtime
- To store session-specific user preferences
- To provide a fixed set of display/return value pairs reusable across pages (Correct answer)
- To define navigation menu items for the application
Correct answer: To provide a fixed set of display/return value pairs reusable across pages
A Static LOV defines a fixed set of display and return value pairs at design time, making them reusable across multiple page items without a database query.
Question 3: Which type of LOV in Oracle APEX executes a SQL query against the database each time it is rendered?
- Static LOV
- Plugin LOV
- Shared LOV
- Dynamic LOV (Correct answer)
Correct answer: Dynamic LOV
A Dynamic LOV runs a SQL SELECT statement at runtime to fetch display and return values from the database, allowing the list to reflect current data.
Question 4: An Application Item in Oracle APEX is best described as:
- A reusable form field component stored in Shared Components
- A global session-state variable accessible across all pages of an application (Correct answer)
- A navigation shortcut for frequently visited pages
- A database column alias used in SQL reports
Correct answer: A global session-state variable accessible across all pages of an application
Application Items are global session-state variables that hold values at the application level, making them accessible from any page within the application.
Question 5: What is the purpose of an Application Process in Oracle APEX?
- A background database job triggered by DBMS_SCHEDULER
- A stored procedure used exclusively by RESTful web services
- A PL/SQL block that runs at the application level on a specified processing point (Correct answer)
- A process that resets all session state when a user logs out
Correct answer: A PL/SQL block that runs at the application level on a specified processing point
Application Processes are PL/SQL blocks defined in Shared Components that execute at the application level (not page level) at designated processing points such as On New Instance or On Load.
Question 6: Build Options in Oracle APEX allow developers to:
- Define the database build environment (dev/test/prod)
- Schedule nightly builds of the APEX application
- Control which components are included or excluded during development and testing (Correct answer)
- Configure JVM settings for the APEX engine
Correct answer: Control which components are included or excluded during development and testing
Build Options are flags that can be attached to application components to include or exclude them during specific development phases, making it easy to toggle features without deleting them.
Question 7: Application Computations in Shared Components are used to:
- Generate computed columns in interactive reports
- Run stored procedures during batch imports
- Define complex aggregation rules for chart regions
- Set Application Item values using SQL or PL/SQL when a specified event occurs (Correct answer)
Correct answer: Set Application Item values using SQL or PL/SQL when a specified event occurs
Application Computations calculate and assign values to Application Items at defined processing points using SQL queries, PL/SQL blocks, or static values.
Oracle APEX Shared Components 1
Where in Oracle APEX are Shared Components primarily accessed?