1Z0-771 Oracle Apex Cloud

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?. Popup LOV. Range. Date Picker. Checkbox Group.

Which two SQL format options does the APEX Assistant provide when using the "Create Data Model using AI" feature?. Quick SQL. MySQL. Oracle SQL. Oracle PL/SQL.

At what level does a developer enable push notifications so that end users can receive them on their devices from an APEX application?. Region. Application. Page. Instance.

In which two formats can the GetCurrentPosition Dynamic Action in Oracle APEX return coordinates?. Function Body returning SQL Query. Latitude and Longitude. GeoJSON. State and Pincode.

Which two approaches can be used to create custom stored procedures in SQL Workshop?. Using Quick SQL. Using Data Workshop. Using SQL Scripts. Using Object Browser.

Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?. Create a database link to the remote Oracle Database in the local APEX schema. Install ORDS 19.x or later on the remote Oracle Database. REST-enable the schema in the remote Oracle Database by using ORDS.ENABLE_SCHEMA. Install Oracle APEX in the remote Oracle Database.

Which statement is true about the Data Workshop utility?. You cannot load data from an XLSX file with multiple worksheets. The wizards load and unload all types of schema objects. The wizards load and unload table data only. You can load or unload multiple tables at a time.

Which two declarative options in Oracle APEX allow you to download BLOB/CLOB content?. Download Dynamic Action. APEX_UTIL.DOWNLOAD PL/SQL API. Download Page Process. Share Dynamic Action.

An APEX e-commerce application is being used by 50 users. You have a promotional offer, and you need to send a push notification to all the subscribed users on their devices. Which step must be performed in Oracle APEX to achieve this?. Create a Dynamic Action of Send Push Notification type to send push notifications to all the subscribed users. Enable push notifications at the application level and let APEX handle the subscription and delivery process automatically. Create a REST Data Source to send push notifications to all the subscribed users. Create a PL/SQL block to fetch all the subscribed users and send push notifications by using APEX_APPL_PUSH_SUBSCRIPTIONS & APEX_PWA.SEND.

What are two reasons to enable the "Used by App Builder" option while creating a Generative AI Service?. To create a Working Copy of your application. To create a REST-enabled database object. To author SQL powered by Generative AI. To build applications using natural language powered by Generative AI.

Which two are valid evaluation points for Authorization Schemes?. Once per user. Once per page view. Never. Once per session.

How many instances of a Workflow can exist in the "In Development" state?. 50. 1. Unlimited.

Which two tasks can be performed by using the Generate Text with AI Dynamic Action?. Draft an email. Update the underlying database tables. Invoke a Workflow. Summarize or translate text.

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?. Classic Report. Interactive Report. Column Toggle Report. Interactive Grid.

In your application, you want to display data in a searchable, customizable report that supports inline editing at runtime using the mouse or keyboard. Which report type will you create?. Smart Filters. Interactive Report. Interactive Grid. Classic Report.

Which two tasks can be performed by the APEX Assistant when you create an application using the "Create App using Generative AI" option?. Create a Generative AI service. Create the application blueprint. Add a Dashboard page. Update the App icon with a custom image.

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?. Welcome Message. Initial Prompt. AI Assistant Name.

Which two AI Service Providers are supported by Oracle APEX?. OCI Document AI. OpenAI. Jarvis. OCI Generative AI.

Which two Query Source types can be used to create a dynamic LOV?. Procedure. Function Returning SQL Query. Select List. SQL Query.

Which client credentials are used for authentication during the 'Check Syntax' process? Which client credentials are used for authentication during the One-Click Remote Application Deployment process?. Database schema credentials. APEX Workspace Admin credentials. APEX Developer credentials.

Which step is mandatory to make an existing Oracle APEX application Progressive Web App (PWA) enabled?. Enable the PWA flag in the Application Definition. Verify that Friendly URLs are turned on in the Application Definition. Add custom JavaScript to support offline functionality. Enable RESTful Web Services in the application.

You have an Interactive Grid component and you are enabling the Save Report functionality. As what can end users save the report type?. As Private and Primary only. As Private and Public only. As Primary.

Which search type in keywords do they represent in Oracle Text?. Standard. List. Oracle Text.

Which two statements are true about faceted search pages?. Faceted Search supports the ability to filter columns storing multiple values. Multiple charts are not visible in the same region. A facet’s chart can be seen only in a nonmodal dialog. Facets map to specific database columns.

What must be done in the Page Designer so that report filtering is automatically executed when any facet value is selected?. Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute. Navigate to the faceted search region Attributes, and turn off the Show Facet Name attribute. Navigate to each facet and then in the Property Editor, turn on Client-Side Filtering.

Which two actions does the Create Application Wizard allow?. Uploading JavaScript or CSS files required for an application. Adding or deleting application pages. Changing the application authorization. Reordering application pages.

Which statement is true about the Link Column attributes of an Interactive Report?. It is not possible to include a custom target in Link Column. It is not possible to exclude Link Column. If you select Link Column, it is always displayed as the last column in the report. A Link Column cannot be sorted, hidden, or moved by an end user.

