Oracle APEX Cloud Developer Professional (1Z0-771) — Questions and Answers
Question 1: Which JavaScript API method is used to retrieve the model associated with an Oracle APEX Interactive Grid?
- apex.region('regionStaticId').call('getViews').grid.model (Correct answer)
- apex.ig.getModel('regionId')
- apex.model.find('regionStaticId')
- apex.widget.interactiveGrid.getModel()
Correct answer: apex.region('regionStaticId').call('getViews').grid.model
You access the Interactive Grid's model through apex.region('staticId').call('getViews') to get the grid view and then access its model.
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 provide a fixed set of display/return value pairs reusable across pages (Correct answer)
- To store session-specific user preferences
- 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: What Oracle APEX component type is used to display a navigation menu on a page using a side navigation or tree layout?
- Navigation Bar Region
- List Region (Correct answer)
- Tree Region
- Navigation Menu Region
Correct answer: List Region
A List Region on a page displays a List shared component and can be styled as a navigation menu, side bar, or tree using list templates.
Question 4: In Oracle Application Express, why is report building knowledge important for professional certification?
- It demonstrates competence and ensures practitioners meet established standards (Correct answer)
- It is important only for entry-level positions
- It is only required for administrative purposes
- It has no practical relevance to daily work
Correct answer: It demonstrates competence and ensures practitioners meet established standards
Professional certification in specific knowledge areas demonstrates that practitioners have met established competency standards, ensuring quality of service and public protection.
Question 5: What is the concept of "deterrence" in Oracle Application Express authentication and security?
- Installing only hidden security cameras
- Discouraging potential threats through visible security presence and measures (Correct answer)
- Ignoring minor security breaches
- Physically confronting all suspicious individuals
Correct answer: Discouraging potential threats through visible security presence and measures
Deterrence aims to discourage potential threats and criminal activity through visible security measures, creating the perception that risks outweigh potential gains for would-be offenders.
Question 6: What Oracle APEX Interactive Grid attribute must be configured to enable row selection for use with JavaScript or Dynamic Actions?
- Row Highlight
- Row Selector (Correct answer)
- Selection Column
- Enable Selection
Correct answer: Row Selector
The Row Selector attribute adds a selection checkbox column to the Interactive Grid, enabling row selection that can be read via JavaScript or Dynamic Actions.
Question 7: You want to refer to a page by a name (or alias) instead of a page number in the application URL. <br><br> Which step most accurately helps you achieve this?
- Enter an alphanumeric name in the Page Title attribute.
- Set the Built-in substitution string PAGE_ALIAS on page load.
- Enter an alphanumeric alias in the Page Alias attribute. (Correct answer)
- Go to Application Properties and set "Refer to page by name (or alias)" to "Yes".
Correct answer: Enter an alphanumeric alias in the Page Alias attribute.
Explanation: <br> Setting an alphanumeric alias in the Page Alias attribute allows you to refer to a page by name (or alias) instead of its page number in the application URL. This makes the URL more readable and user-friendly.
Question 8: Where in Oracle APEX are Shared Components primarily accessed?
- Application Builder → Application Home (Correct answer)
- Team Development → Dashboard
- SQL Workshop → Utilities
- Workspace Administration → Manage
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 9: What is the role of de-escalation techniques in Oracle Application Express authentication and security?
- To transfer all conflicts to law enforcement
- To ignore confrontational situations
- To reduce the intensity of a conflict situation and prevent escalation to violence (Correct answer)
- To assert authority through physical force
Correct answer: To reduce the intensity of a conflict situation and prevent escalation to violence
De-escalation techniques use communication skills, body language, and calm demeanor to reduce tension and aggression, resolving situations peacefully before they escalate to physical confrontation.
Question 10: In Oracle Application Express, what role does continuing education play in application builder?
- To prevent professionals from advancing in their careers
- To increase testing frequency for compliance purposes
- To replace initial certification requirements
- To keep professionals current with evolving standards, technologies, and best practices (Correct answer)
Correct answer: To keep professionals current with evolving standards, technologies, and best practices
Continuing education ensures professionals stay current with new developments, evolving standards, and emerging best practices in their field, maintaining competence throughout their careers.
Question 11: What is the relationship between theory and practice in Oracle Application Express dynamic actions?
- Theory and practice are completely unrelated
- Practice is only important; theory is unnecessary
- Theory provides the foundation and framework that guides effective practical application (Correct answer)
- Theory replaces the need for any practical experience
Correct answer: Theory provides the foundation and framework that guides effective practical application
Theory and practice are complementary: theoretical knowledge provides the conceptual framework and understanding that guides effective, evidence-based practical application in professional settings.
Question 12: How can you dynamically show or hide a navigation menu entry in Oracle APEX based on a condition without using an Authorization Scheme?
- Use a Dynamic Action on the Navigation Menu region
- Set a Display Condition (Build Option or PL/SQL Expression) on the List Entry (Correct answer)
- Set a JavaScript condition on the page
- Use CSS visibility on the navigation region
Correct answer: Set a Display Condition (Build Option or PL/SQL Expression) on the List Entry
List Entries support Display Conditions such as PL/SQL expressions or Build Options that control whether the entry is rendered for the current request.
Question 13: In Application Express, how do you enable a database schema assigned to the current workspace so that it can be used to serve ORDS-based RESTful Services?
- Install the Sample REST Services packaged application.
- Navigate to workspace administration and in the Set Workspace Preferences section, set Enable RESTful Services to "Yes".
- Navigate to the Shared Components section and configure a REST Enabled SQL resource.
- Navigate to the ORDS RESTful services section of SQL workshop, select the appropriate schema, and click the "Register Schema with ORDS" button. (Correct answer)
Correct answer: Navigate to the ORDS RESTful services section of SQL workshop, select the appropriate schema, and click the "Register Schema with ORDS" button.
Explanation: <br> This option directly addresses enabling a database schema assigned to the current workspace for serving ORDS-based RESTful services by registering the schema with ORDS. This step ensures that the schema can be utilized for RESTful service development within the workspace.
Question 14: What is the purpose of a wireframe in Oracle Application Express page designer?
- To write the technical code for implementation
- To create a simplified visual guide showing the structure and layout of a design (Correct answer)
- To test the physical durability of materials
- To produce a final, polished design ready for production
Correct answer: To create a simplified visual guide showing the structure and layout of a design
A wireframe is a simplified, low-fidelity visual representation of a design's structure and layout, used for planning and communication before detailed design work begins.
Question 15: Which processing point is enabled for computations during page processing?
- Processing (Correct answer)
- Validating
- After Submit
- After Processing
Correct answer: Processing
Explanation: <br> Computations during page processing are enabled at the "Processing" processing point. This point occurs after the page has been submitted but before any processing occurs, allowing computations to be performed before any other actions are taken.
Question 16: What is the primary objective of dynamic actions in Oracle Application Express?
- To limit access to the profession
- To replace practical experience entirely
- To ensure competence and proficiency in core dynamic actions concepts (Correct answer)
- To generate revenue for testing organizations
Correct answer: To ensure competence and proficiency in core dynamic actions concepts
The primary objective of dynamic actions knowledge is to ensure practitioners have the competence and proficiency needed to perform effectively and safely in their professional roles.
Question 17: The following are classes of vulnerability that affect APEX applications except:
- Automated control (Correct answer)
- Cross-site scripting
- SQL injection
- Access control
Correct answer: Automated control
Explanation: <br> Automated control is not a class of vulnerability that affects APEX applications. Vulnerabilities are weaknesses or flaws in a system that can be exploited by attackers, and automated control does not fall into this category. SQL injection, access control, and cross-site scripting are all common vulnerabilities that can affect APEX applications. SQL injection involves inserting malicious SQL code into a database query, access control refers to inadequate restrictions on user access and permissions, and cross-site scripting involves injecting malicious scripts into web pages viewed by other users.
Question 18: In Oracle Application Express, what should be the first action when discovering a security breach?
- Wait until the end of shift to report it
- Assume it is a false alarm
- Immediately pursue the perpetrator alone
- Assess the situation and follow established incident response procedures (Correct answer)
Correct answer: Assess the situation and follow established incident response procedures
The proper response to a security breach begins with assessing the situation to determine the nature and scope, then following established protocols to ensure appropriate notification, response, and documentation.
Question 19: What is the purpose of conducting security risk assessments in Oracle Application Express?
- To reduce insurance premiums only
- To justify budget increases without analysis
- To identify vulnerabilities, evaluate threats, and recommend protective measures (Correct answer)
- To eliminate all security personnel
Correct answer: To identify vulnerabilities, evaluate threats, and recommend protective measures
Security risk assessments systematically identify and evaluate threats and vulnerabilities, assess potential impacts, and recommend cost-effective countermeasures to reduce risk to acceptable levels.
Question 20: Michael has developed an app for tracking product defects. His navigation menu lists each product. He has defined application items and computations to hold the number of defects for each product. For example, for Hedgers, he has defined the application item HEDGER_DEFECTS. <br><br> How can Michael add the number of open defects in the navigation menu entries?
- Update the List Entry Label for Hedgers to Hedgers &HEDGER_DEFECTS., and similarly for other products. (Correct answer)
- Update Template Options and set Display Count to True.
- Update the Navigation Menu template to Include Count.
- Add &HEDGER_DEFECTS. to User Defined Attribute 01 in the navigation menu for Hedgers, and similarly for other products.
Correct answer: Update the List Entry Label for Hedgers to Hedgers &HEDGER_DEFECTS., and similarly for other products.
Explanation: <br> By updating the List Entry Label for each product in the navigation menu to include the application item reference, such as &HEDGER_DEFECTS., Michael can dynamically display the number of defects for each product in the navigation menu entries. This approach ensures that the defect count is updated automatically based on the application item value defined for each product.
Question 21: The following are third-party libraries with which APEX comes standard with except:
- JQuery Mobile
- AnyChart
- JQuery System (Correct answer)
- CKEditor
Correct answer: JQuery System
Explanation: <br> APEX does not come standard with jQuery System. The other three libraries mentioned (jQuery Mobile, CKEditor, and AnyChart) are included with APEX.
Question 22: In Oracle Application Express, why is theme customization knowledge important for professional certification?
- It demonstrates competence and ensures practitioners meet established standards (Correct answer)
- It is only required for administrative purposes
- It is important only for entry-level positions
- It has no practical relevance to daily work
Correct answer: It demonstrates competence and ensures practitioners meet established standards
Professional certification in specific knowledge areas demonstrates that practitioners have met established competency standards, ensuring quality of service and public protection.
Question 23: What is the purpose of layers in Oracle Application Express page designer software?
- To prevent any changes to the design
- To increase the file size of the project
- To limit the number of colors available
- To organize different elements independently so they can be edited without affecting others (Correct answer)
Correct answer: To organize different elements independently so they can be edited without affecting others
Layers allow designers to organize different elements on separate, transparent levels that can be edited, hidden, or rearranged independently without affecting other parts of the design.
Question 24: Static Application Files uploaded to APEX Shared Components are stored:
- In Amazon S3 if Object Storage is configured
- In the Oracle database as BLOBs accessible via the APEX_APPLICATION_FILES view (Correct answer)
- In browser local storage for offline access
- On the web server's file system in the APEX image directory
Correct answer: In the Oracle database as BLOBs accessible via the APEX_APPLICATION_FILES view
APEX stores uploaded static files as BLOBs directly in the Oracle database, and they can be referenced and served through the APEX engine using the #APP_IMAGES# substitution string.
Question 25: Which Shared Component defines what actions a user is permitted to perform within an Oracle APEX application?
- Authorization Scheme (Correct answer)
- Application Process
- Authentication Scheme
- Build Option
Correct answer: Authorization Scheme
Authorization Schemes define what authenticated users are allowed to do, such as restricting access to certain pages or components based on roles or conditions.
Question 26: Which Oracle APEX attribute on a page is used to assign a breadcrumb entry so it appears in the breadcrumb trail?
- Region → Breadcrumb Source
- Shared Components → Breadcrumb Entry assignment
- Page Properties → Navigation → Breadcrumb
- Breadcrumb → Breadcrumb and Entry on the page definition (Correct answer)
Correct answer: Breadcrumb → Breadcrumb and Entry on the page definition
Each page in APEX has a Breadcrumb section in its Page Definition where you assign the breadcrumb component and the specific entry for that page.
Question 27: What is the purpose of an Application Process in Oracle APEX?
- A process that resets all session state when a user logs out
- A PL/SQL block that runs at the application level on a specified processing point (Correct answer)
- A background database job triggered by DBMS_SCHEDULER
- A stored procedure used exclusively by RESTful web services
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 28: Which approach is most effective for mastering theme customization in Oracle Application Express?
- Memorizing textbook definitions without understanding
- Combining theoretical study with practical application and regular review (Correct answer)
- Studying only immediately before examinations
- Relying solely on on-the-job experience
Correct answer: Combining theoretical study with practical application and regular review
The most effective approach combines theoretical understanding with practical application, reinforced by regular review and assessment, enabling deeper comprehension and long-term retention.
Question 29: In Oracle APEX Interactive Grid, which 'Allowed Operations' setting must be enabled to allow users to delete rows?
- Delete Row (Correct answer)
- Enable Delete
- Row Operations: Delete
- Allow Row Removal
Correct answer: Delete Row
The 'Delete Row' checkbox under Allowed Operations must be checked on the Interactive Grid to permit row deletion.
Question 30: Which is a predefined authentication scheme in Oracle Application Express?
- Universal Authentication Framework (UAF)
- Client Certificate Authentication
- OpenID Connect Sign-On
- SAML 2.0 Sign-On
- HTTP Header Variable (Correct answer)
Correct answer: HTTP Header Variable
Explanation: <br> HTTP Header Variable is a predefined authentication scheme in Oracle Application Express. It allows authentication based on the value of an HTTP header variable sent with the HTTP request.
Question 31: How can you prevent a specific column in an Oracle APEX Interactive Grid from being editable by end users?
- Set the column's 'Is Editable' property to No in Page Designer (Correct answer)
- Set the column type to Display Only
- Remove the column from the SELECT statement
- Use a Dynamic Action to disable the column
Correct answer: Set the column's 'Is Editable' property to No in Page Designer
Setting the column's 'Is Editable' property to No in Page Designer makes that specific column read-only within the editable grid.
Question 32: What is the purpose of the 'Initialization JavaScript Function' attribute on an Oracle APEX Interactive Grid?
- It validates data before a row is saved
- It allows developers to pass custom configuration options to the grid widget before it renders (Correct answer)
- It runs after the grid has fully loaded and rendered
- It sets default column values when a new row is added
Correct answer: It allows developers to pass custom configuration options to the grid widget before it renders
The Initialization JavaScript Function is called before the grid widget is created, allowing developers to override default configuration options.
Question 33: In Oracle Application Express, what is the primary objective of authentication and security?
- To replace law enforcement agencies entirely
- To monitor employee personal activities
- To generate revenue through enforcement actions
- To protect people, property, and information from threats and unauthorized access (Correct answer)
Correct answer: To protect people, property, and information from threats and unauthorized access
The primary objective of security operations is to protect people, physical assets, and information from various threats through prevention, detection, and appropriate response measures.
Question 34: Which Oracle APEX API call refreshes an Interactive Grid region programmatically using JavaScript?
- apex.event.trigger('#staticId', 'apexrefresh')
- apex.region('staticId').refresh() (Correct answer)
- apex.widget.refresh('staticId')
- apex.ig.refresh('staticId')
Correct answer: apex.region('staticId').refresh()
apex.region('staticId').refresh() is the standard APEX JavaScript API call to reload the data in an Interactive Grid region.
Question 35: In Oracle Application Express, what does "chain of custody" refer to?
- The organizational hierarchy of security personnel
- The sequence of patrol routes during a shift
- The order in which security guards take breaks
- The documented, chronological record of evidence handling from collection to presentation (Correct answer)
Correct answer: The documented, chronological record of evidence handling from collection to presentation
Chain of custody documents every person who handles evidence, when they received and transferred it, and what they did with it, ensuring evidence integrity and admissibility.
Question 36: Which two layout options are available for Page Designer under Utilities?
- Single Pane Mode (Correct answer)
- Four Pane Mode
- Three Pane Mode
- Two Pane Mode (Correct answer)
Correct answer: Single Pane Mode
Explanation: <br> In Page Designer under Utilities, you can find the Single Pane Mode and Two Pane Mode layout options. These modes determine how the Page Designer interface is displayed, allowing you to choose between a single-pane or two-pane layout for managing your application pages efficiently.
Question 37: What happens in Oracle APEX when a navigation menu List Entry has no Target URL defined?
- It redirects to the home page
- It throws a runtime error
- It is hidden from all users
- It acts as a parent-only label that expands to show child entries when clicked (Correct answer)
Correct answer: It acts as a parent-only label that expands to show child entries when clicked
A List Entry with no target becomes a non-clickable parent label used to group and expand child entries in the navigation hierarchy.
Question 38: Which Oracle APEX component allows developers to create a pop-up or mega menu navigation pattern using custom HTML and CSS within the navigation bar?
- Navigation Bar Entry with custom HTML content (Correct answer)
- Custom Region in Navigation Bar position
- Modal Page linked from Navigation Bar
- Inline Dialog triggered by Navigation entry
Correct answer: Navigation Bar Entry with custom HTML content
Navigation Bar Entries support custom HTML content, allowing developers to embed dropdown or mega menu HTML structures directly into the navigation bar.
Question 39: APEX Collections, which enable temporary multi-row session data storage, are manipulated using which Oracle-provided API?
- DBMS_SESSION package
- APEX_COLLECTION PL/SQL package (Correct answer)
- APEX_UTIL.SET_COLLECTION procedure
- UTL_COLLECTION package
Correct answer: APEX_COLLECTION PL/SQL package
The APEX_COLLECTION package provides procedures and functions such as CREATE_COLLECTION, ADD_MEMBER, and GET_MEMBER to create and manage temporary multi-row data sets within a user's session.
Question 40: In Oracle APEX, which Interactive Grid column type should be used to display a checkbox for boolean or Yes/No data?
- Switch
- Boolean Display
- Checkbox (Correct answer)
- Select List with static values
Correct answer: Checkbox
The Checkbox column type in Interactive Grid renders a checkbox UI control suitable for boolean or Yes/No column values.
Question 41: Build Options in Oracle APEX have which two possible status values?
- Include and Exclude (Correct answer)
- Enabled and Disabled
- On and Off
- Active and Inactive
Correct answer: Include and Exclude
Build Options are set to either 'Include' or 'Exclude', which determines whether the associated components are rendered and executed in the application.
Question 42: In Oracle Application Express, what role does continuing education play in form development?
- To keep professionals current with evolving standards, technologies, and best practices (Correct answer)
- To replace initial certification requirements
- To increase testing frequency for compliance purposes
- To prevent professionals from advancing in their careers
Correct answer: To keep professionals current with evolving standards, technologies, and best practices
Continuing education ensures professionals stay current with new developments, evolving standards, and emerging best practices in their field, maintaining competence throughout their careers.
Question 43: What is a best practice in Oracle Application Express report building?
- A method or technique recognized as superior based on evidence and expert consensus (Correct answer)
- A practice used only by large organizations
- Any practice that is easy to implement
- The cheapest available approach
Correct answer: A method or technique recognized as superior based on evidence and expert consensus
Best practices are methods, techniques, or approaches that are recognized through evidence, research, and expert consensus as producing superior results and are recommended for adoption.
Question 44: What is the relationship between theory and practice in Oracle Application Express application builder?
- Theory replaces the need for any practical experience
- Practice is only important; theory is unnecessary
- Theory provides the foundation and framework that guides effective practical application (Correct answer)
- Theory and practice are completely unrelated
Correct answer: Theory provides the foundation and framework that guides effective practical application
Theory and practice are complementary: theoretical knowledge provides the conceptual framework and understanding that guides effective, evidence-based practical application in professional settings.
Question 45: In Oracle Application Express, why is restful services knowledge important for professional certification?
- It is important only for entry-level positions
- It has no practical relevance to daily work
- It is only required for administrative purposes
- It demonstrates competence and ensures practitioners meet established standards (Correct answer)
Correct answer: It demonstrates competence and ensures practitioners meet established standards
Professional certification in specific knowledge areas demonstrates that practitioners have met established competency standards, ensuring quality of service and public protection.
Question 46: What Oracle APEX feature enables you to create a navigation menu that automatically generates entries based on the pages in the application?
- Auto Generate Navigation Menu in Create Application Wizard (Correct answer)
- Dynamic Navigation from Page Catalog
- Page-based List Auto-Build
- Navigation Wizard with Page Sync
Correct answer: Auto Generate Navigation Menu in Create Application Wizard
The Create Application Wizard in Oracle APEX can automatically generate a navigation menu with entries corresponding to each page added during app creation.
Question 47: In an Oracle APEX Interactive Grid, what does setting the 'Editable' property to 'Single Row' mean?
- Users can edit only a single column
- The grid is read-only for all users
- Only the first row is editable
- Only one row at a time can be in edit mode (Correct answer)
Correct answer: Only one row at a time can be in edit mode
Single Row edit mode means the grid opens one row at a time for editing, presenting it in a form-style layout.
Question 48: In Oracle Application Express, what role does continuing education play in sql workshop?
- To replace initial certification requirements
- To prevent professionals from advancing in their careers
- To keep professionals current with evolving standards, technologies, and best practices (Correct answer)
- To increase testing frequency for compliance purposes
Correct answer: To keep professionals current with evolving standards, technologies, and best practices
Continuing education ensures professionals stay current with new developments, evolving standards, and emerging best practices in their field, maintaining competence throughout their careers.
Question 49: What is the primary objective of application builder in Oracle Application Express?
- To generate revenue for testing organizations
- To limit access to the profession
- To replace practical experience entirely
- To ensure competence and proficiency in core application builder concepts (Correct answer)
Correct answer: To ensure competence and proficiency in core application builder concepts
The primary objective of application builder knowledge is to ensure practitioners have the competence and proficiency needed to perform effectively and safely in their professional roles.
Question 50: In Oracle Application Express, what are the fundamental principles of page designer?
- Balance, contrast, emphasis, movement, pattern, rhythm, and unity (Correct answer)
- Speed of completion and cost efficiency
- Using as many elements as possible
- Only color and size considerations
Correct answer: Balance, contrast, emphasis, movement, pattern, rhythm, and unity
The fundamental principles of design include balance, contrast, emphasis, movement, pattern, rhythm, and unity, which work together to create visually effective and functional compositions.
Question 51: John has a form page with an email item and a status item. What must John do to ensure that the email item is populated before users can enter any value into the status item on the form page?
- Server-side condition on the status item
- Dynamic action on the email item
- Validation on the email item (Correct answer)
- Plug-in for the status item
Correct answer: Validation on the email item
Explanation: <br> By applying validation on the email item, John can ensure that the email field is populated before users can enter any value into the status item on the form page. This ensures that the required email field is filled out before proceeding to the next field, maintaining data integrity.
Question 52: In Oracle Application Express, what role does continuing education play in restful services?
- To keep professionals current with evolving standards, technologies, and best practices (Correct answer)
- To prevent professionals from advancing in their careers
- To replace initial certification requirements
- To increase testing frequency for compliance purposes
Correct answer: To keep professionals current with evolving standards, technologies, and best practices
Continuing education ensures professionals stay current with new developments, evolving standards, and emerging best practices in their field, maintaining competence throughout their careers.
Question 53: In Oracle APEX Interactive Grid, what does setting a column's 'Query Only' attribute to Yes mean?
- The column displays only SQL query results without formatting
- The column cannot be filtered or sorted by the user
- The column is hidden from non-admin users
- The column value is fetched from the database but never included in INSERT or UPDATE statements (Correct answer)
Correct answer: The column value is fetched from the database but never included in INSERT or UPDATE statements
A Query Only column is read from the database for display purposes but is excluded from DML operations performed by the grid.
Question 54: What is the role of a 'Hidden Column' in an Oracle APEX Interactive Grid?
- It creates a virtual column with no data binding
- It hides the column from the database view
- It holds data values (such as a primary key) that are submitted but not visible to the user (Correct answer)
- It permanently removes the column from query results
Correct answer: It holds data values (such as a primary key) that are submitted but not visible to the user
A Hidden Column stores values like primary keys in the grid model and submits them during DML without displaying them to the end user.
Question 55: Which Oracle APEX Interactive Grid feature enables users to group rows by the values in a specific column?
- Pivot
- Control Break
- Group By (Correct answer)
- Aggregate
Correct answer: Group By
The Group By feature in Interactive Grid allows users to collapse rows sharing the same value in a column into a grouped header.
Oracle APEX Cloud Developer Professional (1Z0-771)
The Oracle APEX Cloud Developer Professional certification validates skills in building low-code applications using Oracle Application Express on Oracle Autonomous Database, covering page design, dynamic actions, reports, security, and REST integration.
Exam Rules
- You can skip questions and return to them later
- Flag questions for review before submitting
- No feedback shown until you submit the entire exam
- Unanswered questions count as wrong — answer everything
- 10 pretest questions are mixed in and don't affect your score
- Timer auto-submits when time runs out
- Your progress is auto-saved every 30 seconds
These practice questions were written with AI tools. They are not real exam questions. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- mylearn.oracle.com — Test delivery, exam format, passing score, score release, time limit · verified Oct 2026