Best Oracle 1Z1-771 Exam Practice Material Updated on Dec 10, 2025
New 1Z1-771 Actual Exam Dumps, Oracle Practice Test
NEW QUESTION # 32
Which step is mandatory to make an existing Oracle APEX application Progressive Web App (PWA) enabled?
- A. Enable RESTful Web Services in the application.
- B. Add custom JavaScript to support offline functionality.
- C. Enable the PWA flag in the Application Definition.
- D. Verify that Friendly URLs are turned on in the Application Definition.
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 # 33
Which is NOT an available Geometry Column data type for the map region?
- A. Latitude/Longitude
- B. JSON OBJECT
- C. GeoJSON
- D. SDO_GEOMETRY
Answer: B
Explanation:
The Map Region in APEX supports spatial data via:
GeoJSON: A JSON-based standard for geographic data (e.g., points, polygons).
SDO_GEOMETRY: Oracle's native spatial data type for storing geometry (e.g., SDO_GEOMETRY(2001, 4326, SDO_POINT_TYPE(-122, 37, NULL), NULL, NULL)).
Latitude/Longitude: Separate columns for lat/long coordinates, mapped to points.
JSON OBJECT: Not a supported geometry type; while JSON can store data, it's not a specific spatial format recognized by the Map Region without GeoJSON structure.
This ensures compatibility with Oracle Spatial and common GIS standards.
NEW QUESTION # 34
Which statement is true about importing an existing application into your workspace?
- A. You cannot change the application ID during the import process.
- B. The import process does not import the supporting objects defined during the export.
- C. You cannot import an APEX application exported from the latest APEX version to an old APEX version.
Answer: C
Explanation:
Importing an APEX application involves transferring its definition (exported as a .sql file):
C . You cannot import an APEX application exported from the latest APEX version to an old APEX version: APEX enforces backward compatibility limits. An app exported from 23.2 (latest features like AI Assistants) can't import into 19.2, as older versions lack support for newer metadata (e.g., APEX_AI tables). The import wizard checks the version and rejects incompatible files.
A . You cannot change the application ID: False; the import wizard prompts for a new ID if there's a conflict or if you choose to override.
B . Supporting objects not imported: False; if included in the export (via "Include Supporting Objects"), they're imported (e.g., tables, triggers), unless skipped explicitly.
Technical Insight: Export files contain a version check (e.g., apex_version := '23.2';), causing rejection if the target instance's APEX_VERSION is lower.
Use Case: Moving an app from a dev instance (23.2) to prod (23.2) works, but not to an outdated test instance (19.1).
Pitfall: Always match versions or upgrade the target instance first.
NEW QUESTION # 35
You use the Create Page Wizard to create a faceted search page on the EMP table. What is the default report type generated for this page?
- A. Classic Report
- B. Column Toggle Report
- C. Interactive Grid
- D. Interactive Report
Answer: D
Explanation:
When creating a faceted search page via the Create Page Wizard, the default report type is an Interactive Report. This pairs with the faceted search region to provide a searchable, filterable, and customizable report, leveraging the facets for dynamic filtering.
NEW QUESTION # 36
Which two statements are true about creating and managing an APEX Workspace?
- A. During workspace creation, you can associate the workspace with an existing database schema.
- B. New schemas cannot be created during workspace creation.
- C. A workspace can be associated with only one schema.
- D. You can create only two workspaces in an APEX Service (APEX Application Development) instance.
Answer: A,B
Explanation:
APEX Workspaces define development environments tied to database schemas:
A . During workspace creation, you can associate the workspace with an existing database schema: In the Workspace creation wizard (via Instance Administration), you select an existing schema (e.g., "HR") to link, enabling access to its objects. This is a standard step, ensuring immediate usability.
B . New schemas cannot be created during workspace creation: APEX doesn't provide a UI to create schemas here; schemas must pre-exist in the database, created via SQL (e.g., CREATE USER).
C . A workspace can be associated with only one schema: False; a workspace can associate with multiple schemas post-creation via "Manage Workspace to Schema Assignments." D . You can create only two workspaces: False; the limit depends on the APEX instance configuration (e.g., cloud service tier), not a fixed number like two.
Use case: Associating existing schemas is key for leveraging pre-built databases.
NEW QUESTION # 37
What happens when you regenerate credentials for Push Notifications in Oracle APEX?
- A. A new notification server must be created.
- B. Push Notifications will be disabled for the application.
- C. Existing Push Subscriptions for the application will be invalidated.
Answer: C
NEW QUESTION # 38
Which two statements are true about the APEX_MAIL API?
- A. You can receive emails using the APEX_MAIL package in an Oracle APEX application.
- B. The APEX_MAIL package supports sending emails only to Oracle database users.
- C. You can add files as attachments to your emails using the APEX_MAIL package.
- D. You can send emails using the APEX_MAIL package from an Oracle APEX application.
Answer: C,D
Explanation:
The APEX_MAIL API facilitates email functionality:
A . You can add files as attachments: Using APEX_MAIL.ADD_ATTACHMENT (e.g., APEX_MAIL.ADD_ATTACHMENT(p_mail_id, p_attachment, p_filename)), you can attach BLOBs (e.g., PDFs) to emails.
C . You can send emails: APEX_MAIL.SEND (e.g., APEX_MAIL.SEND(p_to => '[email protected]', p_body => 'Hello')) sends emails from APEX, leveraging the configured mail server.
B . You can receive emails: False; APEX_MAIL is send-only; receiving requires custom integration (e.g., IMAP).
D . Only to Oracle database users: False; emails can go to any valid address, not just database users.
Pitfall: Ensure the mail queue is processed (APEX_MAIL.PUSH_QUEUE) for timely delivery.
NEW QUESTION # 39
Which two actions are performed by using the Object Browser?
- A. Restore dropped database objects.
- B. Create and run SQL scripts.
- C. Create a lookup table based on a column in the current table.
- D. Browse database objects of the current schema.
Answer: C,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 # 40
You have an Interactive Grid component and you are enabling the Save Report functionality. As what can end users save the report type?
- A. As Primary
- B. As Private and Primary only
- C. As Private and Public only
Answer: C
Explanation:
In an Interactive Grid, the "Save Report" functionality allows end users to save customizations (e.g., filters, column order). The available options are:
Private: Saved for the individual user only, visible only to them.
Public: Saved and shared with all users of the application, if permitted by the developer.
Primary: This is a developer-defined default report, not an end-user save option. End users cannot overwrite the Primary report; they can only save as Private or Public (if enabled via the "Allow Public Reports" attribute).
This flexibility empowers users to personalize grids while allowing shared configurations, enhancing collaboration and usability.
NEW QUESTION # 41
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 # 42
Which statement is true about Theme Styles in Oracle APEX?
- A. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.
- B. Theme Styles control the layout of a webpage.
- C. The "Is Current" attribute of a Theme Style depends on the "Read Only" attribute.
Answer: A
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 # 43
Which two actions does the Create Application Wizard allow?
- A. Changing the application authorization.
- B. Adding or deleting application pages.
- C. Uploading JavaScript or CSS files required for an application.
- D. Reordering application pages.
Answer: B,D
Explanation:
The Create Application Wizard streamlines app creation with:
Adding or deleting application pages: Allows users to define initial pages (e.g., Home, Reports) and remove unwanted ones during the wizard process.
Reordering application pages: Provides drag-and-drop or list-based reordering of pages to set the navigation sequence.
Uploading JavaScript or CSS: This occurs post-creation in Shared Components, not within the wizard.
Changing the application authorization: Authorization schemes are set after creation, not during the wizard.
This wizard is a time-saver for rapid prototyping, offering a guided yet flexible setup.
NEW QUESTION # 44
Which two tasks can be performed by the APEX Assistant when you create an application using the "Create App using Generative AI" option?
- A. Create a Generative AI service.
- B. Create the application blueprint.
- C. Add a Dashboard page.
- D. Update the App icon with a custom image.
Answer: B,C
Explanation:
The "Create App using Generative AI" feature in APEX Assistant leverages natural language processing to automate application creation. When invoked:
Create the application blueprint: APEX Assistant generates a foundational structure (blueprint) for the application, including pages, regions, and navigation, based on the user's natural language input (e.g., "Create an app to manage employees"). This blueprint serves as the starting point, which developers can refine.
Add a Dashboard page: The Assistant can interpret requests for specific page types, such as dashboards, and include them in the generated app. Dashboards typically feature charts, summaries, or key metrics, and this is a common task supported by the AI-driven creation process.
Create a Generative AI service: This is not a task performed during app creation; instead, it's a prerequisite configuration step done separately in the Instance Administration settings.
Update the App icon: While app icons can be customized manually post-creation, this is not an automated task performed by APEX Assistant during the generative process.
This feature streamlines development by interpreting intent and building functional components, saving significant time compared to manual creation.
NEW QUESTION # 45
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 the faceted search region Attributes, and disable the Batch Facet Changes attribute.
- B. Navigate to each facet and then in the Property Editor, turn on Client-Side Filtering.
- C. Navigate to the faceted search region Attributes, and turn off the Show Facet Name attribute.
Answer: A
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 # 46
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. Popup LOV
- B. Date Picker
- 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 # 47
Which three Theme Components are available out-of-the-box with the Universal Theme?
- A. Calendar
- B. Badge
- C. Comments
- D. REST Data Sources
Answer: A,B,C
Explanation:
The Universal Theme (Theme 42) provides pre-built components:
A . Calendar: A region type for date-based displays (e.g., events), styled with Universal Theme templates (e.g., FullCalendar integration).
B . Comments: A region type for user feedback or notes, with built-in styling and moderation options.
C . Badge: A UI component for displaying counts or statuses (e.g., "5 New"), often in navigation or lists, styled via CSS classes.
D . REST Data Sources: A data feature, not a theme component; it's a Shared Component, not a UI element tied to Universal Theme.
Technical Insight: These components leverage Universal Theme's CSS (e.g., t-Badge, t-Calendar) and JavaScript for interactivity, reducing custom coding.
Use Case: A dashboard with a Calendar for schedules, Comments for feedback, and Badges for unread alerts.
Pitfall: Customizing requires Theme Roller or CSS overrides.
NEW QUESTION # 48
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. GET
- B. POST
- 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 # 49
......
Study HIGH Quality 1Z1-771 Free Study Guides and Exams Tutorials: https://passleader.briandumpsprep.com/1Z1-771-prep-exam-braindumps.html