Which two statements are true about creating and using dynamic actions?. After you create a dynamic action, you cannot add more true actions. If a client-side condition is defined, the true action will fire when the condition is met. You can execute JavaScript code by creating a dynamic action. If no client-side condition is defined, true actions will not fire.

Which is NOT an available Geometry Column data type for the map region?. GeoJSON. SDO_GEOMETRY. JSON OBJECT. Latitude/Longitude.

Which two statements are true about Oracle APEX?. APEX eliminates middle tier application logic. Running an APEX app needs client software. You can build interactive reporting apps based on data from disparate systems. Application definition is not stored in the database.

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?. Popup LOV. Switch. Checkbox.

You must create a single master detail page where users can select a row in the master region and see the corresponding details in the detail region. Users must also interact with the master or the detail without leaving the page. Which type of master detail implementation should you use?. Drill Down. Stacked. Side by Side.

Which two statements are true about creating and managing an APEX Workspace?. During workspace creation, you can associate the workspace with an existing database schema. New schemas cannot be created during workspace creation. A workspace can be associated with only one schema. You can create only two workspaces in an APEX Service (APEX Application Development) instance. A workspace enables multiple users to work within the same Oracle APEX installation.

Which two actions are performed by using the Object Browser?. Restore dropped database objects. Browse database objects of the current schema. Create and run SQL scripts. Create a lookup table based on a column in the current table.

Which two statements are true about the APEX_MAIL API?. You can add files as attachments to your emails using the APEX_MAIL package. You can receive emails using the APEX_MAIL package in an Oracle APEX application. You can send emails using the APEX_MAIL package from an Oracle APEX application. The APEX_MAIL package supports sending emails only to Oracle database users.

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?. POST. GET. PUT.

Which Process type do you use to run multiple processes in the background in APEX?. Execute Code. Execute Server-side Code. Execute JavaScript Code. Execution Chain.

Which two layout modes are available for Page Designer under Utilities?. Two Pane. Three Pane. Four Pane. Single Pane.

Which three data types are supported by Oracle APEX Workflow parameters and item types?. Image. NUMBER. CLOB. VARCHAR.

Which statement is true about Theme Styles in Oracle APEX?. Theme Styles control the layout of a webpage. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment. The "Is Current" attribute of a Theme Style depends on the "Read Only" attribute.

You created a custom theme for an application. Examine these requirements: > The theme must be utilized by another application in the same workspace > The master theme may still require changes Which solution guarantees that any changes to the master theme are reflected in the copied theme?. Subscribing the copied theme to the master theme and refreshing the theme. Refreshing the templates. Copying the changes made in the master theme to the copied theme. Verifying the theme subscription.

What do you achieve by performing the "Refresh Working Copy" task?. Merge the Working Copy changes with the Main application. Update the changes from one Working Copy to another. Get the latest updates from the Main application.

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?. Removing P1_SALARY from the validation Associated Item. Setting Value Required to Yes on P1_SALARY. Setting Display Location to Inline in Notification.

Which component of the Push Notifications feature stores the messages that are ready to be sent?. Queue. Application. Subscription.

Which three statements are true about Data Workshops in Oracle APEX?. You can load or unload multiple tables at a time. You can load or unload a single table at a time. You can unload data from a new or existing table. You can load data into a new or existing table.

Which two Plugin types can be created in Oracle APEX?. Validation. Email Template. Process. Region.

Which statement is true about importing an existing application into your workspace?. You cannot change the application ID during the import process. The import process does not import the supporting objects defined during the export. You cannot import an APEX application exported from the latest APEX version to an old APEX version.

Which API can be used to send Push Notifications immediately in Oracle APEX?. APEX_PWA.HAS_PUSH_SUBSCRIPTION. APEX_PWA.PUSH_QUEUE. APEX_PWA.PURGE_QUEUE.

