Referente

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.

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 Server?. 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? I. DOC Document Generator pre-built function. 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?. 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 facets chart can be seen only in a nonmodal dialog. Facets map to specific database columns.

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?. 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. heckbox.

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.

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 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?. Join me in congratulating: P1_ENAME as the new employee of the month!. 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!.

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?. 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.

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.