1.

You must create a single master detail page where users can select a row in the master grid to update the detail grids.

User must also interact with th master or the detail without leaving the page.

Which type of master detail implementation should you use?

 Side by Side
 Stacked
 Drill Down

2. What will cause the validation error to appear only the notification area?
 Setting the value required to Yes on p1_salary
 Setting Display Location to inline in notification
 Removing p1_salary from the validation associated item

3. 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 object defined during the export
 You cannot import an APEX application exported from a latest APEX version to an old APEX version.

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

Which PL/SQL Code snippet can be used to add items (PRODUCTID) into this APEX collection when the user adds items to
the cart?

Assume : P2 PRODUCT ID holds the product id of the item being added 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;

5. You require a page computation to execute before the page is rendered

Which two computation points(execution point) will do this?

 After header
 After submit
 After Page processing
 Before header

6. Which statement is true about creating and using a faceted search page
 The search results region can be displayed as a Classic Report or Cards
 If you create a faceted search page on a view or a SQL query, the facets are auto-discovered
 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.
7. Which two statement are true about creating and using an interactive report.
 You can specify an authorization scheme at the column level
 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.

8. Which two statement are true about customizing an interactive report by an end user?
 Mathematical computations can be added to columns
 Standard Oracle functions cannot be added to columns
 From the Actions menu, multiple charts can be created
 A flashback query can be executed

9. Which two functions can be used an end user when pivoting an interactive report?
 Rank
 Its aggregate
 Median
 Minimum
 List aggregate

10. Which search type in search configurations provides linguistic and fuzzy search capabilities?
 List
 Oracle Text
 Standard

11. Which two are prerequisites to use he REST-enabled SQL feature in Oracle Apex?
 On the remote Oracle Database, install ORDS 19x or later
 REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA
 Install Oracle APEX in the remote Oracle Database
 Create a Database link to the remote Oracle Database in the local APEX Schema.

12. An application includes a form on the EMPLOYEES table.

You must limit he 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 Value definition:

Selectemp_name d,
Emp_id r
From employees
ORDER BY 1

Which item type can be used to display P5_MANAGER?

 Check box
 Switch
 PopupLov

13. Which is a valid Page Process Type?

 Send Email
 Execute JavaScript Code
 Set Value

14. Which two statements are true about creating and customizing Smart Filters Pages?
 The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types.
 If you create a Smart Filters page based on a table, the filters are auto discovered using the Data Dictionary Cache.
 The search results report can be displayed as an interactive grid.
 The search results report can be displayed as an interactive report.
15. 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. The ID
2. The NEW_START_DATE
3. The NEW_END_DATE

How can these be referenced?

16. 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 primary Only
 As Private Only
17. Which statement is true about creating and using an interactive grid?
 An interactive grid supports Pivot View and Group BY View features
 End Users cannot reattange columns by dragging and dropping.
 For both editable and noneditable interactive grids, end users can change the report layout and create private reports

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

19. Which authentication scheme type supports authentication with social networks and enterprise identity providers that support
OpenID connect or OAuth2 standards?
 Social Sig-in
 SAML Sign-in
 Http Header Variable
 Open Door credentials

20. Which client credentials are utilized for authentication during the One-Click Remote Application Deployment process?
 Database schema credentials
 Apex Workspace Admin credentials
 Apex Developer Credentials

21. In your existing Employee Benefits application, you want to determine the most active users, the most used pages, and the
performance of pages to better understand how your application is being utilized and areas for improvement.

How can this be achieved?

 On the Application Home page, from the Tasks list, click the Add Feature Page button. Then select the Feedback
feature type.
 On the Application Home page, click Create Page. In the Create Page Wizard, select the Email Reporting feature
type.
 On the Application Home page, click Create Page. In the Create Page Wizard, select the Master Detail page type.
 On the Application Home page, click Create Page. In the Create Page Wizard, select the Activity Reporting feature
type.
22. 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.
 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.
 You cannot trigger Data Synchronization on a regular schedule using a scheduler job.
 The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties
 To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the
application's parsing schema.

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

 Join me in congratulating:P1 ENAME te new employee of the month!

 Join me in congratulating ENAME'as the new employee of the month!
 Join me in congratulating&P1 ENAME. as the new employee of the month!

24. Which is NOT a valid Geometry Column Data Type available for maps region?

 JSON_OBJECT
 GeoJSON
 Latitude/Longitude
 SDO_GEOMETRY