Which is a valid method of logging messages to the execution log in APEX applications?. apex_automation.log_info ('SAL for ' || :ENAME || ' increased by 19.');. apex_debug.info ('SAL for :ENAME ||' increased by 19.');. apex_error.add_error ('SAL for ' || :ENAME || ' increased by 19.');.

Which three Theme Components are available out-of-the-box with the Universal Theme?. Calendar. Comments. Badge. REST Data Sources.

What happens when you regenerate credentials for Push Notifications in Oracle APEX?. Existing Push Subscriptions for the application will be invalidated. A new notification server must be created. Push Notifications will be disabled for the application.

Which statement is true about Theme Styles?. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment. Theme Styles control the layout of a webpage. The "Is Current" attribute of a Theme Style depends on the "Read Only" attribute.

Which key component of Oracle APEX defines the structure of an application, including pages, navigation, and UI components?. SQL Workshop. Application Builder. Shared Components. Websheet Applications.

Which component in Oracle APEX allows developers to create and manage database objects such as tables and views?. SQL Workshop. Team Development. App Gallery. APEX Service Console.

Which two Oracle APEX components allow users to integrate external data sources and interact with REST APIs? (Choose two). REST Data Source. SQL Workshop. Websheet Applications. RESTful Web Services.

What is the primary function of an APEX Workspace?. A schema that stores all APEX applications. A development environment assigned to users or teams. A database table used for application configuration. An API for managing APEX applications programmatically.

Which authentication method is not natively supported by Oracle APEX?. Database Authentication. Social Sign-In (OAuth2). LDAP Directory Authentication. Blockchain-based Authentication.

How can a developer create an APEX Workspace in the Autonomous Database?. Use SQL Developer to create the workspace. Navigate to APEX Administration and create a new workspace. Directly create a schema and link it to APEX. Create a new RESTful service for the workspace.

Which two authentication methods can be used in Oracle APEX to secure access to applications? (Choose two). Single Sign-On (SSO). REST API Authentication. Database Authentication. Websheet Security.

Which feature allows Oracle APEX users to access external RESTful web services?. Data Loading Wizard. REST Data Source. SQL Query Builder. Websheet Applications.

Which Oracle APEX tool is used to export and import applications between environments?. SQL Developer. Application Export/Import. RESTful Services. Web Source Modules.

What is the purpose of Shared Components in Oracle APEX?. To define reusable elements across multiple applications. To store session data for users. To define user permissions and authentication settings. To create and manage database schema objects.

Which of the following is not a benefit of using Oracle APEX on Autonomous Database?. Automatic patching and updates. Fully managed infrastructure. On-premise database management. Built-in security and performance optimization.

Which APEX feature enables version control and collaboration for development teams?. SQL Workshop. Team Development. RESTful Web Services. Data Grids.

What is the default port for accessing Oracle APEX on Autonomous Database?. 443. 1521. 8080. 5000.

Which reporting component allows users to filter, sort, and analyze data interactively?. Classic Report. Interactive Report. Web Source Module. REST Data Source.

How does Oracle APEX handle session state management?. Storing session variables in browser cache. Using database session attributes. Assigning session IDs dynamically. Creating temporary database tables.

Which APEX tool helps monitor application performance and identify bottlenecks?. SQL Developer. Application Express Advisor. Database Performance Monitor. APEX Debug Mode.

Which APEX component is used to create custom navigation menus?. List Manager. Dynamic Actions. REST Data Source. Page Items.

Which action grants a new developer workspace access in APEX?. Create a new database user. Assign workspace roles and privileges. Restart the APEX service. Grant SYSDBA privileges.

Which method is used to deploy an APEX application on another instance?. Exporting and importing the application. Using Data Pump export/import. Cloning the Autonomous Database. Running an SQL script.

Which security feature is enabled by default in Oracle APEX?. SSL encryption. SQL Injection Protection. Dynamic Data Masking. Blockchain Authentication.

Which SQL Workshop tool allows you to create tables, views, and sequences interactively?. Query Builder. Object Browser. SQL Commands. RESTful Web Services.

Which SQL Workshop feature is best suited for writing and executing individual SQL statements?. Object Browser. SQL Commands. Quick SQL. SQL Scripts.

Which two options allow the creation of database objects in SQL Workshop? (Choose two). Object Browser. Quick SQL. Data Loading Wizard. Team Development.

What does the Data Workshop utility in APEX allow users to do?. Run PL/SQL procedures. Manage database triggers. Load and unload data. Debug SQL queries.

Which SQL Workshop tool allows batch execution of multiple SQL commands?. SQL Commands. SQL Scripts. Object Browser. Query Builder.

Which tool in SQL Workshop provides a visual interface to construct SQL queries?. Object Browser. Query Builder. SQL Scripts. Quick SQL.

Which Quick SQL feature helps generate table relationships automatically?. Relationship Builder. Foreign Key Assistant. Schema Generator. Primary Key Auto-Link.

Which two actions can be performed using Quick SQL in SQL Workshop? (Choose two). Create tables and relationships. Generate PL/SQL procedures. Generate DDL scripts. Export database schemas.

Which statement is true about running SQL commands in SQL Workshop?. Queries must always include a commit statement. Only SELECT statements can be executed. DML and DDL statements can be executed. It does not support bind variables.

Which Oracle APEX tool is best suited for writing complex SQL scripts for execution?. Query Builder. Quick SQL. SQL Scripts. Object Browser.

Which Data Workshop feature allows importing large datasets into APEX applications?. Data Grid. CSV Data Import. Quick SQL. Web Source Modules.

Which two data formats are supported by Data Workshop for importing data? (Choose two). CSV. JSON. XML. HTML.

Which Data Workshop feature helps extract data from an Oracle APEX database?. Data Unload. Schema Exporter. Quick SQL. REST API Generator.

Which tool in SQL Workshop allows for bulk loading of external data into database tables?. SQL Commands. Data Loading Wizard. Object Browser. Query Builder.

Which two actions can be performed using the Data Workshop utility? (Choose two). Import data into tables. Export table data as CSV or XML. Modify database triggers. Create stored procedures.

Which file format is not supported by Data Workshop for importing data?. CSV. XML. Excel (XLSX). SQL.

Which Data Workshop feature ensures correct data mapping during import?. Column Mapping Tool. Foreign Key Validator. Schema Verifier. Quick Data Loader.

Which action should be taken after loading data using Data Workshop?. Perform a commit operation. Restart the database instance. Recompile dependent PL/SQL packages. Enable auto-indexing.

Which Oracle APEX utility allows users to review and manage past data imports?. Data Loading History. Import Log Viewer. SQL Commands. Object Browser.

Which feature in Data Workshop provides options for handling duplicate records during import?. Data Merge Options. Unique Constraint Manager. Duplicate Record Handler. Column Mapping Rules.

Which of the following statements is true when creating a table using Object Browser?. You must manually write the SQL CREATE TABLE statement. Constraints can only be added after table creation. The interface allows defining columns, data types, and constraints. Tables must be created using a separate SQL script.

Which two database objects can be modified using SQL Workshop? (Choose two). Sequences. Synonyms. Database Links. Views.

Which of the following is a primary use of SQL Workshop’s Query Builder?. Writing and executing PL/SQL procedures. Visually constructing SQL queries. Importing and exporting data. Managing authentication settings.

What happens when you modify an existing column in Object Browser?. Changes are applied immediately to all existing data. The database must be restarted for changes to take effect. Some modifications may require dropping and recreating the table. Existing data types cannot be altered after table creation.

Which SQL Workshop tool is best for executing single SQL statements?. SQL Scripts. Query Builder. Object Browser. SQL Commands.

Which two options are available when generating SQL using Quick SQL? (Choose two). Creating RESTful Web Services. Defining relationships between tables. Generating SQL scripts for multiple schemas. Adding sample data to generated tables.

Which SQL Workshop feature allows developers to store and run multiple SQL statements as a batch?. Query Builder. Object Browser. SQL Scripts. SQL Commands.

What is the primary function of Data Workshop in SQL Workshop?. Generating database triggers. Automating database indexing. Loading and unloading data. Scheduling batch jobs.

Which method can be used to create an APEX application from an existing database table?. Using SQL Commands. Using the Create Application Wizard. Manually coding each page in PL/SQL. Creating a RESTful Web Service.

Which file formats can be used to create an APEX application from a file? (Choose two). CSV. JSON. TXT. XLSX.

What is the primary advantage of using the Create Application Wizard?. It generates complex SQL queries automatically. It provides a code-free way to build applications. It restricts developers to predefined UI components. It requires advanced PL/SQL knowledge.

Which two components are automatically created when generating an application from a table? (Choose two). Interactive Report. Data Trigger. Form Page. RESTful Web Service.

Which feature in APEX helps in modifying an application after it has been created?. Page Designer. SQL Workshop. RESTful Web Services. Team Development.

Which component of App Builder is responsible for managing database objects and SQL queries?. Shared Components. SQL Workshop. Application Utilities. Web Source Modules.

What is the purpose of the Shared Components section in App Builder?. To create and manage reusable UI elements. To execute SQL commands. To define external authentication methods. To track application logs.

Which two types of reports can be generated using App Builder? (Choose two). Interactive Reports. Data Guard Reports. Classic Reports. Oracle BI Reports.

What is the main function of Page Designer in App Builder?. To design the database schema. To manage workspace users. To visually modify application pages. To configure server settings.

Which APEX feature allows developers to create an application that can connect to external RESTful web services?. RESTful Data Source. Application Gallery. Page Utilities. Session State.

Which step is required before creating an APEX application from an uploaded file?. Manually create a database table. Convert the file to SQL format. Map file columns to database columns. Enable RESTful Web Services.

Which two data formats can be imported using Data Workshop to create an APEX application? (Choose two). JSON. CSV. Parquet. Excel (XLSX).

Which tool can be used to generate SQL scripts for creating database objects before building an APEX application?. Query Builder. Quick SQL. RESTful Web Services. Page Designer.

Which two components are automatically created when building an APEX application from an uploaded file? (Choose two). Interactive Report. Authentication Scheme. Form Page. RESTful Web Service.

Which feature helps ensure data integrity when creating an APEX application from an external file?. Indexing every column automatically. Enforcing constraints during data mapping. Converting all text fields to VARCHAR2. Creating triggers for each imported record.

What is the primary function of App Builder in Oracle APEX?. Managing SQL queries. Creating and modifying applications. Configuring database storage. Monitoring database performance.

Which App Builder feature allows developers to define global navigation elements?. Shared Components. Web Source Modules. Interactive Reports. SQL Workshop.

Which two page types are commonly created when using App Builder? (Choose two). Classic Report. Calendar. Data Guard Report. Clustered Index.

Which feature in App Builder provides a visual interface to modify page elements?. SQL Workshop. Page Designer. Query Builder. RESTful Web Services.

Which App Builder feature allows developers to create application-level settings and reusable UI elements?. Team Development. SQL Commands. Shared Components. Session State.

Which page type is best suited for displaying tabular data with sorting and filtering options?. Classic Report. Interactive Report. List View. Calendar.

Which two region types are commonly used for data visualization? (Choose two). Chart. Interactive Grid. Form. Timeline.

Which region type is designed to display multiple columns and allow inline editing?. Classic Report. Interactive Grid. List View. Calendar.

Which APEX feature allows the creation of a multi-step wizard for user input?. Modal Dialog. List View. Wizard Page. Breadcrumb Navigation.

Which two page types are best suited for displaying user-input forms? (Choose two). Form. List View. Modal Dialog. Classic Report.

What is the purpose of a Static Content Region in Oracle APEX?. To display non-editable text, images, or HTML. To store data permanently in a table. To execute PL/SQL procedures. To filter report data dynamically.

Which region template is used to display hierarchical data structures like folders and menus?. Tree. Classic Report. Timeline. Chart.

Which APEX feature allows side-by-side comparison of different reports in a single page?. Modal Dialog. Interactive Grid. Region Display Selector. Classic Report.

Which two region types are most suitable for user navigation? (Choose two). Breadcrumb. List. Classic Report. Calendar.

Which type of region allows embedding of external content like videos or iframes?. Static Content. HTML Region. Chart Region. List View.

Which tool in APEX is used to modify pages and UI elements visually?. SQL Workshop. Page Designer. Quick SQL. RESTful Web Services.

Which Page Designer feature allows developers to view all components on a page in a tree structure?. Rendering Tree. Property Editor. Gallery View. SQL Commands.

Which component in Page Designer allows defining form validation rules?. Dynamic Actions. SQL Workshop. Processing. Security Schemes.

Which feature in Page Designer allows adding interactivity, such as show/hide actions and validations?. SQL Commands. Dynamic Actions. Session State. RESTful Web Services.

Which two components can be conditionally displayed based on user input in Page Designer? (Choose two). Items. Buttons. SQL Queries. RESTful Services.

Which action in Page Designer allows moving elements between different regions on the same page?. Drag-and-drop in the Rendering Tree. Running SQL Scripts. Using RESTful Web Services. Changing Authentication Scheme.

Which property in Page Designer determines the initial value of an item when the page loads?. Source. Condition. Dynamic Action. Session State.

Which Page Designer component is used to define form submission processes?. Processing. Dynamic Actions. Breadcrumbs. List Manager.

Which Page Designer section allows modifying navigation menus?. Shared Components. SQL Workshop. RESTful Web Services. Processing.

Which feature in Page Designer helps developers quickly switch between desktop and mobile views?. Theme Roller. Rendering Tree. Component View. Session State Monitor.

Which two report types allow end-users to dynamically filter and sort data? (Choose two). Classic Report. Interactive Report. Cards Region. Interactive Grid.

Which feature in Interactive Reports allows users to create multiple saved report versions?. Group By. Flashback Queries. Report Subscription. Saved Reports.

Which customization option is not available in a Classic Report?. Column Filtering. Pagination. Column Grouping. Computed Columns.

Which two types of items can be linked in a Report with Form to navigate between pages? (Choose two). Button. Text Field. Link Column. Checkbox.

Which component in Interactive Grids allows end-users to modify data inline?. Edit Mode. Grid Actions Menu. Bulk Update. Row Selector.

Which type of report is best suited for displaying images with metadata?. Interactive Report. Cards Region. Faceted Search. Smart Filters.

Which feature in a Faceted Search page allows users to dynamically refine results?. Page Computations. SQL Filtering. Search Facets. Interactive Grid.

Which Interactive Grid feature allows users to apply dynamic filters without reloading the page?. Dynamic Actions. Grid Toolbar. Filter Bar. Theme Roller.

Which two customization options are available for Cards Regions? (Choose two). Custom CSS Styling. REST Data Source. Column Grouping. SQL Flashback.

Which report type automatically provides an Actions Menu for filtering, saving, and customizing data?. Classic Report. Interactive Report. Cards Region. Smart Filters.

Which feature in an Interactive Grid allows an end-user to reorder columns?. Theme Roller. Column Drag & Drop. Grid Locking. Grid Templates.

Which type of report allows the comparison of multiple sets of filter criteria on the same page?. Smart Filters. Faceted Search. Interactive Report. Classic Report.

Which two features allow users to export Interactive Reports? (Choose two). Export to Excel. JSON Data Feed. Print to PDF. SQL Export.

Which feature in a Classic Report allows adding computed columns dynamically?. SQL Expressions. Computed Columns. Column Formatting. Dynamic Actions.

Which feature in Smart Filters enables searching across multiple attributes?. Multi-Field Search. Facet Configuration. Data Synchronization. Region Source.

Which type of page is automatically created when adding Faceted Search to an application?. Report Page. Search and Results Page. Interactive Grid Page. Navigation Page.

Which Interactive Report feature allows users to define and save their own column layouts?. Grid Locking. Saved Reports. Query Builder. Page Designer.

Which feature allows Interactive Grids to display totals for numeric columns?. SQL Query Summaries. Column Aggregation. Theme Roller. Dynamic Actions.

Which report type is best for mobile-friendly layouts with image-based navigation?. Smart Filters. Faceted Search. Cards Region. Classic Report.

Which APEX component allows exporting reports to CSV format?. REST API. Actions Menu. Region Source. SQL Workshop.

Which feature in Interactive Grids allows users to apply conditional formatting to highlight specific values?. Grid Actions Menu. Highlighting. Dynamic Actions. Region Caching.

Which two customization options are available for Cards Regions in APEX? (Choose two). Custom CSS Styling. Editable Fields. REST Data Source. Data Aggregation.

Which Interactive Grid feature enables users to quickly update multiple records at once?. Editable Grid Rows. Bulk Edit. Page-Level Computation. SQL Flashback.

Which APEX report type allows users to save custom filter settings for future use?. Classic Report. Interactive Report. Cards Region. Smart Filters.

Which Smart Filter feature allows users to apply search criteria to multiple columns at once?. Multi-Facet Query. Global Search. Search Assist. Filter Synchronization.

Which Faceted Search feature allows users to modify filters dynamically without reloading the page?. AJAX-Based Filtering. Report Actions Menu. Column Sorting. Pagination.

Which two customization options are available in an Interactive Grid? (Choose two). Column Reordering. REST API Integration. SQL Query Optimization. Page Authentication.

Which Cards Region feature enables users to configure dynamic layouts based on database queries?. Data Templates. Page Computations. Quick SQL. SQL Workshop.

Which Faceted Search feature allows users to track active filter selections?. Filter History. Selected Facets Display. Search Assistant. Session State Logs.

Which Interactive Report feature allows users to email customized reports at regular intervals?. Email Subscription. Query Scheduler. Report Templates. RESTful Export.

Which Smart Filter feature enables users to refine data without modifying the SQL query?. Data Preprocessing. Dynamic Query Execution. Facet Selection. User-Defined Computations.

Which Interactive Grid feature enables real-time calculations without reloading the page?. Dynamic Computation. Client-Side Computation. Aggregation Functions. AJAX Callbacks.

Which two Cards Region features enhance visual presentation? (Choose two). Badge Styling. Column Filtering. Hover Animations. Row Locking.

Which report type automatically provides sorting, pagination, and filtering options without additional coding?. Classic Report. Interactive Report. Smart Filters. Cards Region.

Which Faceted Search feature allows users to reset all applied filters instantly?. Clear All Button. Query Refresh. Search Assistant. Auto-Facet Adjustment.

Which Interactive Grid setting prevents users from modifying certain rows?. Column Locking. Read-Only Condition. Data Restrictions. Dynamic SQL Query.

Which feature allows Cards Regions to display icons based on conditional logic?. Badge Icons. Dynamic Theme Adjustment. Smart Tags. Query-Based Styling.

Which Interactive Report feature allows exporting formatted reports to PDF?. REST API Export. Print to PDF. Query Output Formatter. Data Snapshot.

Which Smart Filter feature enables automatic filter suggestions based on user history?. Predictive Filters. Recent Searches. SQL Query Optimization. Query Assistant.

Which Faceted Search feature dynamically updates the available facets based on selected criteria?. Smart Filters. Query Auto-Adjust. Dependent Facets. Data Reduction.

Which two components must be configured to link a report page to a form page? (Choose two). Button or link column in the report. Page zero with session variables. Branch from the report to the form. Authentication scheme.

In an editable interactive grid, what must be enabled to allow users to add new rows?. Row-Level Authorization. Edit Mode. Insert Allowed setting. Row Filters.

Which form feature can be used to auto-fill fields based on values from a master record?. Pre-Rendering Computation. Master-Detail Link. Cascading LOV. Dynamic Action.

Which two operations must be defined for an Interactive Grid to be editable? (Choose two). Update Process. Editable Region Template. Table DML Settings. Row Fetch Function.

Which feature ensures a form page automatically loads record values for editing when accessed via a report link?. Page Branch. Automatic Row Fetch process. Row-Level Authorization. Session State Reset.

What is the purpose of a primary key column in a form-based application?. It controls layout of the form page. It determines which schema is used. It uniquely identifies the record being edited. It links to shared components.

Which process is executed after submitting a form page to store updated values in the database?. Validation. Rendering. Automatic Row Processing (DML). Source Value Computation.

Which two features are included in a master-detail form? (Choose two). Master region with data entry fields. Static content region for documentation. Interactive grid or form for detail records. Dynamic action to clear session state.

How is a detail region typically populated in a master-detail form?. Using shared components only. With a filtered SQL query using master record key. Via RESTful services. From a fixed dataset.

Which APEX component allows you to create a read/write form without writing PL/SQL?. Classic Report. Websheet Application. Form Region. REST Data Source.

Which two user actions typically trigger data submission from a form? (Choose two). Page close event. Button press with “Submit” action. Navigation using breadcrumbs. Pressing Enter on a text field.

In a detail region of a master-detail page, what enables in-place row editing?. Card Template. Classic Report Mode. Editable Interactive Grid. Static Content.

Which component can be used to populate a form field dynamically based on user input?. Breadcrumb. Dynamic Action. Authentication Scheme. Session State Protection.

Which type of validation is applied before form submission to ensure required fields are not empty?. Session-level validation. Pre-rendering process. Item-level validation. Post-submit branching.

In APEX, how do you restrict a form so only the record’s creator can edit it?. Add a row-level authorization scheme. Use server-side conditions on region. Disable editing with CSS. Use a dynamic LOV.

Which two page processes are auto-generated when creating a simple form? (Choose two). Row Fetch. Trigger Generator. Row Processing (DML). Theme Synchronization.

Which feature allows saving a newly created form record and immediately creating another?. Auto-redirect to Home. Reset Page State. Create and Add Another button. Branch to External URL.

Which component is typically used to pass values between a report and a form page?. Hidden Item with Set Value. JavaScript Binding. Region Template. Inline Dynamic Action.

How can you prevent users from submitting invalid or duplicate form data?. By disabling the Submit button. Using server-side validations and item constraints. Preventing page caching. Auto-refreshing the page after each insert.

Which two region types are supported as detail regions in a master-detail form? (Choose two). Static Content. Interactive Grid. Classic Report. List View.

Which two item types can be used to pass values between pages in Oracle APEX? (Choose two). Hidden Item. List Item. Display Only. Page Item.

What is the purpose of a page-level button in Oracle APEX?. To control page layout. To define user access. To trigger a process or navigation. To update item labels.

Which region is most appropriate to place a page-level item for accessibility throughout a page?. Page Footer. Breadcrumb Region. Page Template. Page Rendering: Items section.

Which two actions can be triggered from a button using Dynamic Actions? (Choose two). Refresh a region. Change authentication mode. Set item value. Compile a PL/SQL package.

What property of a page item determines when its value is submitted?. Source Type. Session State. Value Protected. Value Required.

Which item type is best used to display non-editable data from the database?. Hidden. Display Only. Text Field. Text Area.

What condition must be met for a page item value to be submitted with the page?. The item must be in a Form region. The item must be visible. The item must have the "Maintain Session State" property enabled. The item must be marked as "Read Only".

Which two types of page buttons are most commonly used in form pages? (Choose two). Navigation Button. Submit Button. Reset Button. Authentication Button.

What is the purpose of the “Action” property in a button definition?. To define the button’s layout and color. To assign a unique ID to the button. To determine what happens when the button is clicked. To refresh the page state.

Which type of item is best suited for storing internal application logic values such as user IDs or flags?. Text Field. Hidden Item. Date Picker. Password Item.

Which two feature pages can you create using the Create Page Wizard?. Access Control. Seach Page. Feedback. Unified Task List.

Which two tasks are performed by using SQL Workshop?. Install and manage Sample Apps. Edit an application page. Track and manage issues in a conversational fashion. Create and join queries by using drag-and-drop. Load and unload text, DDL, and spreadsheet data.

Which type of code can be generated by using Quiry Builder mode in the APEX Assistant. JavaScript. SQL. CSS.

You must reference certain data from a dragged event under the Drag and Drop PL/SQL Code attribute of the Calendar component. Examine the list: 1. ID 2. NEW_START_DATE 3. NEW_END_DATE How can these be referenced?. :APEX.PK_VALUE, :APEX.NEW_START_DATE, and :APEX.NEW_END_DATE. #APEX$PK_VALUE#, #APEX$NEW_START_DATE#, and #APEX$NEW_END_DATE#. #APEX.PK_VALUE#, #APEX.NEW_START_DATE#, and #APEX.NEW_END_DATE#. :APEX$PK_VALUE, :APEX$NEW_START_DATE, and $APEX$NEW_END_DATE.

Which two functions can be used by an end user when pivoting an interactive report?. List aggregate. Median. Rank. Minimun.

There is a page with an interactive grid region based on this statement: SELECT EMPNO, ENAME, COMM FROM EMP; In the Interactive Grid attributes, in the Edit group, the Enabled switch is turned off. Which two action mustt be performed to make an employee's commission editable in the grid?. In the Interactive Grid attributes, in the Edit group, turn on the Enabled switch. Ensure that the Primary Key switch is turned on for EMPNO column. Set EMPNO, ENAME to Display Only. In the Interactive Grid attributes, select COMM for Allowed Row Operations Column.

Which statement is true about creating and using a report with a form?. In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Source). The Create Page Wizard doesn't support the creation of a classic report and form combination. The Create Application Wizard doesn't supportt the creation of an interactive report and form combination. Both the Create Application Wizard and Create Page support the creation of an interactive report or classic report and form combination.

