Oracle Apex

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. An interactive grid supports Pivot View and Group By View features. End users cannot rearrange columns by dragging and dropping.

What happens when you regenerate credentials for Push Notifications?. Existing Push Subscriptions for the application will be valid. Queued Push Notifications for the application will be sent. Existing Push Subscriptions for the application will be invalidated.

Which APEX API can be used to send push notifications immediately from the notification queue?. APEX_PWA.PUSH_QUEUE. APEX_PWA.HAS_PUSH_SUBSCRIPTION. APEX_PWA.PURGE_QUEUE.

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 tasks can be performed by using the Generate Text with AI Dynamic Action?. Invoke a Workflow. Draft an email. Summarize or translate text. Update the underlying database tables.

Which is a valid method of logging messages to the execution log in APEX automation?. apex_debug.info('SAL for ' || :ENAME || ' increased by 1.');. apex_error.add_error(p_message => 'SAL for ' || :ENAME || ' increased by 1.', p_display_location => apex_error.c_inline_in_notification);. apex_automation.log_info('SAL for ' || :ENAME || ' increased by 1.');.

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

You must create a single master detail page where users can select a row in the master grid to update the detail grids. Users must also interact with the master or the detail without leaving the page. Which type of master-detail implementation should you use?. Stacked. Drill Down. Side by Side.

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

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

Which search type in Search Configurations provides linguistic and fuzzy search capabilities?. Standard. Oracle Text. List.

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?. Interactive Grid. Interactive Report. Classic Report. Smart Filters.

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

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

Which two actions enable "hide and show" behavior of a data series in a bar chart when its corresponding legend item is clicked?. 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. Setting the Hide and Show Behavior attribute value to No Rescaling.

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

There is a page with an interactive grid region based on this statement: SELECT EMPNO, ENAME, COMM, DEPTNO FROM EMP In the Interactive Grid attributes, in the Edit group, the Enabled switch is turned off. Which transactions must 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 the EMPNO column. Set ENAME, ENAME to Display Only. In the Interactive Grid attributes, select CODE for Allowed Row Operations Column.

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

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

You have defined a REST Data Source with ORDS as the REST Data Source Type. This REST Data Source is based on an AutoREST-enabled EMP table on a remote Oracle Database. This REST Data Source is being used as a source for an editable interactive grid. When a user updates an employee record in this interactive grid, which operation (HTTP Method) defined in the REST Data Source is utilized to update a record in the EMP table on the remote Oracle Database?. GET. PUT. POST.

