TEST Apex

1. 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?. #APEX.PK_VALUE#, #APEX.NEW_START_DATE# and #APEX.NEW_END_DATE#. :APEXSPK_VALUE, APEX$NEW_START_DATE and :APEX$NEW_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#.

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

3. Which two statements are true about creating and managing an APEX Workspace?. A workspace enables multiple users to work within the same Oracle APEX installation. You can create only two workspaces in an APEX Service (APEX Application Development) instance. New schemas cannot be created during workspace creation. A workspace can be associated with only one schema. During workspace creation, you can associate the workspace with an existing database schema.

4. Which statement is true about using SQL Commands?. You can design and prototype data models using a markdown-like shorthand syntax. You can unload data from the database. In SQL Commands, you can view queries saved in Query Builder. You can search and filter database objects.

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

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

7. Which two are valid evaluation points for Authorization Schemes?. Never. Once per user. Once per page view. Once per session.

8. 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 a SQL script can be uploaded. Data from remote web services can be uploaded. XML and JSON data can be pasted and loaded. CSV, XLSX, XML, TXT, or JSON files can be uploaded.

9. Which two statements are true about the Link Column attribute of an interactive report?. It is not possible to exclude Link Column. If you select Link Column, it is always displayed as the last column in the report. It is not possible to include a custom target in Link Column. A Link Column cannot be sorted, hidden, or moved by an end user.

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

11. 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 can specify an Authorization Scheme at the column level. You cannot restrict users from saving private reports by using the Authorization Scheme.

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

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

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

15. Which statement is true about the Data Workshop utility?. You cannot load data from an XLSX file with multiple worksheets. You can load or unload multiple tables at a time. The wizards load and unload table data only. The wizards load and unload all types of schema objects.

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

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

18. 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, 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. 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 the in the Property Editor, under Layout set Start New Row to NO.

19. Which statement is true about session state management in Oracle APEX?. Multiple number of sessions cannot exist in the database at the same time. A user cannot run multiple instances of an application simultaneously in different browser programs. APEX Sessions are logically and physically distinct from Oracle database sessions used to service page requests.

20. 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?. 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. Verifying the theme subscription.

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

22. 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 an APEX instance. Multiple REST Data Sources can reference a single remote server. The remote server determines the base URL of the REST Data Source.

23. 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 (PRODUCT_ID) 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;.

24. Which two statements are true about the APEX_MAIL API?. You can send emails using the APEX_MAIL package from 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 receive emails using the APEX_MAIL package in an Oracle APEX application.

25. 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". 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. In the Interactive Grid attributes, select COMM for "Allowed Row Operations Column".

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

27. 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: SELECT emp_name d, emp_id r from employees ORDER BY 1; Which item type can be used to display P5_MANAGER?. Popup LOV. Switch. Check box.

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

29. Which is a valid method of logging messages to the execution log in APEX automation?. 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%.');. apex_debug.info ('SAL for'||:ENAME|| increased by 1%.');.

30. 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. Then, navigate to each facet and in the Property Editor, turn on client-Side Filtering. 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.

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

32. 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 No Rescaling. Setting the Hide and Show Behavior attribute value to Rescale. Setting the on Data Change attribute value to slide to Left. Setting the Hide and Show Behavior attribute value to None.

33. 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 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. The suggestion chip count is only displayed for filters that support counts, such as LOV-based filter types.

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

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

36. Which statement is true about creating and using a report with form?. The Create Application Wizard doesn't support the creation of an interactive 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. The Create Page Wizard doesn't support the creation of a classic report and form combination.

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

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

39. 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. Popup LOV. Range.

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

41. 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?. Interactive Grid. Classic Report. Column Toggle Report. Interactive Report.

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

43. Which statement is true about creating and using pages in an APEX application?. A user cannot interact with a nonmodal dialog and content on the page. You can copy a page only from the current application. Modal and nonmodal dialog pages are supported only if the current application theme contains at least one page template of type Dialog Page.

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

45. Which authentication scheme type supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards?. Social Sign-In. Open Door Credentials. SAML Sign-In. HTTP Header Variable.

46. Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?. On the remote Oracle Database, install ORDS 19.x 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.

47. Which two statements are true about REST Data Source Synchronization?. 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. If the local table is not in sync with the Data Profile, Data Synchronization doesn't work. 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.

48. Which statement is true about Unified Task List in the Approvals component?. It is a page type in the Create Page Wizard that is used to create a summary of tasks that functions like an inbox. 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.

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

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

51. Now you must extend the functionality of this form so that: <PIC> • 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, 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. Create a dynamic action on P2_JOB. Create a dynamic action on P2_HIREDATE and P2_COMM.

52. Which is NOT a valid Geometry Column Data Type available for maps region?. Latitude/Longitude. SDO GEOMETRY. GeoJSON. JSON_OBJECT.

53. Examine this code used in Quick SQL: students name 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) not null, 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), roll_no number ) ;. An Invalid column definition error message will be displayed.

54. Examibe 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_ung 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 /check 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 /values Manager, Clerk, Engineer.

55. Which statement is true about importing an APEX application?. You cannot import an APEX application exported from a latest APEX version to an old APEX version. The import process does not import the supporting objects defined during the export. You cannot change the application ID during the import process.

56. Which statement is true about Theme Styles in Oracle APEX?. 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. Theme Styles in Oracle APEX determine the layout and structure of a webpage.

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

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

59. 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 ran this be achieved?. On the Application Homo page, click Create Page. In the Create Page Wizard, select the Activity Reporting feature typo. On the Application Home page, click Create Page. In the Create Page Wizard, select the Master Detail page type. 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.

60. Which two actions can you perform using the Object Browser?. Browse database objects of the current schema. Export and import SQL scripts. Restore dropped database objects. Create and run SQL scripts. Create a lookup table based on a column in the current table.

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

62. Which statement is true about creating and using an interactive grid?. End users cannot rearrange columns by dragging and dropping. 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.

63. Which two tasks can you perform using App Builder?. Create and manage apps. Create and manage database objects. Generate data definition language (DDL) statements from the Oracle data dictionary. Import previously exported apps. Create join queries using drag and drop.

64. You must generate a SQL insert statement for the DEPT table in Quick SQL. Which two statements will do that?. dept name /insert 1. dept /insert name. dept/insert 1 name. dept /insert 1 name.

65. An application was created using the Create Application Wizard which enabled the Access Control feature. Which two components are created when enabling the Access Control feature?. The configuration page to set access level of authenticated users. The configuration page to enable end users to select various theme styles. The configuration page to set roles of workspace users. The administrative page region with links to Access Control feature. The configuration page to enable Administrators to select default theme.

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

67. Examine this code entered in Quick SQL: 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 default to TRUE. It will restrict acceptable values to Y or N. It will restrict acceptable values to TRUE or FALSE.

68. Which two tasks can you perform by using Page Designer?. Copy an application. Modify a button. Create an application. Import an application. Add a new region or an item.

69. Which two report types can you create by using the Create Page Wizard?. REST Data Sources. Faceted Search. Quick SQL. Smart Filters. Build Options.

70. Which statement is true about reports in Oracle APEX?. An interactive reports allows end users to customize the report layout and data displayed by selecting options on the Actions menu. A classic report page includes the customization capabilities available in interactive reports, as well as the ability to rearrange the report interactively using the mouse and keyboard. You can create a report only by using Create Application Wizard, not by using Create Page Wizard. An interactive page features colorful blocks, which resemble index cards, laid out on a page.

71. Which is NOT a Preconfigured Authentication Scheme?. Database Accounts. Application Express Accounts. Closed Door Credential. No Authentication.

72. Which two self-service tools are available with Autonomous Database?. Encryption only in Object Storage. Business Objects. Oracle Machine Learning. Low Code App Dev, APEX.

73. Which statement is true about creating and using forms in an APEX application?. A Stacked Master Detail is a single page master-detail utilizing side-by-side layout and report regions with modal edit windows. You can create a form only by using the Create Page Wizard. You can create a form in Page Designer. The Master Detail form enables users to insert, update, delete values from two tables or views. You can create a form only by using the Create Application Wizard. You cannot create a form in Page Designer.

