Oracle APEX Prof

You created a shopping cart application and added the "Add to Cart" functionality. You are using an APEX Collection named CARR to temporarily store the items in the cart. Assume: P2_PRODUCT_ID holds the product id of the item being added to the cart. 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;.

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 Public only. As Private and Public only. As Private only. As Primary only.

Which two statements are true about creating and managing an APEX Workspace?. New schemas cannot be created during workspace creation. During workspace creation, you can associate the workspace with an existing database 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. A workspace can be associated with only one schema.

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?. LOV popup. Date picker. Checkbox group. Range.

Which two statements are true about creating and customizing Smart Filters pages?. If you create a Smart Filters page based on a table, the filters are auto-discovered by using the Data Dictionary Cache. The search results report can be displayed as an interactive grid. 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 an interactive report.

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

You must reference certain data from a dragged event under the Drag and Drop PL/SQL Code attribute of the Calendar component. Examine this list: 1. ID 2. NEW START_DATE 3. NEW END DATE. :APEXSPK_VALUE,APEXSNEW_START_DATE and :APEXNEW_END_DATE. #APEXSPK_VALUE,#APEXSNEW_START_DATE and #APEXNEW_END_DATE#. #APEXSPK_VALUE#,#APEXSNEW_START_DATE# and #APEXNEW_END_DATE#. O:APEXSPK_VALUE,APEXSNEW_START_DATE and :APEXNEW_END_DATE.

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

What is the Unified Task List in the Approvals component?. 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.

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

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

An Employees app includes a form to enter and update employee details Now you must extend the functionality of the 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 are 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 hiden. 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 two statements are true about loading data from the "Create App From a File" wizard?. Seed data from an SQL script can be uploaded. CSV, XLSX, XML, TXT, or JSON files can be uploaded. XML and JSON data can be pasted and loaded. Data from remote web services can be uploaded. A sample data set from the sample list can be uploaded.

To understand how your existing Employee Benefits application is being used and to identify areas for improvement, you want to determine the most active users, the most used pages, and the performance of pages. How is this achieved from the Application Home page?. From the Tasks list, click the Add Feature Page button. Then select the Feedback feature type. Click Create Page. In the Create Page Wizard, select the Activity Reporting feature type. Click Create Page. In the Create Page Wizard, select the Email Reporting feature type. Click Create Page. In the Create Page Wizard, select the Master Detail page type.