You are developing a shopping cart application in Oracle APEX and using an APEX Collection named CART to temporarily store the items in the cart. Assume that the product ID of the item being added to the cart is stored in the :P2_PRODUCT_ID variable. Which of the following PL/SQL code snippets can be used to add the product ID to the CART collection when a user adds an item to their cart?. BEGIN INSERT INTO CART (id, c001) values (1, :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;.

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

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

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

Which two statements are true about loading data from the "Create App From A File" wizard?. Data from remote web services can be uploaded. A sample data set from the sample list can be uploaded. Seed data 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.

Examine this code used in Quick SQL: students: name varchar2(255) null roll_no num Quick SQL is using default settings. Which table creation script or other output is produced?. create table students ( id number generated by default on null as identity constraint students_id_pk primary key, name varchar2(255 char), roll_no number );. create table students ( id number generated by default on null as identity constraint students_id_pk primary key, name varchar2(255 char) not null, roll_no number );. An Invalid column definition error message will be displayed.

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 table data only. The wizards load and unload all types of schema objects. You can load or unload multiple tables at a time.

You must use a Static Content region type to display messages about the employees of the month. Employee names are stored in the :P1_EMPNAME page item. Which text, when placed in SOURCE, will display the message correctly?. Join me in congratulating :P1_EMPNAME 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!.

Which is NOT an available Geometry Column data type for the maps region?. GeoJSON. Latitude/Longitude. SDO_GEOMETRY. JSON_OBJECT.

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

From which two options can you invoke APEX Assistant after the Generative AI service is created?. SQL Commands. Administration Services. Workspace Utilities. Code Editor.

What are the two modes available in the APEX Assistant?. General Assistance. AI Assistant. Query Builder. App.

Which statement is true about importing an APEX application?. 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 two outcomes do you achieve by performing the "Compare Changes" task in a working copy?. Compare changes between different regions in the same application. Compare changes between different pages in the same application. Compare Working Copy changes with the Main application. Compare changes across Working Copies created from a Main application.

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?. Refreshing the templates. Copying the changes made in the master theme to the copied theme. Subscribing the copied theme to the master theme and refreshing the theme. Verifying the theme subscription.

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

Which two statements are true about creating and using an interactive report?. You cannot include Form Page when creating an interactive report page using the Create Page Wizard. You cannot customize the Search Button Label. You cannot restrict users from saving private reports by using the Authorization Scheme. You can specify an Authorization Scheme at the column level.

Which statement is true about creating and using a faceted search page?. If you create a faceted search page based on a table, the facets are not auto-discovered. The Search Results region can be displayed as an interactive report. If you create a faceted search page on a view or a SQL query, the facets are auto-discovered. The Search Results region can be displayed as a Classic Report or Cards.

Which two statements are true about Faceted Search pages?. Facets map to specific database columns. A facet's chart can be seen only in a non-modal dialog. Multiple charts are not visible in the same region. Faceted Search supports the ability to filter columns storing multiple values as one string.

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

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

Which two statements are true about a Progressive Web Application (PWA)?. Enabling the PWA functionality in your APEX app adds a new navigation bar entry named Install App to your app. You can create a PWA only when creating a new application with the Create Application Wizard. To use the PWA feature, the Friendly URLs attribute in the Application Definition > Properties section must be turned off. Enabling the PWA functionality optimizes page loading speed on a mobile device.

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. A workspace enables multiple users to work within the same Oracle APEX installation. 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 authentication scheme type supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards?. Open Door Credentials. SAML Sign-In. Social Sign-In. HTTP Header Variable.

Which two steps must be performed to make the form dynamic based on the selected job?. 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 SALES for Value.

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

Which two declarative options in Oracle APEX allow you to download BLOB/CLOB content?. Download page process. APEX_UTIL_DOWNLOAD.PLSQL API. Download dynamic action. Share dynamic action.

Which statement is true about Theme Styles in Oracle APEX?. They determine the layout and structure of a webpage. When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment. You can enable the Is Current attribute only when the Theme Style has the Read Only attribute disabled.

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

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

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

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

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. REST-enable the schema in the remote Oracle Database by using ORDS.ENABLE_SCHEMA. Install ORDS 19.x or later on the remote Oracle Database. Install Oracle APEX in the remote Oracle Database.

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

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 below the item: "Salary must be Numeric." What will cause the validation error to appear only in the Notification area?. Setting Value Required to Yes on P1_SALARY. Setting Display Location to Inline in Notification. Removing P1_SALARY from the validation Associated Item.

Which two statements are true about an end user customizing an interactive report?. Standard Oracle functions cannot be added to columns. A flashback query can be executed. Multiple charts can be created from the Actions menu. Mathematical computations can be added to columns.

Examine this code: emp_salary name vc255 salary num commission_yn /check TRUE, FALSE Which statement is true about the commission_yn column?. It will default to FALSE. It will restrict acceptable values to TRUE or FALSE. It will default to TRUE. It will restrict acceptable values to Y or N.

You must reference certain data from a dragged event under the Drag and Drop PL/SQLCode attribute of the Calendar component. Examine this list: 1. The ID 2. The NEW_START_DATE 3. The NEW END DATE How can these be referenced?. :APEX$PK_VALUE, APEX$NEW START DATE and APEXSNEW_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. #APEXSPK VALUE#, #APEX$NEW START DATE# and #APEXSNEW END DATE#.

Which attribute is used to fetch additional data during Workflow execution?. Parameters. Additional Data. Dynamic Action. Variables.

You have an interactive grid component and you are enabling the Save Public Report attribute. As what can end users save the report type?. As Primary only. As Public only. As Private only. As Private and public only.

Which two statements are true about creating and using dynamic actions?. After you create a dynamic action, you cannot add more true actions. You can execute JavaScript code by creating a dynamic action. If no client-side condition is defined, true actions will not fire. 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.

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

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

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?. Unified Task List. Cards. Interactive Grid. Master Detail.

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

Which feature of Oracle APEX helps the search engines understand the page's topic and is used by other sites to create previews?. Description. Meta Tags. Screenshots. Share.