[Nov 13, 2025] Download Free Oracle 1Z0-771 Real Exam Questions
Pass Your Exam With 100% Verified 1Z0-771 Exam Questions
NEW QUESTION # 25
What happens when you regenerate credentials for Push Notifications in Oracle APEX?
- A. Existing Push Subscriptions for the application will be invalidated.
- B. Push Notifications will be disabled for the application.
- C. A new notification server must be created.
Answer: A
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
Which two tasks can be performed by the APEX Assistant when you create an application using the "Create App using Generative AI" option?
- A. Add a Dashboard page.
- B. Update the App icon with a custom image.
- C. Create the application blueprint.
- D. Create a Generative AI service.
Answer: A,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 # 28
Which two Query Source types can be used to create a dynamic LOV?
- A. Function Returning SQL Query
- B. Procedure
- C. Select List
- D. SQL Query
Answer: A,D
Explanation:
A dynamic List of Values (LOV) in APEX populates options based on a query source. The supported types include:
Function Returning SQL Query: A PL/SQL function that returns a SQL query string (e.g., RETURN 'SELECT ename, empno FROM emp';). This offers flexibility for dynamic conditions or complex logic.
SQL Query: A direct SQL statement (e.g., SELECT ename, empno FROM emp) executed at runtime to fetch LOV values. It's the simplest and most common approach.
Procedure: Procedures execute logic but don't return query results in the format required for an LOV (they don't produce a result set directly).
Select List: This is a UI component, not a query source type for defining an LOV.
Dynamic LOVs enhance user interaction by providing real-time, data-driven options, critical for forms and filters.
NEW QUESTION # 29
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 turn off the Show Facet Name attribute.
- B. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute.
- C. Navigate to each facet and then in the Property Editor, turn on Client-Side Filtering.
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 # 30
Which statement is true about Theme Styles?
- A. Theme Styles control the layout of a webpage.
- B. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.
- C. The "Is Current" attribute of a Theme Style depends on the "Read Only" attribute.
Answer: B
Explanation:
Theme Styles define visual themes in APEX:
A . When the Is Public attribute is enabled: Setting "Is Public" to "Yes" in Shared Components > Theme Styles allows runtime selection (e.g., via a dropdown in the app UI), letting users switch between styles (e.g., "Vita" to "Vita - Dark").
B . Control layout: False; layout is managed by templates and regions; Theme Styles handle colors, fonts, etc.
C . "Is Current" depends on "Read Only": False; "Is Current" marks the default style, independent of "Read Only" (which locks editing).
Technical Insight: Public styles require multiple defined styles and a UI component (e.g., Dynamic Action) to expose the switcher.
Use Case: Offering light/dark mode options to users.
Pitfall: Without a switcher, "Is Public" has no visible effect.
NEW QUESTION # 31
Which statement is true about Theme Styles in Oracle APEX?
- A. Theme Styles control the layout of a webpage.
- B. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.
- C. The "Is Current" attribute of a Theme Style depends on the "Read Only" attribute.
Answer: B
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 # 32
You created a custom theme for an application. Examine these requirements: (Assuming requirements mandate syncing changes). Which solution guarantees that any changes to the master theme are reflected in the copied theme?
- A. Refreshing the templates.
- B. Copying the changes made in the master theme to the copied theme.
- C. Verifying the theme subscription.
- D. Subscribing the copied theme to the master theme and refreshing the theme.
Answer: D
Explanation:
Theme subscription links a copied theme to its master:
A . Subscribing and refreshing: Subscribing the copied theme (in Shared Components > Themes) to the master ensures it inherits updates. "Refresh Theme" (via Theme Roller or Utilities) syncs changes (e.g., CSS, templates) from the master, guaranteeing consistency.
B . Refreshing templates: Only updates individual templates, not the entire theme.
C . Copying changes: Manual, error-prone, and not guaranteed.
D . Verifying subscription: Confirms the link but doesn't sync changes.
Use case: Ideal for maintaining branded consistency across apps.
NEW QUESTION # 33
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. Welcome Message
- B. AI Assistant Name
- C. Initial Prompt
Answer: A
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 # 34
Which three Theme Components are available out-of-the-box with the Universal Theme?
- A. Comments
- B. Calendar
- C. REST Data Sources
- D. Badge
Answer: A,B,D
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 # 35
Which two statements are true about faceted search pages?
- A. Facets map to specific database columns.
- B. A facet's chart can be seen only in a nonmodal dialog.
- C. Faceted Search supports the ability to filter columns storing multiple values.
- D. Multiple charts are not visible in the same region.
Answer: A,C
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 # 36
Which two tasks can be performed by using the Generate Text with AI Dynamic Action?
- A. Summarize or translate text
- B. Invoke a Workflow
- C. Update the underlying database tables
- 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 # 37
Which statement is true about importing an existing application into your workspace?
- A. The import process does not import the supporting objects defined during the export.
- B. You cannot import an APEX application exported from the latest APEX version to an old APEX version.
- C. You cannot change the application ID during the import process.
Answer: B
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 # 38
Which three statements are true about Data Workshops in Oracle APEX?
- A. You can unload data from a new or existing table.
- B. You can load or unload a single table at a time.
- C. You can load data into a new or existing table.
- D. You can load or unload multiple tables at a time.
Answer: A,B,C
Explanation:
Data Workshop in SQL Workshop is a powerful tool for importing/exporting table data:
B . You can load or unload a single table at a time: The wizard focuses on one table per operation. For loading, you upload a file (e.g., CSV) and map it to a single table; for unloading, you select one table to export (e.g., EMP to CSV). This granularity ensures precision and simplicity.
C . You can unload data from a new or existing table: Unloading (exporting) works on any table in the schema, whether newly created (e.g., via Quick SQL) or pre-existing (e.g., DEPT). The "Unload" option generates a file (e.g., CSV, JSON) from the table's data.
D . You can load data into a new or existing table: Loading supports creating a new table from the uploaded file (e.g., CSV defines NEW_EMP) or appending/overwriting an existing one (e.g., EMP). The wizard prompts for table creation or selection.
A . You can load or unload multiple tables at a time: False; Data Workshop processes one table per wizard run. Multiple tables require separate operations or custom SQL scripts.
Technical Insight: Loading uses APEX_DATA_LOADING internally, parsing files into rows, while unloading leverages APEX_DATA_EXPORT. For example, uploading emp.csv with "Create New Table" generates a table with inferred columns.
Use Case: Migrating EMP data from a legacy system (CSV) into APEX, then exporting it later for analysis.
Pitfall: Multi-table operations need SQL Scripts or external tools like SQL Developer.
NEW QUESTION # 39
You must use a Static Content region type to display messages about the employee of the month. Which text, when placed in this region, will display the message correctly?
- A. Join me in congratulating & P1_ENAME. as the new employee of the month!
- B. Join me in congratulating V('P1_ENAME') as the new employee of the month!
- C. Join me in congratulating: &P1_ENAME. as the new employee of the month!
- D. Join me in congratulating: P1_ENAME as the new employee of the month!
Answer: C
Explanation:
Static Content regions display fixed text with substitution:
B . &P1_ENAME.: The &ITEM_NAME. syntax substitutes the value of P1_ENAME at runtime (e.g., "Join me in congratulating: John as..."), correctly rendering the item's value. The dot ensures proper parsing.
A . P1_ENAME: Treated as literal text, not substituted.
C . V('P1_ENAME'): A PL/SQL function, invalid in static content; it's for server-side code.
D . & P1_ENAME.: Space before P1_ENAME breaks substitution syntax.
Pitfall: Ensure P1_ENAME is populated (e.g., via a page process) to avoid blank output.
NEW QUESTION # 40
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 send emails using the APEX_MAIL package from an Oracle APEX application.
- D. You can add files as attachments to your emails using the APEX_MAIL package.
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 # 41
What do you achieve by performing the "Refresh Working Copy" task?
- A. Merge the Working Copy changes with the Main application.
- B. Update the changes from one Working Copy to another.
- C. Get the latest updates from the Main application.
Answer: C
Explanation:
Working Copies in APEX allow safe experimentation:
C . Get the latest updates from the Main application: "Refresh Working Copy" (in App Builder > Working Copies) pulls changes from the Main application into the Working Copy, ensuring it reflects the latest state (e.g., new pages, fixes) without overwriting Working Copy changes.
A . Merge with Main: Merging is a separate "Merge Working Copy" task.
B . Update between Working Copies: Not supported; refreshing is Main-to-Working only.
Practical note: Use this to sync collaborative development efforts.
NEW QUESTION # 42
How many instances of a Workflow can exist in the "In Development" state?
- A. Unlimited
- B. 0
- 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 # 43
Which search type in keywords do they represent in Oracle Text?
- A. List
- B. Standard
- C. Oracle Text
Answer: C
Explanation:
In Oracle APEX, when configuring search functionality (e.g., in reports or faceted search), "Oracle Text" refers to a specific search type leveraging the Oracle Text engine. This is a powerful full-text search capability built into Oracle Database, supporting keyword-based searches, fuzzy matching, and indexing.
Standard: A basic SQL-based search (e.g., LIKE), not tied to Oracle Text.
List: Not a search type; it might refer to a UI component or LOV, not a search mechanism.
Oracle Text: Explicitly uses the CONTAINS operator and text indexes (e.g., CONTEXT or CTXCAT) for advanced search features, ideal for large datasets or complex queries.
This choice impacts performance and accuracy, especially in text-heavy applications.
NEW QUESTION # 44
Which two actions does the Create Application Wizard allow?
- A. Adding or deleting application pages.
- B. Changing the application authorization.
- C. Uploading JavaScript or CSS files required for an application.
- D. Reordering application pages.
Answer: A,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 # 45
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. Verify that Friendly URLs are turned on in the Application Definition.
- C. Enable the PWA flag in the Application Definition.
- D. Add custom JavaScript to support offline functionality.
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 # 46
Which two are valid evaluation points for Authorization Schemes?
- A. Never
- B. Once per page view
- C. Once per session
- D. Once per user
Answer: B,C
Explanation:
Authorization Schemes in APEX can be evaluated at:
Once per page view: Checks authorization each time a page is rendered.
Once per session: Checks once per user session, caching the result.
Once per user and Never are not valid evaluation points in the Authorization Scheme settings.
NEW QUESTION # 47
......
1Z0-771 Dumps 100 Pass Guarantee With Latest Demo: https://www.pass4suresvce.com/1Z0-771-pass4sure-vce-dumps.html
1Z0-771 Dumps PDF - 1Z0-771 Real Exam Questions Answers: https://drive.google.com/open?id=1aHNxLL0GIhNNDo_Kr1-GnRG-3I_XBh8m