Which Action is used to open AI chat assistant by using a Dynamic Action?. Show AI Assistant. Open Generative AI. Generate Text with AI.

You must use a Static Content region type to display message about the employees of the month. Employee names are stored in the P1_ENAME page item. Which text, when placed in source, will display the message correctly?. Join me in congratulating: P1_ENAME as the new employee of the month. Join me in congratulating V('P1_ENAME') as the new employee of the month. Join me in congratulating &P1_ENAME. As the new employee of the month.

Now you must extend the functionality of this form so that: --> If you select 'SALESMAN' from the select list for the Job page item, both the 'Hire date' (P2_HIREDATE) and 'Commission' (P2_COMM) page items and their associated labels displayed --> If you select any other value from the select list for the Job page item (P2_JOB), both the 'Hire date' (P2_HIREDATE) and 'Commission' (P2_COMM) page items and their associated labels are hidden. Which two steps must be performed?. Create a dynamic action on P2_JOB, P2_HIREDATE, and P2_COMM. Create a dynamic action on P2_JOB. Create a dynamic action on P2_HIREDATE and P2_COMM. Create a dynamic action on form load. Specify a client-side condition of type item = value and enter SALESMAN for value.

Which authentication schema type supports authentication with social network and enterprise identify providers that support OpenID Connect or OAuth2 standards?. SAML Sign-In. Open Door Credentials. HTTP Header Variable. Social Sign-In.