25. Which two layout options are available for Page Designer under Utilities?

 Two Pane Mode

 Three Pane Mode
 Four Pane Mode
 Single Pane Mode

26. 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. 2. The master theme may still require changes.

Which solution guarantees that any changes to the master theme are reflected in the copied theme?

 Verifying the theme subscription

 Subscribing the copied theme to the master theme and refreshing the theme
 Refreshing the templates
 Copying the changes made in the master theme to the copied theme

27. An Employees App includes a form to enter and update employee details.

Examine this Exhibit.

Employee Number 7839
Name KING
Job SALESMAN
Manager
Hire date 17-NOV-1981
Salary 5000
Commission
* Department t ACCOUNTING

Now you must extend the functionality o this form so that:

If you select 'SALESMAN' from the select list for Job page item (P2_JOB), 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 Job page item (P2_JOB), both the 'Hire date' (P2 HIREDATE) and 'Commission'
(P2 COMM) page items and their associated labels are hidden

Which two steps must be performed?

 Create a dynamic action on P2 JOB.

 Create a dynamic action on P2_JOB, P2 HIREDATE, and P2_COMM.
 Create a dynamic action on form load
 Create a dynamic action on P2 HIREDATE and P2_COMM.
 Specify a client-side condition of type Item = Value and enter SALESMAN for Value.

28. Which two statements are true about creating and using dynamic actions?

 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.
 Once you create a dynamic action, you cannot add additional true actions.
 You can execute JavaScript code by creating a dynamic action.
29. 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.
 APEX eliminates middle-tier application logic.
 Running an APEX app needs client software.
 You can build interactive reporting apps based on data from disparate systems.

30. Which statement is true about creating and using a report with form?

 Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and
form combination.
 In the Create Applilation Wizard, you can select a data source (that is, Local Database, REST Enabled SQL Service, or REST
Data Source).
 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.
31. Which statement is true about the Data Workshop utility?

 The wizards load and unload table data only.

 You can load or unload multiple tables at a time.
 The wizards load and unload all types of schema objects.
 You cannot load data from an XLSX file with multiple worksheets.

32. Which two statements are true about loading data from the "Create an Application From a File" wizard?

 A sample data set from the sample list can be uploaded.

 Seed data from SQL script can be uploaded.
 XML and JSON data can be pasted and loaded.
 Data from remote web services can be uploaded.
 CSV, XLSX, XML, TXT, or JSON files can be uploaded.

33. Which statement is true about Unified Task List in the Approvals component?

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

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

35. There is a page with an interactive grid region based on this statement:

SELECT
EMPNO,
ENAME,
COMM
from EMP;

In the Interactive Grid attributes, under the Edit group, the Enabled switch is turned Off.

Which are two of the actions that you must perform to make an employee's commission editable in the grid?
 Set EMPNO, ENAME to "Display Only".
 In the Interactive Grid attributes, select COMM for "Allowed Row Operations Column".
 Ensure that the "Primary Key" switch is turned "On" for the EMPNO column.
 In the Interactive Grid attributes, turn "On" the Enabled switch, under the Edit group.

36. Which statement is true about using SQL Commands?

 You can design and prototype data models using a markdown-like shorthand syntax.
 In SQL Commans, you can view queries saved in Query Builder.
 You can unload data from the database.
 You can search and filter database objects.

37. 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.
 A workspace enables multiple users to work within the same APEX installation.
  A workspace can be associated with only one schema.
 You can create only two workspaces in an APEX Service (APEX Application Development) instance.

38. Which statement is true about Theme Styles in Oracle APEX?

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

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

 Setting the n Data Change attribute valuetlide to Left
 Setting the Hide and Show Behavior attribute value to Rescale
 Setting the Hide and Show Behavior attribute value to No Rescaling

40. Which two approaches can be used to create custom stored procedures in SQL Workshop?

 Using Object Browser

 Using Quick SQL
 Using SQL scripts
 Using Data Workshop

41. Which two tasks can you perform using SQL Workshop?

 Track and manage issuesin conversational fashion.

 Edit an application page.
 Create join queries using drag and drop.
 Install and manage Sample Apps.
 Load and unload text, DDL, and spreadsheet data.

42. Which two Plugin types can be created in Oracle APEX?

 Region
 Validation
 Email Template
 Process
 Previous

43. 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 remote Oracle Database

