1Z0-771 Oracle APEX Cloud Developer Professional Practice Questions
Prepare for 1Z0-771 with more than an answer.
- Level
- Professional
- Valid for
- 3 years
Domains covered on the exam 19
- Getting Started with Oracle APEX on the Oracle Autonomous Database
- Using SQL Workshop
- Creating an APEX Application
- Managing Pages and Regions
- Developing Reports
- Creating and Using Forms
- Creating Application Page Controls
- Adding Computations, Processes, Validations and Branches
- Implementing Navigation in your Application
- Managing Application Data
- Using Themes and Theme Styles
- Extending Application Capabilities
- Implementing Security in your Application
- Adding Additional Pages to your Application
- Creating and Using Dynamic Actions and Plug-ins
- Migrating Application Development Between Environments
- Managing Workflows and Tasks
- Leveraging Generative AI in Oracle APEX
- Creating Progressive Web Apps
- 1
A developer is using Theme Roller to create a new Theme Style for a corporate application. After adjusting the colors and fonts, they save the new style as 'CorporateBlue'. Where is the resulting CSS stored, and how is it applied to the application?
Show answer details
Correct answer: B
When a new Theme Style is saved via Theme Roller, APEX generates a CSS file and stores it as a static application file. The application's User Interface attributes are then updated to reference this new CSS file when the 'CorporateBlue' style is selected as the current one, causing the browser to load it and apply the new styles.
- 2
A company automates its new employee onboarding process using APEX. The process involves several departments: HR creates the employee record, IT provisions equipment, and Facilities assigns a workspace. The IT and Facilities tasks can be performed in parallel, but both must be completed before HR can finalize the onboarding and mark the employee as 'Active'.
The development team has decided to use APEX Workflow. They have created a 'Human Task - Approval' for HR to initiate the process. To handle the parallel tasks, they are considering different approaches within the workflow definition. The key requirement is that the workflow must wait for both the IT and Facilities tasks to be completed before proceeding to the final HR step.
Which APEX Workflow activity should be used immediately after the parallel IT and Facilities tasks to ensure the workflow pauses until both are complete?
Show answer details
Correct answer: B
The Rendezvous activity is specifically designed for this purpose. It acts as a synchronization point in a workflow. When multiple parallel paths converge on a Rendezvous activity, it will wait until all incoming paths have completed their tasks before allowing the workflow to proceed along its single outgoing path. This perfectly models the requirement to wait for both IT and Facilities.
- 3
On a form page, a developer needs to ensure that the value of the
P10_END_DATEitem is always later than theP10_START_DATEitem before the page is submitted. What is the most appropriate type of component to implement this business rule?Show answer details
Correct answer: C
Validations are the declarative APEX feature designed specifically for enforcing business rules and data integrity before processing a page submission. A validation can be configured to fire on submit, check a condition (like comparing two dates), and if the condition fails, it stops the submission and displays an error message to the user.
- 4
An application needs to process a multi-step wizard where data is collected across several pages but should only be saved to the database upon final confirmation. During the intermediate steps, the data must be temporarily stored and accessible across pages within the user's session. Which APEX feature is best suited for managing this temporary, multi-row dataset?
Show answer details
Correct answer: C
APEX Collections are designed for this exact use case. They are session-specific, in-memory data structures that can hold multiple rows and columns of data. A developer can use the
APEX_COLLECTIONAPI to add, update, and delete members (rows) in the collection as the user moves through the wizard. The data persists across page views within the session and can be queried like a table. - 5
A user is on a Faceted Search page displaying a list of products. When they click a facet for 'Brand' and select 'MegaCorp', the results list correctly updates. What is the underlying mechanism APEX uses to refresh the report region without a full page reload?
Show answer details
Correct answer: C
Faceted Search, like Interactive Reports and Grids, relies heavily on Partial Page Refresh (PPR) implemented via AJAX. When a facet is changed, client-side JavaScript sends an asynchronous request to the APEX engine with the new filter context. The engine re-runs the report query and sends back only the HTML for the updated report region, which JavaScript then injects into the page, avoiding a full reload.
- 6
A developer is using the APEX Assistant to generate a PL/SQL process for calculating bulk discounts. The assistant produces a functionally correct, but poorly performing block of code that uses a cursor FOR loop with nested SELECT statements for each row. What is the most effective refactoring strategy to improve performance while maintaining the logic?
Show answer details
Correct answer: B
The most significant performance gain comes from eliminating row-by-row processing (slow-by-slow). A single set-based
MERGEstatement is the most efficient SQL approach to update rows based on values from another table, as it performs the operation in one pass, minimizing context switching between PL/SQL and SQL engines. - 7
A logistics company is building a Progressive Web App (PWA) in APEX for delivery drivers. A key requirement is that drivers can continue to update delivery statuses even when they are in areas with no internet connectivity. Which APEX feature is fundamental to meeting this offline data modification requirement?
Show answer details
Correct answer: C
Data Synchronization is the specific APEX feature designed to support offline data modifications. When enabled on a region like an Interactive Grid, APEX caches the data locally and tracks changes. Once connectivity is restored, it automatically synchronizes the offline changes with the server database, resolving the core requirement.
- 8
A financial services firm is implementing a multi-level expense approval workflow. The requirements state that expenses under $500 require only manager approval, while expenses of $500 or more require both manager and director approval. Additionally, any expense from the IT department, regardless of amount, must also be approved by the CIO. Which combination of APEX Workflow components is required to build this logic? (Select THREE)
Show answer details
Correct answer: A, B, D
A Switch activity is ideal for routing the workflow down different paths based on a value, such as the expense amount (
= $500). This directly addresses the primary conditional requirement.Each approval step requires a dedicated Human Task - Approval activity. The workflow will need separate tasks defined for the manager, director, and CIO roles to be placed in the appropriate conditional paths.
A workflow variable is needed to store state information, such as whether the expense originated from the IT department. This variable can then be used in activity server-side conditions to determine if the additional CIO approval step is necessary.
- 9
A healthcare provider is developing an APEX application for managing patient electronic health records (EHR). They must comply with strict data access regulations, ensuring that clinicians can only view records for patients assigned to their specific department (e.g., Cardiology, Oncology). The application uses a single
PATIENTStable which includes aDEPARTMENT_IDcolumn. The user's department is stored in an application item,:APP_USER_DEPARTMENT_ID, upon login.An inexperienced developer initially implemented security by adding a
WHEREclause (DEPARTMENT_ID = :APP_USER_DEPARTMENT_ID) to every report and form query in the application. This approach is prone to error and difficult to maintain. As the senior architect, you are tasked with implementing a more robust, centralized, and non-bypassable security mechanism.Which solution provides the most secure and maintainable method for enforcing this data access policy across the entire application?
Show answer details
Correct answer: C
Virtual Private Database (VPD), also known as Fine-Grained Access Control (FGAC), is the most robust solution. It attaches a security policy directly to the table at the database level. This policy dynamically adds a
WHEREclause to any query against the table, making the filtering automatic, transparent to the application, and impossible to bypass, even with ad-hoc SQL. It usesSYS_CONTEXTto securely access the APEX session state. - 10
A business analyst needs a report that allows them to dynamically pivot data, create charts, and compute aggregations on the fly without developer intervention. They also need to save multiple personalized versions of the report for different monthly reviews. Which APEX report type best satisfies all these requirements?
Show answer details
Correct answer: C
Interactive Reports are specifically designed for end-user data analysis. They provide built-in capabilities for pivoting, charting, aggregations, filtering, and control breaks. Crucially, users can save their customized views as private or public reports, which directly meets the requirement of having multiple personalized versions.