74. Which pane in Page Designer allows the editing of a component’s properties?. Toolbar. Right pane. Central pane. Left pane.

75. Which is a standard for exchanging authentication and authorization information between different security domains, to provide cross-organization single sign-on?. Open ID. Security Assertion Markup Language. Sign-on System. Virtual Private Database (VPD).

76. Which statement is true about implementing security in your APEX application?. Authentication refers to restricting access to specific pages and components in your application based on your privileges. Once created, you cannot change the authentication scheme associated with an application. Confirming a user's identity before allowing access to the application is known as authorization. You can apply an authorization scheme to an entire application or its components.

77. Which two spatial geometry objects are supported on a Map page in your APEX application?. Range. Box Plot. Radar. Lines. Points.

78. Which statement is true about page components?. Pages require one of each component. Pages contain user interface elements. Items can be regions on a page. Regions contain pages and items.

79. In a Master-Detail form, what do you need to specify to link the Detail to the Master?. Master Block. Master Table. Master Form Process. Master Region.

80. Which statement is true about provisioning an APEX workspace?. An APEX workspace is a shared work area where multiple developers can build applications. You can create only one workspace in an APEX instance. A workspace is not associated with any schema. You cannot associate an existing database schema with your workspace.

81. Which two tasks can you perform using Quick SQL?. Export an application. Compare schemas. Quickly develop a script for sample tables and views. Import an application. Easily generate random data.

82. Which two types of pages can you create by using the Create Page Wizard?. Blank Page. Interactive Grid. Shared components. Utilities. Team Development.

83. Which statement is true about a Progressive Web Application (PWA)?. To make an existing app a PWA, you must verify that the Friendly URLs attribute is off in the Application Definition, Properties section. PWA features will be rendered even in an unsecured environment. Enabling PWA functionality in your APEX app adds a new navigation bar entry named Install App to your application. You can only create a PWA when creating a new app. You cannot make an existing app a PWA.

84. Which two types of calendars are supported by App Builder?. Calendar. Global Calendar. Regional Calendar. Legacy Calendar.

85. What you can export by using the Export/Import utility?. All the options. Application. Uploaded cascading stylesheets. Uploaded images.

86. Which statement is true about exporting and importing your APEX application?. You can export APEX application as zip file. Using the Export Application Wizard, you can only export the application but not the supporting object definitions. Your application is saved as .txt file. You can export an APEX application from an instance running APEX 22.1 and import into APEX 21.1 version.

87. Which statement is true about creating and using a calendar in an APEX application?. You can create a calendar only by using the Create Page Wizard, not as a region on an existing page. Calendars in APEX are based on a table or SQL query you provide. You can create a calendar only by using the Create Application Wizard, not by using the Create Page Wizard. The data source for your calendar can only be a local database, not an external datasource.

88. Which two approaches can be used to create custom stored procedures in SQL Workshop?. Quick SQL. Data Workshop. Standalone SQL commands. Procedure Builder. SQL scripts.

89. Which two statements are true about low code application development with Oracle APEX?. Application Development IDE is web browser. Data processing is not done in the database. Apps cannot natively access Oracle Database capabilities. The application definition is not stored in the database. Using APEX, you can build mission-critical enterprise apps.

90. Which statements are true about creating applications using Oracle APEX?. When creating an application from a file, you can only load data into a new table but not to an existing table. Using the Create Application Wizard, you can only create an application from file. Oracle APEX application pages share a common session state and authentication. Once an application is created, you cannot create additional pages. Using the Create Application Wizard, you can only create an application based on existing tables.

91. Which two form types can you create in an APEX application?. Editable Interactive Grid. Rest Data Source. Quick Edit. Master Detail. Smart Filters.

92. By default, which interactive grid report type can be created by an end user?. Public report. Alternative report. Primary report. Private report.

93. Which two are features of the Data Load utility in Data Workshop?. Omit (skip) records when loading based on a function. Load XML, JSON, XLSX files, or delimited-field text files. Omit (skip) columns when data loading. Load data into multiple tables at once. Create an application from the data loaded.

