APXX

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