An application includes a report and form on the PRODUCTS table. The form page includes page items P21_PRODUCT_NAME and P21_UNIT_PRICE. P21_UNIT_PRICE is currently displayed below P21_PRODUCT_NAME You need to reposition the items and display P21_UNIT_PRICE next to P21_PRODUCT_NAME. Which two actions can be performed in page designer to achieve this?. Use the Middle Pane, click P21_UNIT_PRICE, and drag the item directly next to P21_PRODUCT_NAME. Select P21_PRODUCT_NAME and then, in the Property Editor, under Layout, set Start New Row to Yes. Select P21_PRODUCT_NAME and then, in the Property Editor, under Layout, set Start New Row to No. Right-click P21_UNIT_PRICE and select Start New Row.

Examine this code entered in Quick SQL: Emp_salary Name vc255 Salary num Commission_yn / check TRUE, FALSE Which statement is true about the commission_yn column?. It will restrict acceptable values to TRUE or FALSE. It will default to FALSE. It will default to TRUE. It will restrict acceptable values to Y or N.

Which two statements are true about REST Data Source Synchronization?. If the local table is not in sync with the Data Profile, Data Synchronization doesn't work. To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing scheme. You cannot trigger Data Synchronization on a regular schedule using a scheduler job. If the local table is not in sync with the Data Profile, Data Synchronization continues to work for columns present in both the table and the Data Profile. The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties.