94. Which two tools are included in SQL Workshop?. Object Browser. Gallery. SQL Scripts. Team Development. Milestones.

95. In which two cases, can you use classic reports?. To provide basic sort and search options. To provide optimal reports on smart phones. To provide options to save your customization within the application. To provide the customization option. To provide the download option.

96. Which two processes takes place when the APEX engine runs Accept Page?. Save submitted values. Computations and validations. Navigation to different pages. Show page.

97. Which statements are true about session state?. Sessions are same as the database sessions. Sessions are completely independent of each other. Sessions are limited and can only be on single instance. Each session has a single identifier.

98. Which Two statements are true about using Oracle APEX Application Development (APEX Service)?. There is a limit on the number of applications that can be developed. There is a limit on the number of end users using your apps. There is a limit on the number of developers using your service. It includes Oracle REST Data Services (ORDS). It includes Oracle Database Actions (SQL Developer Web).

99. Which two preconfigured authentication schemes are supported by Oracle APEX?. Reader Rights. Social Sign-in. Database Accounts. Administration Rights. Contribution Rights.

100. Jenny has a form page based on ORDER_ITEMS. For certain product types, she needs to redirect to a modal dialog page to ask for additional information, before validating or processing the record on page submission. Which processing point should Jenny select for the branch?. After Processing. After Submit. Processing. Before Computations.

101. Which three statements are true about Theme Styles?. Theme Roller enables you to quickly change the theme style. Developers can edit a Theme Style from the Create Page wizard. You can enable users to select a theme style in a running application. Developers can edit a Theme Style from the Themes page. A theme can have multiple theme styles set as active.

102. You want to enable anyone to access your application using a built-in login page that captures a user name. Which authentication scheme would you choose?. Custom Authentication. Social Sign-In. No Authentication. Open Door Credentials.

103. Which two statements are true about Maps in Oracle APEX?. Maps don't support REST Data Sources. Background maps do not require any API keys. Heat Map and Polygons are not supported Spatial geometry objects. Maps support REST-Enabled SQL.

104. Which two statements are true about a Faceted Search page?. Show search results as cards or a classic report. Includes the ability to rearrange the report interactively using the mouse or keyboard. Includes a search field at the top of the page with filters that display as suggestion chips. Allows to toggle between a bar chart and a pie chart type.

105. You want to create a search configuration in Shared Components. Which search type is supported?. Navigation. Menu. Build Options. List.

106. Which statement is true about the Approvals component?. Unified Task List is a shared component used to configure task parameters, participants, actions, and due dates. Task Definition is a page that shows details for a specific task, which can include metadata, history, comments, and actions. APEX_APPROVAL is Page processes that create and act on task instances in your pages. You can set up task approvers and administrators at design time or determine them dynamically at runtime based on data related to the task.

107. Which statement is true about using the App Gallery?. You cannot install Sample Apps and Starter Apps directly from the Gallery. You can download Sample Apps and Starter Apps from Team Development to import into your workspace. Sample Apps and Starter Apps are only available if your instance administrator has enabled them. Custom Apps are only available if your instance administrator has enabled them.

108. In Quick SQL, you entered this shorthand syntax: departments /insert 10 name location vc255 employees /insert 20 name email hiredate Which two statements are true about the generated SQL?. DEPARTMENTS and EMPLOYEES tables will have a primary key in each and a foreign key relationship linking EMPLOYEES to DEPARTMENTS. Creates EMPLOYEES table with four columns. Creates DEPARTMENTS table with two columns. Inserts 10 rows of random sample data into the DEPARTMENTS table.

109. Which two statements are true about REST Data Sources?. REST Data Sources doesn't support any authentication. A REST Data Source can contain one or many Operations, which are the references to a concrete external web service. Oracle APEX doesn't provide direct integration of REST Data Sources in interactive reports. Oracle APEX supports the REST Enabled SQL Query REST Data Source type.

