Font size
S
M
L
XL
WorksheetsMy Test
Total questions: 79
Worksheet time: 1hrs 19mins
Name
Class
Date
1.
There is a page with an interactive grid region based on this statement:
SQL
SELECT
EMPNO,
ENAME,
COMM
from EMP;
In the Interactive Grid attributes, in the Edit group, the Enabled switch is turned off.
Which two actions must be performed to make an employee's commission editable in the grid?
a)
In the Interactive Grid attributes, in the Edit group, turn on the Enabled switch.
b)
Ensure that the Primary Key switch is turned on for the EMPNO column.
c)
Set EMPNO, ENAME to Display Only.
d)
In the Interactive Grid attributes, select COMM for Allowed Row Operations Column.
2.
Which statement is true about Theme Styles in Oracle APEX?
a)
They determine the layout and structure of a webpage.
b)
When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.
c)
You can enable the Is Current attribute only when the Theme Style has the Read Only attribute disabled.
3.
Which two are valid evaluation points for Authorization Schemes?
a)
Never
b)
Once per user
c)
Once per page view
d)
Once per session
4.
Which two statements are true about the APEX_MAIL API?
a)
You can receive emails using the APEX_MAIL package in an Oracle APEX application.
b)
You can add files as attachments to your emails using the APEX_MAIL package.
c)
The APEX_MAIL package supports sending emails only to Oracle database users.
d)
You can send emails using the APEX_MAIL package from an Oracle APEX application.
5.
Which statement is true about using SQL Commands?
a)
You can design and prototype data models by using a markdown-like shorthand syntax.
b)
You can unload data from the database.
c)
You can search and filter database objects.
d)
In SQL Commands, you can view queries saved in Query Builder.
6.
Which two Query Source types can be used to create a dynamic Navigation Bar List?
a)
Procedure
b)
Function Returning SQL Query
c)
Select List
d)
SQL Query
7.
Which Action is used to open an AI chat assistant by using a Dynamic Action?
a)
Generate Text with AI
b)
Open Generative AI
c)
Show AI Assistant
8.
Which search type in Search Configurations provides linguistic and fuzzy search capabilities?
a)
Standard
b)
Oracle Text
c)
List
9.
What is the Unified Task List in the Approvals component?
a)
A page that shows details for a specific task, which can include metadata, history, comments, and actions.
b)
A page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox.
c)
A shared component used to configure task parameters, participants, actions, and due dates.
10.
Which statement is true about importing an APEX application?
a)
You cannot import an APEX application exported from the latest APEX version to an old APEX version.
b)
The import process does not import the supporting objects defined during the export.
c)
You cannot change the application ID during the import process.
11.
Which statement is true about creating and using pages in an APEX application?
a)
A user cannot interact with a nonmodal dialog and content on the page.
b)
You can copy a page only from the current application.
c)
Modal and nonmodal dialog pages are supported only if the current application theme contains at least one page template 1 of type Dialog
12.
You must use a Static Content region type to display messages about the employees of the month. Employee names are stored in the P1_ENAME page item.
Which text, when placed in Source, will display the message correctly?
a)
Join me in congratulating :P1_ENAME as the new employee of the month!
b)
Join me in congratulating V('P1_ENAME') as the new employee of the month!
c)
Join me in congratulating &P1_ENAME. as the new employee of the month!
13.
Which API can be used to send push notification immediately from the notification queue?
a)
APEX_PWA.PURGE_QUEUE
b)
APEX_PWA.PUSH_QUEUE
c)
APEX_PWA.HAS_PUSH_SUBSCRIPTION
14.
What happens when you regenerate credentials for Push Notifications?
a)
Existing Push Subscriptions for the application will be invalidated.
b)
Queued Push Notifications for the application will be sent.
c)
Existing Push Subscriptions for the application will be valid.
15.
At what level does a Developer enable push notifications so that end users can receive them on their devices from an APEX application?
a)
Application
b)
Page
c)
Instance
d)
Region
16.
Which authentication scheme type supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth 2 standards?
a)
Social Sign-In
b)
SAML Sign-In
c)
HTTP Header Variable
d)
Open Door Credentials
17.
Which two statements are true about REST Data Source Synchronization?
a)
If the local table is not in sync with the Data Profile, Data Synchronization doesn't work.
b)
To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.
c)
You cannot trigger Data Synchronization on a regular schedule using a scheduler job.
d)
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.
e)
The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties.
18.
Where do you create a Workflow in an APEX application?
a)
Shared Components
b)
Dynamic Actions
c)
Workspace Utilities
19.
Which is NOT an available Geometry Column data type for the maps region?
a)
GeoJSON
b)
Latitude/Longitude
c)
SDO_GEOMETRY
d)
JSON_OBJECT
20.
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?
a)
Interactive Grid
b)
Classic Report
c)
Column Toggle Report
d)
Interactive Report
21.
Which two statements are true about Faceted Search pages?
a)
Faceted Search supports the ability to filter columns storing multiple values as one string.
b)
Facets map to specific database columns.
c)
A facet's chart can be seen only in a nonmodal dialog.
d)
Multiple charts are not visible in the same region.
22.
Which statement is true about creating and using a faceted search page?
a)
The Search Results region can be displayed as a Classic Report or Cards.
b)
If you create a faceted search page based on a table, the facets are not auto-discovered.
c)
The Search Results region can be displayed as an interactive report.
d)
If you create a faceted search page on a view or a SQL query, the facets are auto-discovered.
23.
Which two statements are true about loading data from the "Create App From a File" wizard?
a)
CSV, XLSX, XML, TXT, or JSON files can be uploaded.
b)
A sample data set from the sample list can be uploaded.
c)
Seed data from a SQL script can be uploaded.
d)
Data from remote web services can be uploaded.
e)
XML and JSON data can be pasted and loaded.
24.
To understand how your existing Employee Benefits application is being used and to identify areas for improvement, you want to determine the most often used pages, and the performance of pages.
How is this achieved from the Application Home page?
a)
From the Tasks list, click the Add Feature Page button. Then select the Feedback feature type.
b)
Click Create Page. In the Create Page Wizard, select the Master Detail page type.
c)
Click Create Page. In the Create Page Wizard, select the Email Reporting feature type.
d)
Click Create Page. In the Create Page Wizard, select the Activity Reporting feature type.
25.
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 1 should you use?
a)
Stacked
b)
Side by Side
c)
Drill Down
26.
Which statement is true about creating and using a report with a form?
a)
Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination.
b)
The Create Application Wizard doesn't support the creation of an interactive report and form combination.
c)
The Create Page Wizard doesn't support the creation of a classic report and form combination.
d)
In the Create Application Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST Data Sources)
27.
Which statement is true about the Data Workshop utility?
a)
The wizards load and unload table data only.
b)
You can load or unload multiple tables at a time.
c)
The wizards load and unload all types of schema objects.
d)
You cannot load data from an XLSX file with multiple worksheets.
28.
Which two statements are true about an end user customizing an interactive report?
a)
Multiple charts can be created from the Actions menu.
b)
Standard Oracle functions cannot be added to columns.
c)
A flashback query can be executed.
d)
Mathematical computations can be added to columns.
29.
Which Process type do you use to run multiple processes in the background from your Oracle APEX application?
a)
Execute Code
b)
Execute Server-side Code
c)
Execute JavaScript Code
d)
Execution Chain
30.
You require a Page Computation to execute before the page is rendered.
Which two computation points (Execution Point) will do this?
a)
After Header
b)
After Submit
c)
After Page Processing
d)
Before Header
31.
Which two statements are true about creating and managing an APEX Workspace?
a)
A workspace enables multiple users to work within the same Oracle APEX installation.
b)
During workspace creation, you can associate the workspace with an existing database schema.
c)
New schemas cannot be created during workspace creation.
d)
You can create only two workspaces in an APEX Service (APEX Application Development) instance.
e)
A workspace can be associated with only one schema.
32.
Which two Quick Actions are available in General Assistance mode of the APEX Assistant?
a)
Debug selection
b)
Explain selection
c)
Purge selection
d)
Improve selection
33.
From which two options can you invoke APEX Assistant after the Generative AI service is created?
a)
Workspace Utilities
b)
Code Editor
c)
SQL Commands
d)
Administration Services
34.
What are two reasons to enable the Used by App Builder option while creating a Generative AI Service?
a)
To build applications using natural language powered by Generative AI
b)
To create a REST-enabled database object
c)
To author SQL powered by Generative AI
d)
To create a Working Copy of your application
35.
Which two actions are performed by using the Object Browser?
a)
Create a lookup table based on a column in the current table.
b)
Create and run SQL scripts.
c)
Browse database objects of the current schema.
d)
Export and import SQL scripts.
e)
Restore dropped database objects.
36.
Which three Theme Components are available out-of-the-box with the Universal Theme in Oracle APEX?
a)
Badge
b)
Calendar
c)
Avatar
d)
Comments
e)
REST Data Sources
37.
Which two statements are true about a Progressive Web Application (PWA)?
a)
Enabling the PWA functionality in your APEX app adds a new navigation bar entry named Install App to your app.
b)
You can create a PWA only when creating a new application with the Create Application Wizard.
c)
To use the PWA feature, the Friendly URLs attribute in the Application Definition > Properties section must be turned off.
d)
PWA features will be rendered even if the application is served in an unsecured environment.
e)
Enabling the PWA functionality optimizes page loading speed on a mobile device.
38.
Which is a valid method of logging messages to the execution log in APEX automation?
a)
apex_automation.log_info('SAL for ' || :ENAME || ' increased by 1%.');
b)
apex_debug.info('SAL for ' || :ENAME || ' increased by 1%.');
c)
apex_error.add_error ( p_message => 'SAL for ' || :ENAME || ' increased by 1%.', p_display_location => apex_error.c_inline_in_notification );
39.
Which two actions does the Create Application Wizard allow?
a)
Changing the application authorization
b)
Uploading JavaScript or CSS files required for an application
c)
Reordering application pages
d)
Adding or deleting application page
40.
Which two statements are true about Oracle APEX?
a)
Running an APEX app needs client software.
b)
Processing and data manipulation are not executed in the database.
c)
APEX eliminates middle-tier application logic.
d)
You can build interactive reporting apps based on data from disparate systems.
e)
Application definition is not stored in the database.
41.
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:
ID
NEW_START_DATE
NEW_END_DATE
How can these be referenced?
a)
#APEX$PK_VALUE#, #APEX$NEW_START_DATE#, and #APEX$NEW_END_DATE#
b)
:APEX$PK_VALUE, :APEX$NEW_START_DATE, and :APEX$NEW_END_DATE
c)
&APEX._PK_VALUE., &APEX._NEW_START_DATE., and &APEX._NEW_END_DATE.
d)
:APEX_PK_VALUE, :APEX_NEW_START_DATE, and :APEX_NEW_END_DATE
42.
Which client credentials are used for authentication during the One-Click Remote Application Deployment process?
a)
APEX Workspace Admin credentials
b)
Database schema credentials
c)
APEX Developer credentials
43.
An application includes a report and form on the PRODUCTS table.
The form page includes page items P21_PRODUCT_NAME and P21_UNIT_PRICE. P21_UNIT_PRICE is currently displayed below P21_PRODUCT_NAME.
You need to reposition the items and display P21_UNIT_PRICE next to P21_PRODUCT_NAME.
Which two actions can be performed in Page Designer to achieve this?
a)
Use the Middle Pane, click P21_UNIT_PRICE, and drag the item directly next to P21_PRODUCT_NAME.
b)
Select P21_PRODUCT_NAME and then, in the Property Editor, under Layout, set Start New Row to Yes.
c)
Select P21_UNIT_PRICE and then, in the Property Editor, under Layout, set Start New Row to No.
d)
Right-click P21_UNIT_PRICE and select Start New Row.
44.
You have an interactive grid component and you are enabling the Save Public Report attribute.
As what can end users save the report type?
a)
As Primary only
b)
As Public only
c)
As Private only
d)
As Private and Public only
45.
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?
a)
Subscribing the copied theme to the master theme and refreshing the theme
b)
Verifying the theme subscription
c)
Copying the changes made in the master theme to the copied theme
d)
Refreshing the templates
46.
Which two Plugin types can be created in Oracle APEX?
a)
Region
b)
Process
c)
Email Template
d)
Validation
47.
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 mobile devices.
Which step must be performed in Oracle APEX to achieve this?
a)
Create a Dynamic Action of Send Push Notification type to send push notifications to all the subscribed users.
b)
Create a REST Data Source to send push notifications to all the subscribed users.
c)
Create a PL/SQL block to fetch all the subscribed users and send push notifications by using APEX_PWA.PUSH_SUBSCRIPTION and APEX_PWA.SEND_PUSH_NOTIFICATION.
48.
At what level does a Developer enable push notifications so that end users can receive them on their devices from an APEX application?
a)
Page
b)
Application
c)
Region
d)
Instance
49.
Which two statements are true about loading data from the "Create App From a File" wizard?
a)
Seed data from a SQL script can be uploaded.
b)
Data from remote web services can be uploaded.
c)
CSV, XLSX, XML, TXT, or JSON files can be uploaded.
d)
A sample data set from the sample list can be uploaded.
e)
XML and JSON data can be pasted and loaded.
50.
Which two declarative options in Oracle APEX allow you to download BLOB/CLOB content?
a)
Share dynamic action
b)
Download page process
c)
Download dynamic action
d)
APEX_UTIL.DOWNLOAD PL/SQL API
51.
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?
a)
Quick Actions
b)
Welcome Message
c)
System Prompt
52.
Which action must be performed while configuring a Generative AI service for the 'Create App using Generative AI' option to appear on the Create Application page?
a)
Disable the Used by App Builder setting.
b)
Select the database schema.
c)
Enable the Used by App Builder setting.
53.
Which two SQL format options does the APEX Assistant provide when using the "Create Data Model using AI" feature?
a)
Quick SQL
b)
Oracle SQL
c)
Oracle PL/SQL
d)
MySQL
54.
Which attribute is used to fetch additional data during Workflow execution?
a)
Dynamic Action
b)
Variables
c)
Parameters
d)
Additional Data
55.
Which two Query Source types can be used to create a dynamic Navigation Bar List?
a)
Select List
b)
SQL Query
c)
Function Returning SQL Query
d)
Procedure
56.
Which Process Type allows you to invoke a REST Source declaratively?
a)
Execute JavaScript Code
b)
Execute Server-side Code
c)
Invoke API
57.
What will cause the validation error to appear only in the Notification area?
a)
Removing P1_SALARY from the validation Associated Item
b)
Setting Value Required to Yes on P1_SALARY
c)
Setting Display Location to Inline in Notification
58.
What do you achieve by performing the Refresh Working Copy task?
a)
Update the changes from one Working Copy to another.
b)
Merge the Working Copy changes with the Main application.
c)
Get the latest updates from the Main application.
59.
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?
a)
Date Picker
b)
Checkbox Group
c)
Popup LOV
d)
Range
60.
An application includes a form on the EMPLOYEES table.
You must limit the P5_MANAGER page item so users can select a single employee name EMP_NAME and save the corresponding employee ID EMP_ID to the database.
Examine this statement used for the List of Values definition:
SQL
SELECT emp_name d,
emp_id r
FROM employees
ORDER BY 1
Which item type can be used to display P5_MANAGER?
a)
Switch
b)
Check box
c)
Popup LOV
61.
Which two approaches can be used to create custom stored procedures in SQL Workshop?
a)
Using Object Browser
b)
Using SQL scripts
c)
Using Data Workshop
d)
Using Quick SQL
62.
You add Access Control feature pages to your application.
Which two actions can an Administrator perform by using the Administration page?
a)
Create Authorization schemes.
b)
Assign roles to users.
c)
Create new application roles.
d)
Add Users.
63.
Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?
a)
Install Oracle APEX in the remote Oracle Database.
b)
Create a database link to the remote Oracle Database in the local APEX schema.
c)
REST-enable the schema in the remote Oracle Database by using ORDS.ENABLE_SCHEMA.
d)
Install ORDS 19.x or later on the remote Oracle Database.
64.
In your application, you want to display data in a searchable, customizable report that supports inline editing at run time using the mouse or keyboard.
Which report type will you create?
a)
Smart Filters
b)
Interactive Report
c)
Interactive Grid
d)
Classic Report
65.
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 changes?
a)
Navigate to each facet and then in the Property Editor, turn on Client-Side Filtering.
b)
Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute.
c)
Navigate to the faceted search region Attributes, and turn off the Show Facet Name attribute. Then, navigate to each facet and in the Property Editor, turn on Client-Side Filtering.
d)
Navigate to the faceted search region Attributes, and turn off the Show Facet Name attribute.
66.
Which two tasks are performed by using App Builder?
a)
Import previously exported apps.
b)
Generate data definition language (DDL) statements from the Oracle Data Dictionary.
c)
Create join queries by using drag-and-drop.
d)
Create and manage database objects.
e)
Create and manage apps.
67.
Which is a valid Page Process type?
a)
Send E-Mail
b)
Set Value
c)
Execute JavaScript Code
68.
You created a shopping cart application and added the "Add to Cart" functionality. You are using an APEX Collection named CART 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 the APEX collection when the user adds items to the cart?
a)
BEGIN
INSERT INTO APEX_COLLECTIONS (id, name, c001) VALUES (1, 'CART', :P2_PRODUCT_ID);
END;
b)
BEGIN
INSERT INTO CART (id, c001) VALUES (1, :P2_PRODUCT_ID);
END;
c)
BEGIN
APEX_COLLECTION.ADD_MEMBER(
p_collection_name => 'CART',
p_c001 => :P2_PRODUCT_ID);
END;
69.
Which two feature pages can you create using the Create Page Wizard?
a)
Access Control
b)
Search Page
c)
Feedback
d)
Unified Task List
70.
Which statement is true about creating and using an interactive grid?
a)
An interactive grid supports Pivot View and Group By View features.
b)
For both editable and noneditable interactive grids, end users can change the report layout and create private reports.
c)
End users cannot rearrange columns by dragging and dropping.
71.
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?
a)
Unified Task List
b)
Cards
c)
Interactive Grid
d)
Master Detail
72.
Which two statements are true about creating and using dynamic actions?
a)
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.
b)
After you create a dynamic action, you cannot add more true actions.
c)
If no client-side condition is defined, true actions will not fire.
d)
You can execute JavaScript code by creating a dynamic action.
73.
What are the two modes available in the APEX Assistant?
a)
AI Assistant
b)
Query Builder
c)
App
d)
General Assistance
74.
Which two tasks can be performed by using the Generate Text with AI Dynamic Action?
a)
Summarize or translate text
b)
Update the underlying database tables
c)
Draft an email
d)
Invoke a Workflow
75.
Which two actions enable "hide and show" behavior of a data series in a bar chart when its corresponding legend item is clicked?
a)
Setting the On Data Change attribute value to Slide to Left
b)
Setting the Hide and Show Behavior attribute value to None
c)
Setting the Hide and Show Behavior attribute value to Rescale
d)
Setting the Hide and Show Behavior attribute value to No Rescaling
76.
Which client credentials are used for authentication during the 'Check Syntax' process?
a)
Database schema credentials
b)
APEX Workspace Admin credentials
c)
APEX Developer credentials
77.
Which component of the Push Notifications feature stores the messages that are ready to be sent?
a)
Queue
b)
Application
c)
Subscription
78.
Which two AI Service Providers are supported by Oracle APEX?
a)
DOC Document Generator pre-built function
b)
OpenAI
c)
Jarvis
d)
OCI Generative AI
79.
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?
a)
POST
b)
GET
c)
PUT
Reset