In your APEX application, you want to have an orderly grid layout of information tiles. Which page type should you choose in the Create Page Wizard?. Master Detail. Interactive Grid. Cards. Unified Task List.

Which statement is true about creating and using an interactive grid?. For both editable and noneditable interactive grids, end users can change the report layout and create private reports. End users cannot rearrage columns by dragging and dropping. An interactive grid supports Pivot View and Group By View features.

Which is a valid Page Process type?. Execute JavaScript Code. Send E-mail. Set Value.

You created a shopping cart application and added the "Add to Cart" functionality. You are using an APEX Collection named CART to temporarily store the items in the cart. Assume: P2_PRODUCT_ID holds the product id of the item being added to the card. Which PL/SQL Code snippet can be used to add items (PRODUCT_ID) into this APEX collection when the user adds items to the cart?. BEGIN INSERT INTO APEX_COLLECTION (id,name,c001) values (1, 'CART', ':P2_PRODUCT_ID'); END;. BEGIN INSERT INTO CART (id,c001) values (1, ':P2_PRODUCT_ID'); END;. BEGIN APEX.COLLECTION.ADD_MEMBER (P_collection_name => 'CART', P_c001 =>: P2_PRODUCT_ID); END;.

What is the Unified Task List in the Approvals components?. A page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox. A shared component used to configure task parameters, participants, actions, and due dates. A page that shows details for a specific task, which can include metadata, history comments, and actions.

