apex26

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 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 three data types are supported by Oracle APEX Workflow parameters and variables?. CLOB. VARCHAR. NUMBER. Vector. Image.

You add Access Control feature pages to your application. Which two actions can an Administrator perform by using the Administration page?. Create Authorization schemes. Create new application roles. Add Users. Assign roles to users.

Which two Quick Actions are available in General Assistance mode of the APEX Assistant?. Improve selection. Explain selection. Purge selection. Debug selection.

Which two AI Service Providers are supported by Oracle APEX?. OpenAI. OCI Generative AI. Jarvis. OCI document Generator pre-built function.

What will cause the validation error to appear only in the Notification area?. Removing P1_SALARY from the validation Associated Item. Setting Display Location to inline in Notification. Setting Value Required to Yes on P1_SALARY.

Which two actions enable "hide and show" behavior of a data series in a bar chart when its corresponding legend is clicked?. Setting the Hide and Show Behavior attribute value to No Rescaling. Setting the Hide and Show Behavior attribute value to Rescale. Setting the Hide and Show Behavior attribute value to None. Setting the On Data Change attribute value to slide to left.

Which two outcomes do you achieve by performing the 'Compare Changes' task in a working copy?. Compare Working Copy changes with the Main application. Compare changes across Working Copies created from a Main application. Compare changes between different regions in the same application. Compare changes between different pages in the same application.

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

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

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