Oracle 1Z1-771 Certification All-in-One Exam Guide Oct-2025
Get Real 1Z1-771 Exam Dumps [Oct-2025] Practice Tests
Oracle 1Z1-771 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
| Topic 11 |
|
| Topic 12 |
|
| Topic 13 |
|
| Topic 14 |
|
| Topic 15 |
|
NEW QUESTION # 23
In a faceted search page, facets can be displayed as different UI types. Which two facet item types are supported in the faceted search region?
- A. Date Picker
- B. Popup LOV
- C. Checkbox Group
- D. Range
Answer: C,D
Explanation:
In Oracle APEX, a faceted search page allows users to filter data using facets, which are displayed as UI components in the Faceted Search region. According to the Oracle APEX documentation, the supported facet item types include:
Range: Used for numeric or date ranges, allowing users to filter data within a specified range (e.g., salary or hire date).
Checkbox Group: Used for multi-select options, enabling users to select multiple values from a list (e.g., departments).
Other types like Popup LOV and Date Picker are valid item types in APEX but are not natively supported as facet types in the Faceted Search region. Popup LOV is typically used for single-value selection in forms, and Date Picker is a standalone item type, not a facet-specific UI.
NEW QUESTION # 24
Which two statements are true about faceted search pages?
- A. Faceted Search supports the ability to filter columns storing multiple values.
- B. Multiple charts are not visible in the same region.
- C. A facet's chart can be seen only in a nonmodal dialog.
- D. Facets map to specific database columns.
Answer: A,D
Explanation:
Faceted search pages in APEX provide dynamic filtering. The true statements are:
Faceted Search supports the ability to filter columns storing multiple values: Facets can handle multi-value columns (e.g., comma-separated lists or JSON arrays) using appropriate SQL (e.g., INSTR or JSON_TABLE), enabling complex filtering scenarios like tags or categories.
Facets map to specific database columns: Each facet is tied to a column in the underlying query (e.g., DEPTNO or JOB), ensuring data-driven filtering.
Multiple charts are not visible in the same region: False; multiple facets can display charts within the same region, depending on settings.
A facet's chart can be seen only in a nonmodal dialog: False; charts can appear inline or in dialogs, configurable via facet attributes.
This functionality makes faceted search ideal for exploratory data analysis.
NEW QUESTION # 25
Which two tasks can be performed by using the Generate Text with AI Dynamic Action?
- A. Summarize or translate text
- B. Update the underlying database tables
- C. Invoke a Workflow
- D. Draft an email
Answer: A,D
Explanation:
The "Generate Text with AI" Dynamic Action uses Generative AI to:
Draft an email: Creates text content like emails based on prompts.
Summarize or translate text: Processes existing text to summarize or translate it.
It does not update database tables or invoke workflows, as it's focused on text generation.
NEW QUESTION # 26
You have defined a REST Data Source with ORDS as the REST Data Source Type. The Source is being used as source for an editable Interactive Grid. When a user updates an employee record in this Interactive Grid, which operation is performed on the Database?
- A. POST
- B. GET
- C. PUT
Answer: C
Explanation:
An editable Interactive Grid synced with a REST Data Source (ORDS) maps CRUD operations to HTTP methods:
C . PUT: Updates an existing resource. When a user edits a row (e.g., changes SALARY), the grid sends a PUT request to the ORDS endpoint (e.g., /employees/101), updating the corresponding record.
A . POST: Creates new records, used for inserts, not updates.
B . GET: Retrieves data, used for initial grid population, not updates.
Technical note: ORDS maps PUT to an update operation on the underlying table, requiring the REST endpoint to support this method.
NEW QUESTION # 27
How many instances of a Workflow can exist in the "In Development" state?
- A. 0
- B. Unlimited
- C. 1
Answer: C
Explanation:
In Oracle APEX Workflow, only one instance of a workflow can exist in the "In Development" state at a time. This ensures that developers work on a single draft version before publishing it. Multiple instances are allowed in other states (e.g., "Published"), but not during development.
NEW QUESTION # 28
What happens when you regenerate credentials for Push Notifications in Oracle APEX?
- A. Existing Push Subscriptions for the application will be invalidated.
- B. A new notification server must be created.
- C. Push Notifications will be disabled for the application.
Answer: A
NEW QUESTION # 29
Which statement is true about Theme Styles in Oracle APEX?
- A. The "Is Current" attribute of a Theme Style depends on the "Read Only" attribute.
- B. Theme Styles control the layout of a webpage.
- C. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.
Answer: C
Explanation:
Theme Styles define visual aspects (e.g., colors, fonts) in APEX:
B . When the Is Public attribute is enabled: Setting "Is Public" to "Yes" allows end users to select from available Theme Styles at runtime (e.g., via a UI switcher), enhancing customization.
A . Control the layout: False; layout is managed by templates and regions, not Theme Styles, which focus on aesthetics.
C . "Is Current" depends on "Read Only": False; "Is Current" marks the active style, independent of "Read Only" (which locks editing).
Practical note: Public styles require multiple defined styles in Shared Components.
NEW QUESTION # 30
In which two formats can the GetCurrentPosition Dynamic Action in Oracle APEX return coordinates?
- A. Latitude and Longitude
- B. State and Pincode
- C. Function Body returning SQL Query
- D. GeoJSON
Answer: A,D
Explanation:
The GetCurrentPosition Dynamic Action retrieves geolocation data from the user's device. It supports:
Latitude and Longitude: Returns coordinates as separate numeric values (e.g., lat: 37.7749, lon: -122.4194).
GeoJSON: Returns coordinates in a structured JSON format compliant with the GeoJSON standard (e.g., { "type": "Point", "coordinates": [-122.4194, 37.7749] }).
Function Body returning SQL Query is a dynamic action type, not a coordinate format, and State and Pincode is unrelated to geolocation coordinates.
NEW QUESTION # 31
Which two statements are true about creating and using dynamic actions?
- A. If a client-side condition is defined, the true action will fire when the condition is met.
- B. If no client-side condition is defined, true actions will not fire.
- C. After you create a dynamic action, you cannot add more true actions.
- D. You can execute JavaScript code by creating a dynamic action.
Answer: A,D
Explanation:
Dynamic Actions in APEX enable responsive behavior:
If a client-side condition is defined, the true action will fire when the condition is met: A condition (e.g., this.browserEvent === 'click') ensures the true action (e.g., Show, Hide) executes only when true, enhancing precision in event handling.
You can execute JavaScript code by creating a dynamic action: The "Execute JavaScript Code" action type allows custom scripts (e.g., alert('Clicked!');), extending functionality beyond declarative options.
Cannot add more true actions: False; multiple true actions can be added post-creation.
No condition, true actions won't fire: False; without a condition, true actions fire unconditionally on the event.
Dynamic Actions are a cornerstone of interactive UIs in APEX.
NEW QUESTION # 32
There is a validation of type Item is Numeric on the P1_SALARY item. When the page is submitted, this error message is displayed both as a notification and inline with the item. What will cause the validation error to appear only in the Notification area?
- A. Removing P1_SALARY from the validation Associated Item.
- B. Setting Display Location to Inline in Notification
- C. Setting Value Required to Yes on P1_SALARY.
Answer: B
Explanation:
Validation errors in APEX default to both inline (next to the item) and notification (top of page):
C . Setting Display Location to Inline in Notification: In the validation's properties, changing "Display Location" to "Inline in Notification" ensures the error appears only in the notification area, suppressing inline display. This centralizes feedback for a cleaner UI.
A . Removing Associated Item: Breaks the validation's link to P1_SALARY, stopping it entirely.
B . Value Required: Adds a separate check, unrelated to display location.
Pitfall: Test with non-numeric input (e.g., "abc") to confirm behavior.
NEW QUESTION # 33
The Movies faceted search report is filtered only when the Apply button for a selected facet is clicked. What must be done in the Page Designer so that report filtering is automatically executed when any facet value is selected?
- A. Navigate to each facet and then in the Property Editor, turn on Client-Side Filtering.
- B. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute.
- C. Navigate to the faceted search region Attributes, and turn off the Show Facet Name attribute.
Answer: B
Explanation:
By default, faceted search can "batch" changes, requiring an "Apply" button click to filter the report. To enable automatic filtering:
Disable the Batch Facet Changes attribute: In Page Designer, under the Faceted Search region's Attributes, setting "Batch Facet Changes" to "No" ensures the report refreshes immediately when a facet value is selected, improving responsiveness. This triggers an AJAX call to update the report without a manual submit.
Show Facet Name: This controls facet label visibility, unrelated to filtering behavior.
Client-Side Filtering: This applies to Interactive Reports/Grids, not faceted search regions, and isn't the correct solution here.
This adjustment enhances the user experience by providing instant feedback.
NEW QUESTION # 34
Which two actions are performed by using the Object Browser?
- A. Create a lookup table based on a column in the current table.
- B. Restore dropped database objects.
- C. Create and run SQL scripts.
- D. Browse database objects of the current schema.
Answer: A,D
Explanation:
Object Browser in SQL Workshop is a GUI for managing schema objects:
B . Browse database objects of the current schema: Displays tables, views, procedures, etc., in a tree view, allowing inspection of definitions (e.g., columns, constraints) and data previews.
D . Create a lookup table based on a column in the current table: From a table's column (e.g., DEPTNO), you can generate a lookup table (e.g., DEPT_LOOKUP) with unique values, automating reference table creation.
A . Restore dropped objects: Not supported; this requires DBA tools (e.g., FLASHBACK TABLE).
C . Create and run SQL scripts: This is a SQL Scripts feature, not Object Browser.
Practical tip: Use "Create Lookup Table" to normalize data efficiently.
NEW QUESTION # 35
Which two declarative options in Oracle APEX allow you to download BLOB/CLOB content?
- A. Download Page Process
- B. Download Dynamic Action
- C. APEX_UTIL.DOWNLOAD PL/SQL API
- D. Share Dynamic Action
Answer: A,B
Explanation:
Declarative options for downloading BLOB/CLOB content include:
Download Dynamic Action: A built-in action type to trigger downloads of BLOB/CLOB data.
Download Page Process: A process type that declaratively handles BLOB/CLOB downloads from a table.
APEX_UTIL.DOWNLOAD is a PL/SQL API, not a declarative option, and Share Dynamic Action is for sharing URLs, not downloading files.
NEW QUESTION # 36
What are two reasons to enable the "Used by App Builder" option while creating a Generative AI Server?
- A. To build applications using natural language powered by Generative AI
- B. To create a REST-enabled database object
- C. To author SQL powered by Generative AI
- D. To create a Working Copy of your application
Answer: A,C
Explanation:
Enabling "Used by App Builder" for a Generative AI Server allows:
Author SQL powered by Generative AI: Integrates AI-driven SQL generation in App Builder.
Build applications using natural language: Enables natural language prompts to create app components.
Options A and B are unrelated to this setting, as it's specific to AI integration in App Builder.
NEW QUESTION # 37
Which step is mandatory to make an existing Oracle APEX application Progressive Web App (PWA) enabled?
- A. Verify that Friendly URLs are turned on in the Application Definition.
- B. Add custom JavaScript to support offline functionality.
- C. Enable the PWA flag in the Application Definition.
- D. Enable RESTful Web Services in the application.
Answer: C
Explanation:
To enable an existing APEX application as a Progressive Web App (PWA), the mandatory step is:
Enable the PWA flag in the Application Definition: In the Application Definition attributes under "Progressive Web App," setting "Enable PWA" to "Yes" activates PWA features like installability, push notifications, and service worker generation. This is the foundational step, after which optional customizations (e.g., icons, manifest) can be added.
Friendly URLs: While recommended for modern apps, they're not required for PWA functionality.
Custom JavaScript: Optional for offline capabilities, but not mandatory for basic PWA enablement.
RESTful Web Services: Unrelated to PWA features.
This step transforms the app into a PWA, enhancing user experience on mobile and desktop devices with native-like behavior.
NEW QUESTION # 38
You need to ensure that "How may I help you today?" is the first message displayed by the AI assistant. Which attribute of the Show AI Assistant Dynamic Action should be configured in the Property Editor to achieve this?
- A. AI Assistant Name
- B. Initial Prompt
- C. Welcome Message
Answer: C
Explanation:
The Show AI Assistant Dynamic Action in Oracle APEX triggers the display of the AI Assistant interface. To customize the first message users see:
Welcome Message: This attribute in the Property Editor defines the initial text displayed when the AI Assistant appears. Setting it to "How may I help you today?" ensures this exact phrase greets users, enhancing user experience by setting a friendly tone. It's a static, developer-defined string, distinct from AI-generated responses.
Initial Prompt: This attribute defines the starting input or context sent to the AI model, not the visible message shown to users. It's typically hidden and used to guide the AI's behavior (e.g., "Act as a support agent").
AI Assistant Name: This sets the assistant's identity (e.g., "Alex"), displayed in the UI, but it's not the greeting message.
This configuration is critical for branding or guiding user interaction from the outset, and it's adjustable per dynamic action instance, offering flexibility across pages.
NEW QUESTION # 39
An application includes a form on the EMPLOYEES table. You must limit the P1_MANAGER page item so users can select a single employee name and ID from the corresponding manager ID in the same table. Which item type can be used to display P1_MANAGER?
- A. Checkbox
- B. Switch
- C. Popup LOV
Answer: C
Explanation:
The requirement is to allow users to pick a single employee (name and ID) from a list tied to the MANAGER_ID column in the EMPLOYEES table, implying a dynamic, searchable selection:
A . Popup LOV: This item type displays a popup window with a searchable list of values, sourced from a SQL query (e.g., SELECT ename, empno FROM employees WHERE empno IN (SELECT DISTINCT manager_id FROM employees)). It returns a single value (e.g., EMPNO) while displaying the name, perfectly meeting the need for a single selection from a related dataset.
B . Switch: A toggle (Yes/No), unsuitable for selecting from a list of employees.
C . Checkbox: Allows multiple selections, conflicting with the "single employee" requirement.
Practical note: Popup LOVs enhance usability with filtering and pagination, ideal for large employee lists, and support returning the ID while showing the name.
NEW QUESTION # 40
......
Last 1Z1-771 practice test reviews: Practice Test Oracle dumps: https://pass4sure.practicedump.com/1Z1-771-exam-questions.html