1Z0-771 Sample Questions

1Z0-771 Sample Questions & Answers

Centers on building and securing APEX applications on the Autonomous Database, using SQL Workshop, designing pages, reports and forms, setting up navigation and themes, dynamic actions and plug-ins, workflow approvals, and generative AI assistance.

Launch the full 1Z0-771 simulator →

Showing 10 of 20 free samples.

  1. Question 1Beginner

    Using SQL Workshop · Quick SQL

    While prototyping a data model in SQL Workshop, a developer needs to quickly create tables for PROJECTS, TASKS, and TEAM_MEMBERS with appropriate primary keys, foreign keys, and audit columns (created, created_by, updated, updated_by). Which SQL Workshop utility is the most efficient tool for this task?

    Show answer & explanation

    Correct answer: D

    Quick SQL is designed for rapid data modeling and DDL generation. It uses a simplified, indented syntax to define tables and relationships. It has built-in directives, such as /audit cols, to automatically add common columns like audit columns, making it far more efficient than writing full DDL statements manually.

  2. Question 2Intermediate

    Migrating Application Development Between Environments · Remote Application Deployment

    True or False: The 'One-click Remote Application Deployment' feature allows deploying an application and its supporting database objects from a development to a production environment without requiring the production database to have REST Enabled SQL.

    Show answer & explanation

    Correct answer: B

    The statement is false. The remote deployment feature fundamentally relies on REST Enabled SQL being configured on the target (production) environment. The development APEX instance uses REST calls to connect to the target instance and push the application and object definitions.

  3. Question 3Intermediate

    Creating and Using Forms · Master-Detail Forms

    A developer is building a master-detail form using two Interactive Grids: one for CUSTOMERS (master) and one for ORDERS (detail). The requirement is to automatically filter the ORDERS grid to show only orders for the currently selected customer in the CUSTOMERS grid. How should this relationship be configured in Page Designer?

    Show answer & explanation

    Correct answer: B

    APEX provides a declarative way to create master-detail relationships. By setting the 'Master Region' property on the detail Interactive Grid and specifying the columns that link the two (e.g., CUSTOMER_ID), APEX automatically handles the filtering whenever a new row is selected in the master grid.

  4. Question 4Advanced

    Creating and Using Dynamic Actions and Plug-ins · Cascading Select Lists

    A developer needs to implement a 'cascading select list' behavior where the selection in a P1_COUNTRY item dynamically refreshes the list of values for a P1_STATE item. The P1_STATE item's List of Values query depends on the value of P1_COUNTRY. What is the most critical setting to configure for this interaction to work correctly?

    Show answer & explanation

    Correct answer: B

    The 'Cascading LOV Parent Item(s)' property is the declarative and most direct way to establish this relationship. When you set this property on the child item (P1_STATE), APEX automatically sends the parent item's (P1_COUNTRY) value to the session state during the refresh, making it available to the child's LOV query. This replaces the older manual method of using 'Page Items to Submit' in a Dynamic Action.

  5. Question 5Intermediate

    Extending Application Capabilities · Sending Email with APEX_MAIL

    To send an email with an attachment from an APEX application, a developer must use the APEX_MAIL.ADD_ATTACHMENT procedure. The first parameter to this procedure is p_mail_id. Where does the value for this parameter come from?

    The correct value is returned by the _____ function.

    Show answer & explanation

    Correct answer: C

    The APEX_MAIL.SEND function initiates the email, adds it to the mail queue, and returns a unique ID (p_mail_id). This ID must then be passed to subsequent calls to APEX_MAIL.ADD_ATTACHMENT to associate the files with the correct email message before the queue is pushed.

  6. Question 6Advanced

    Leveraging Generative AI in Oracle APEX · AI Vector Search and RAG

    A developer is building an application that leverages Oracle Database 23ai's AI Vector Search for a Retrieval-Augmented Generation (RAG) feature. The goal is to allow users to ask natural language questions about a knowledge base of documents. What is the primary role of the APEX application in this architecture?

    Show answer & explanation

    Correct answer: C

    In a RAG architecture with APEX, the APEX application serves as the orchestrator. It takes the user's input, calls a service to get its vector embedding, uses that vector to query the database's vector index for relevant context (the 'Retrieval' part), combines this context with the original question into a new prompt, and sends it to a generative AI service (LLM) for the final, context-aware answer (the 'Generation' part).

  7. Question 7Advanced

    Creating Progressive Web Apps · Push Notifications

    A developer has enabled the 'Progressive Web App' feature for an APEX application. They now want to send a push notification to all subscribed users whenever a new record is inserted into the ANNOUNCEMENTS table. What is the recommended, server-driven approach to achieve this?

    graph TD A[Database Trigger] -- on INSERT --> B{Call PL/SQL}; B --> C[APEX_PWA.SEND_PUSH_NOTIFICATION]; C --> D((Subscribed Users));

    Show answer & explanation

    Correct answer: B

    For server-driven events like a new record insertion, the most robust method is to use a database trigger or a similar backend process. The trigger can fire after insert on the table and call the APEX_PWA.SEND_PUSH_NOTIFICATION PL/SQL procedure, which handles the logic of sending the notification to all users who have subscribed and granted permission.

  8. Question 8Beginner

    Managing Pages and Regions · Page Designer Usage

    When using Page Designer, a developer needs to quickly find all components on a page that have a 'Server-side Condition' set to 'Never'. Which pane within the Page Designer is the most direct way to accomplish this?

    Show answer & explanation

    Correct answer: C

    The Page Search tab, located in the utility pane at the bottom of Page Designer, allows developers to search for components, attributes, and settings across the entire page. Typing 'Never' into the search bar will highlight all components that have this value set for any of their properties, including the Server-side Condition.

  9. Question 9Intermediate

    Implementing Navigation in your Application · Dynamic Navigation Menu

    An application uses a Navigation Menu list for its primary navigation. The business wants to display a count of open support tickets next to the 'Tickets' menu entry. This count is derived from a query SELECT COUNT(*) FROM TICKETS WHERE STATUS = 'OPEN'. How can this dynamic value be incorporated into the navigation menu entry label?

    Show answer & explanation

    Correct answer: A

    Navigation Menus are shared components and render early in the page lifecycle. The standard way to include dynamic values is to use an Application Item populated by an Application Computation. This ensures the value is available in session state when the menu is rendered. The item can then be referenced using standard static text substitution syntax (&ITEM_NAME.).

  10. Question 10IntermediateSelect 2

    Implementing Security in your Application · Session State Protection

    A security audit requires that all application pages prevent URL tampering for items that control report queries. For example, if a report URL is ...f?p=101:5:..::P5_DEPT_ID:10, a user should not be able to change the 10 to 20 to view another department. Which TWO security features should be configured to prevent this? (Select TWO)

    Show answer & explanation

    Correct answers: A, D

    Enabling Session State Protection at the application level is the first step. This feature provides the framework for checksums and access control.

    After enabling Session State Protection, you must generate URLs with a session-specific checksum. This is done declaratively in links or programmatically by setting the checksum type. This checksum includes the values of items being set in the URL. If a user tampers with the value, the checksum becomes invalid, and APEX will throw an error.

Ready for the real thing?

The full 1Z0-771 simulator has every exam-style question, timed mode, and instant scoring.

Go to the 1Z0-771 simulator →