Which two statement are true about loading data from the "Create App From a File" wizard?. Seed datat from a SQL script can be uploaded. CSV, XLSX, XML, TXT, or JSON files can be uploaded. XML and JSON data can be pasted and loaded. A sample data set from the sample list can be uploaded. Data from remote web services can be uploaded.

Which two statements are true about creating and customizing Smart Filters pages?. The suggestion chip count is displayed only for filters that support counts, such as LOV-based filter types. The search results report can be displayed as an interactive report. The search results report can be displayed as an interactive grid. If you create a Smart Filters page based on a table, the filters are auto-discovered by using the Data Dictionary Cache.

Which two quick actions are available in General Assistance mode of the APEX Assistant. Purge Selection. Improve Selection. Debug Selection. Explain Selection.

You require a page computation to execute before the page is rendered. Which two computation points will do this?. After Header. After Submit. After Page Processing. Before Header.

Where do you create a workflow in an APEX application?. Dynamic Action. Shared Components. Workspace Utilities.

Which two statements are true when an end user is customizing an Interactive Report?. A flashback query can be executed. Mathematical computations can be added to a column. Standard Oracle functions cannot be added to a column. Multiple charts can be created from the Action menu.

You add Access Control feature pages to your application. Which two actions can an administrator perform by using the Administration page?. Create Authorization Schemes. Add Users. Create Application Roles. Assign Roles to Users.

Which two tasks are performed by using App Builder in Oracle APEX?. Generate a Data Definition Language (DDL) statement from the Oracle dictionary. Create a join query by using drag and drop. Import previously created apps. Create/manage data objects. Create/manage apps.

Which statement is true when using SQL commands in Oracle APEX?. You can upload data from the database. In SQL Commands, you can view queries saved in Query Builder. You can search and filter database object. You can design and prototype data models by using a mardown-like shorthand syntax.