110. In your application, you want to include a master detail containing two pages based on two related tables or views. The first page contains an interactive report for the master table. The second page features a standard form for the master and interactive grids for the detail. Which master detail form will you create?. Side by Side Master Detail. Stacked Master Detail. Drill down Master Detail. Editable Interactive Grid.

111. Which two of the following capabilities are TRUE for both Interactive Report and Interactive Grid?. End user can rearrange the report interactively using the mouse. End user can add, modify, and refresh data directly on the report. End user can save the report. End user can customize how and what data is displayed.

112. I want to hide a few columns in my interactive report. To do so, which option should I choose from the Actions menu?. Filter. Data. Columns. Format.

113. You can create a report in which of the three following methods?. Create a report as a new page in an application. Create a report when you create a new database application. Create a report from Object Browser. Create a report region on a page in an application.

114. In a Classic Report, an end user can perform which two of the following actions?. Create Control Breaks in the report. Rearrange the columns in the report. Filter values of a column in the report. Sort the columns of the report.

115. Which two types of pages behave similarly in functionality?. Map. Cards. Faceted Search. Smart Filter.

116. Which two among the following are TRUE about Low Code Apps?. Scalable. Not Mobile Friendly. Provide Rich Functionality with Less Code. Expensive.

117. Which two are true about Oracle APEX?. Performs the data processing in a middle-tier server. Requires no additional client software. A web browser is the app development IDE. Requires developers to be proficient in Java, Python and other programming languages. Is declarative. It requires no code generation.

118. Which three are the main components of APEX workspace homepage?. Gallery. RESTful Services. SQL Workshop. App Builder.

119. Using Data Workshop, you can perform which three tasks: Delete data from the database. Load vast amount of data into the database. Export vast amount of data from the database into a file. Load data using various file formats such as XLSX, CSV, XML, and JSON.

120. Which component in SQL Workshop allows you to build queries graphically without manual SQL coding?. Quick SQL. Query Builder. SQL commands. Data Workshop.

121 What three are the result of the following QuickSQL shorthand notation do? departments /insert 4 name /nn location country. Create the departments table with 4 columns. Creates an id column as a primary key. Create the departments table with 3 columns. Inserts 4 rows of random data into the departments table.

122. From SQL Workshop, you can perform which two of the following actions?. Create an APEX user. Run SQL commands and scripts. Delete database. Create and view database objects.

123. Choose the two statements that are TRUE about the Universal Theme in APEX. Not designed to work on tablets. Responsive UI. Easy customization. The developers must have extensive knowledge about Javascript, CSS and HTML in order to.

124. Choose the three correct options in the given friendly URL syntax: https://example.com:5500/ords/r/mycompany/hr-app/updateemployees?. session=13766599855150 Ahr-app is the application alias. update-employees is the PL/SQL procedure to update the employee details. mycompany is the path-prefix which is by default the workspace name. 13766599855150 is the session ID. A new ID is generated for each session.

125. Using the App Builder component, you can perform which three tasks?. Edit pages in the page designer. Run SQL scripts and commands. Install a sample App. Create a new App.

126. Which three of the following options are TRUE about a page in an APEX application?. A page can contain buttons, page items and regions. An APEX application can have only one page. To view the rendered version of the page, you run or submit it to the Oracle APEX engine. A page can be viewed and edited in the Page Designer.

127. Choose the two correct statements about PWA. Provides a customizable offline page when users are offline and cannot request the network. To download the app as PWA, one must visit the App Store. An existing APEX app cannot be made a PWA. Enables users to install the application on devices.

128. The Page Designer Toolbar allows you to perform which two of the following actions?. Delete the application. Navigate to Shared Components. Export the application. Create a new page.

129. When a button is pressed, an overlay window is positioned within the viewport. What kind of page mode is it?. Help Page. Modal Dialog. Normal Page. Non-Modal Dialog.

130. Choose the three different ways in which you can add a checkbox to a page. Drag and drop the checkbox item into the Layout pane. Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type. Use the context sensitive menu in the Gallery pane. Add a checkbox from the Property Editor.

131. Choose the two statements that are TRUE about an Interactive Report. As a developer: You can customize the Actions menu to include or exclude certain options. You can modify the data in the report after running the app. You can customize the pagination. You cannot modify the report source query.