This REST Data Source is being used as 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?

 PUT
 GET
 POST

44. Which two statements are true about the usage of a Remote Server in the context of REST Data Sources?

 A single REST Data Source can use multiple remote servers.

 The remote server should mandatorily be APEX instance.
 Multiple REST Data Sources can reference single remote server.
  The remote server determines the base URL of the REST Data Source.

45. Which is a valid method of logging messages to the execution log in APEX automation?
 apex error.add error (
'.'%I q pesout. WVN: ||, 1O3 TVS, <= abessau d
p display location => apex error.c inline in notification );
 apex debug.info ('SAL for ' || :ENAME || ' increased by 1%.');
 apex automation.log info ('SAL for ' || :ENAME || ' increased by 1%.') ;

46. 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.
Now, you need to reposition the items and display P21_UNIT_PRICE next to P21_PRODUCT NAME.

Which two statements are true?

 In Page Designer, select P21 PRODUCT NAME and then in the Property Editor, under Layout set Start New Row to Yes.
 In Page Designer, select P21 UNIT PRICE and then in the Property Editor, under Layout set Start New Row to Yes.
 In Page Designer, right-click P21 UNIT PRICE and select Start New Row.
 In Page Designer, use the Middle Pane, click P21 UNIT PRICE and drag the item until it is directly next to P21 PRODUCT
NAME.

47. Which two statements are true about Faceted Search pages?
 Facets map to specific database columns.
 Faceted Search supports the ability to filter columns storing multiple values as one string
 A facet's chart canbe seeonly i nonmodal dialog.
 Multiple charts are not visible in the same region.

48. 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?
 Date Picker
 Checkbox Group
 Range
 Popup LOV

49. 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
 Column Toggle Report
 Interactive Grid
 Interactive Report

50. Which two are valid evaluation points for Authorization Schemes?

 Once per session

 Once per user
 Never
 Once per page view

51. You added Access Control feature pages to your application.

Which two actions can you perform as an Administrator using the Administration page?
 Create new application roles
 Assign roles to users
 Add Users
  Create Aythorization schemes'

52. Which two feature pages can you create using the Create Page Wizard?

 Feedback
 Unified Task List
 Access Control
 Search Page

53. Which two statements are true about a Progressive Web Application (PWA)?

 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.
 Enabling the PWA functionality in your APEX app adds a new navigation bar entry named Install App to your app.
 PWA features will be rendered even if the application is served in an unsecured environment.
 You can create a PWA only when creating a new application with the Create Application Wizard.

54 examine this exhibit.

Which two statements are true about the Create Application Wizard?
 It allows application pages to be added or deleted.
 It allows application pages to be reordered.
 It allows the application authorization to be changed.
 It allows the uploading of JavaScript or CSS files required for an application.

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

 Navigate to the faceted search region Attributes, and turn off the Show Facet Name attribute.
 Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute.
 Navigate to each facet and then in the Property Editor, turn on Client-Side Filtering.
 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.

56. Which statement is true about session state management in Oracle APEX?

 A user cannot run multiple instances of an application simultaneously in different browser programs.
 Multiple number of sessions cannot exist in the database at the same time.
 APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests.

57. Examine these statements:

create table dept (

id number generated by default on null as identity
constraint dept id pk primary key,
name varchar2 (255 char) not null,
age number
);
create table emp (
id number generated by default on null as identity
constraint emp id pk primary key,
dept id number
constraint emp dept id fk
references dept on delete cascade,
 name varchar2 (255 char) not null,
email varchar2 (255 char)
constraint emp email unq unique,
position varchar2 (8 char) constraint emp_position_ck
check (position in ('MANAGER', 'CLERK', 'ENGINEER') )
);

Which Quick SQL code can generate these statements?

 dept
name /nn
age num
emp
name /nn
email /unique
position /check Manager, Clerk, Engineer
 dept
name /nn
age num
emp
name /nn
email /unique
position /Values Manager, Clerk, Engineer

 dept
name /nn
age num
emp
name /nn
email /unique
position /check Manager, Clerk, Engineer
 dept
name /nn
age num
emp
name /nn
email /unique
position /check Manager, Clerk, Engineer

You must generate a SQL insert statement for the DEPT table in Quick SQL.

58. Which two statements will do that?

 dept /insert
name
 dept /insert 1
name
 dept
name /insert 1
 dept
/insert 1 name