132. Choose the three types of aggregations you can apply on a column. Average. Standard Deviation. Sum. Count.

133. Which two of the following types can an end user save the customized Interactive report as?. A Public report. Cannot save the report. A private report. Default report.

134. To highlight certain rows in the interactive report based on a condition, you must: Provide a conditional SQL query. Edit the rows in the report and select a color. Rows cannot be highlighted in an Interactive report. Choose a condition in Format > Highlight.

135. Choose the two options provided in a Column Heading menu of an Interactive Report. Control Break. Group By. Hide. Delete.

136. Which two statements that are TRUE about charts in Interactive grid?. You can create multiple charts at a time in an interactive grid. To remove a chart, click the Remove Chart icon (X) adjacent to the chart filter. Once a chart is created, you can switch the view between Grid and Chart view. Once the chart is created, it cannot be reconfigured.

137. Which three of the following statements are TRUE about saved Public Interactive Grids?. Public reports are available to all users. To enable an end user to save a public interactive grid, the user must have the required. Any user may save public interactive grids. Only the user who creates a public interactive grid can save, rename, or delete it.

138. When a table or a SQL query returns many rows, an Interactive Grid is best displayed to the user with pagination. The two types of pagination available are: Scroll. Page. Page and Scroll. No Pagination.

139. Which two are true when the Edit option is NOT enabled for an Interactive Grid?. The end user cannot edit the underlying data in the database. The end user can edit the underlying data in the database. The end user can customize the report. The end user cannot create charts.

140. Choose the three types of page items that can be placed on a page. Global variable. Checkbox. Date Picker. Select List.

141. What are the three types of List of Values(LOV) you can create on a page?. Static LOV. Cascading LOV. Dynamic LOV. Popup LOV.

142. Let's say that there are two select lists on a page. Making a selection in the DEPARTMENT select list, determines which individuals display in the Employees select list. This type of LOV is called: Popup LOV. Cascading LOV. Static LOV. Dynamic LOV.

143. Consider a customers report. A customer name is clicked in the report to display the Customer Details form. When the items in the form dialog are updated and the user clicks Apply Changes, the page process is executed and the items from the page are used to update and commit the underlying table in the Oracle Database. What are the two types of events that occurred in this scenario?. Page Refresh. Page Validation. Page Rendering. Page Processing.

144. When you run an application, the APEX engine relies on which two processes?. Show Page. Run Page. Validate Page. Accept page.

145. When you click a Customer Name in the Customers report, the Customer Details form dialog page is displayed. What are the events that occur in this scenario?. Page Processing. Page Rendering. Page rendering and processing. Page compilation.

146. A Page Computation can be created from which two of the following tabs?. Rendering Tree. Processing. Dynamic Actions. Shared Components.

147. In an Employee form, the 'Commission' and 'Hire Date' fields are enabled only if the Job is 'Salesman'. This can be achieved by which feature of APEX?. Processing. Conditional SQL. Dynamic Actions. PL/SQL procedure.

148. To create a Dynamic Action, you need to specify which three of the following options?. What action or actions are performed. When the action occurs. What elements are affected by the action. Why the action is performed.

149. Choose the three Form types that you can create using the Create Page wizard. Interactive Grid. Interactive Report. Form. Master Detail.

150. Consider a page in an APEX app where the Departments names with location is displayed on the left. Selecting a Department on the left will render details of the employees corresponding to that department on the right. Which kind of report/form is this?. Cards. Stacked Master Detail. Side by Side Master Detail. Interactive Report.

151. What are the three types of Master Detail Form you can create in APEX?. One Below the other. Stacked. Side by Side. Two Page Drill Down.

152. Select the three ways in which you can create a Form in APEX. Using the Create Page wizard. Using Shared Components. Create a Form region in Page Designer. Using the Create Application Wizard.

153. Select the three types of Facets you can create in APEX. Range. Text Area. Checkbox Group. Input Field.

154. Which three of the following statements are TRUE about Faceted Search?. After the end user changes a facet, the results, dependent facets, and occurrence counts. The right side of the page features a Search Results region, which can display as a classic. You can create only 5 facets per page. The facets are displayed on the left and upper part of the screen.

155. Select two features of a Smart Filters Page. Consists of a single search field with filters at the top of the page and a report at the. Each filter represents the text entered by the end user in the search field. Each filter displays as a suggestion chip with a single count of how often the specific. Consists of filters at the left side and report on the right side of the page.

156. Select the three types of Card Layout you can create in APEX. Vertical(Column). Float. Grid. Horizontal(Row).

157. Which three statements are TRUE about Search Configuration?. Searches can be based on Local data, APEX Lists, REST Enabled SQL Service, or REST Data. Search Configuration is a shared component defines the data source to be searched and the. One or more Search Configurations can be configured in a Search Page. Only one Search Configuration can be used in a Search Page.

158. Generally, clicking on the hamburger menu in the upper-left corner of an APEX application displays a list of pages. What is this navigation called?. Lists. Navigation Menu. Breadcrumbs. Navigation Bar List.

159. Which three statements are TRUE about Shared Components?. Once you create a Shared Component, you can add them to any page within your APEX. Shared components are common elements that can be displayed or applied on any page. Once you create a Shared Component, you can add them to any page within an APEX. Breadcrumbs, Lists, and Navigation Bar entries are examples of shared components.

160. Select the two places from where you can access the Shared Components Page?. Gallery. Page Designer. Application homepage. SQL Workshop.

161. What are the three key features of Universal Theme?. Support for single theme. Versatile UI Components. Responsive Design. Easy Customization.

162. Which of the following options in the Developer Toolbar enables you to customize the look and feel of the application?. Quick Edit. Customize. Session. Debug.

163. What three are the building blocks of Approvals Component?. Task Details Page. Automations. Task Definition. Unified Task List.

164. Which three of the following are use cases of Automations?. Deleting a database record based on an end user's request. Monitoring log tables and raising an alert when there is an issue. Approving specific requests. Sending email alerts at a particular time of the week.

165. Which three of the following statements are TRUE about Data Synchronization?. Data Synchronization enables developers to automatically sync the contents of a local table. APEX can create the local table based on the visible columns in the REST Data Source Data. Helps in Providing efficient reporting on large data sets coming from a REST service. You must trigger Data Synchronization manually.

166. Choose the three requirements for creating a REST Enabled SQL Reference. Install Oracle REST Data Services (ORDS) 19.x or later. Activate REST Enabled SQL for the target schema on the remote database. Set up any remote database. Configure and enable the REST Enabled SQL service feature.

167. What three are the key features of Data Load Definition?. The APEX_DATA_LOADING PL/SQL API is available for custom processing. Only XML data format can be loaded to tables or collections. Column mapping occurs at design time, removing the burden on end users. Easy workflow for end users: upload the file, verify the preview, and load data.

168. What three are the uses of Collections in APEX?. You insert, update, and delete collection information using PL/SQL API APEX_COLLECTION. Use collections to temporarily capture one or more nonscalar Values. Collections enable you to store rows and columns in the current session into database tables. Collections can be accessed, manipulated, or processed during a user's specific session.

169. You can apply an authorization scheme for which three of the following components?. Specific control such as region, item or button. A page. A session. An entire application.

170. When you create an Access Control Page, which three of the following Access Roles get created?. Developer. Reader. Administrator. Contributor.

171. The APEX engine uses which component as a key for tracking each user's session state?. APEX_USER. APP_USER. HTTP_USER. LDAP_USER.

172. In APEX, you can choose which three of the following Authentication methods?. Custom Authentication Scheme. No Authentication. Built-in Authentication Scheme. Authorization Scheme.

173. Select the two advantages of using One-click Remote Deployment. You need to access your production environment to import the app directly. Deploy the app, and explicitly install the supporting objects in one-click. Directly deploy your app definition along with the objects from the source system to the. Simplify the process of deploying an application.

174. While migrating apps, once the database objects are created in the target environment, you can load the data using which of the components?. Data Workshop. Data Generator. App Builder. Quick SQL.