Font size
WorksheetsOracle APEX Quiz
Total questions: 94
Worksheet time: 3570secs
Using the App Builder component, you can perform which three tasks?
Create a new App
Edit pages in the page designer
Run SQL scripts and commands
Install a sample App
Which is a valid Page Process type?
Set Value
Execute JavaScript Code
Send E-Mail
Which two statements are true about Faceted Search pages?
A facet's chart can be seen only in a nonmodal dialog.
Facets map to specific database columns.
Multiple charts are not visible in the same region.
Faceted Search supports the ability to filter columns storing multiple values as one string.
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 v('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 &P1_ENAME, as the new employee of the month!
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?
Checkbox Group
Popup LOV
Range
Date Picker
Choose the three correct options in the given friendly URL syntax:
mycompany is the path-prefix which is by default the workspace name
update-employees is the PL/SQL procedure to update the employee details.
13766599855150 is the session I A new ID is generated for each session.
Which statement is true about creating and using pages in an APEX Application?
Modal and nonmodal dialog pages are supported only if the current application theme contains at least one page template of type Dialog Page.
A user cannot interact with a nonmodal dialog and content on the page
You can copy a page only from the current application
Which statement is true about using SQL Commands?
You can search and filter database objects.
You can design and prototype data models using a markdown-like shorthand syntax.
In SQL Commands, you can view queries saved in Query Builder.
You can unload data from the database.
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 from Object Browser
Create a report when you create a new database application
Create a report region on a page in an application
Which two statements are true about customizing an interactive report by an end user?
Standard Oracle functions cannot be added to columns.
A flashback query can be executed.
Mathematical computations can be added to columns.
From the Actions menu, multiple charts can be created.
Which two tasks can you perform using App Builder?
Import previously exported apps.
Create and manage database objects.
Generate data definition language (DDL) statements from the Oracle data dictionary.
Create and manage apps.
Which is NOT a valid Geometry Column Data Type available for maps region?
SDO_GEOMETRY
JSON_OBJECT
GeoJSON
Latitude/Longitude
Which two statements are true about creating and using dynamic 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
If no client-side condition is defined, true actions will not fire.
Once you create a dynamic action, you cannot add additional true actions.
You can execute JavaScript code by creating a dynamic action.
Which client credentials are utilized for authentication during the One-Click Remote Application Deployment process?
Choose from the following the different kinds of page components you can create in APEX.
Interactive Grid
Search Page
All of them
Smart Filters
Faceted Search
Which two layout options are available for Page Designer under Utilities?
Three Pane Mode
Single Pane Mode
Four Pane Mode
Two Pane Mode
Which three are the main components of APEX workspace homepage?
RESTful Services
Gallery
SQL Workshop
App Builder
Which two tasks can you perform using SQL Workshop?
Load and unload text, DDL and spreadsheet data.
Create join queries using drag and drop.
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
Verifying the theme subscription
Refreshing the templates
Copying the changes made in the master theme to the copied theme
In your application, you want to display data in a searchable, customizable report that supports inline editing at runtime using the mouse or keyboard.
Smart Filters
Interactive Grid
Classic Report
Interactive Report
Which two statements are true about a Progressive Web Application (PWA)?
Enabling the PWA functionality in your APEX app adds a new navigation bar entry named Install App to your app.
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.
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?
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
Column Toggle Report
Classic Report
Interactive Report
An application was created by using the Create Application wizard, which enabled the Access Control feature. Which two components are created when the Access Control feature is enabled?
The configuration page to set roles of workspace users
The administrative page region with links to the access control feature
Which two actions can you perform using the Object Browser?
Which component in SQL Workshop allows you to build queries graphically without manual SQL coding?
Data Workshop
SQL commands
Quick SQL
Query Builder
Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?
Install Oracle APEX in the remote Oracle Database.
On the remote Oracle Database, install ORDS 19.x or later.
Create a database link to the remote Oracle Database in the local APEX Schema.
REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
Which two statements are true about Oracle APEX?
You can build interactive reporting apps based on data from disparate systems.
APEX eliminates middle-tier application logic.
Application definition is not stored in the database.
Running an APEX app needs client software.
Which two among the following are TRUE about Low Code Apps?
Provide Rich Functionality with Less Code
Not Mobile Friendly
Expensive
Scalable
When a user updates an employee record in this interactive grid, which operation (HTTP Method) defined in the REST Data Source is utilized to update a record in the EMP table on the remote Oracle Database?
GET
PUT
POST
DELETE
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, click Create Page. In the Page Wizard, select the Email Reporting feature type.
On the Application Home page, from the task list, click the Add Feature Page button. Then select the feedback feature type.
On the Application Home page, click Create Page. In the Page Wizard, select the Master Detail type.
On the Application Home page, click Create Page. In the Page Wizard, select the Activity Reporting feature type.
Which two statements that are TRUE about charts in Interactive grid?
Once a chart is created, it cannot be reconfigured.
Once a chart is created, you can switch the view between Grid and Chart view.
To remove a chart, click the Remove Chart icon (X) adjacent to the chart filter.
You can create multiple charts at a time in an interactive grid.
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.
The wizards load and unload only specific types of schema objects.
Which two of the following capabilities are TRUE for both Interactive Report and Interactive Grid?
End user can add, modify, and refresh data directly on the report.
End user can save the report.
End user can rearrange the report interactively using the mouse.
End user can customize how and what data is displayed.
Which authentication scheme type supports authentication with social networks and enterprise identity providers that support OpenID Connect or OAuth2 standards?
HTTP Header Variable
Social Sign-In
Open Door Credentials
SAML Sign-In
Choose the two correct statements about PWA.
Provides a customizable offline page when users are offline and cannot request the network.
Enables users to install the application on devices.
An existing APEX app cannot be made a PWA.
To download the app as PWA, one must visit the App Store.
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 Private only
As Public only
As Primary only
You must generate a SQL insert statement for the DEPT table in Quick SQL. Which two statements will do that?
Dept/insert 1 Name
Dept/insert Name
Now you must extend the functionality of 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.
Specify a client-side condition and enter SALESMAN for Value.
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.
Using Data Workshop, you can perform which three tasks:
Export vast amount of data from the database into a file
Load vast amount of data into the database
Load data using various file formats such as XLSX, CSV, XML, and JSON
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 can specify an Authorization Scheme at the column level.
Which statement is true about Unified Task List in the Approvals component?
It allows users to view and manage tasks from multiple sources in a single list.
It only supports tasks from a single source.
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 cannot create charts
The end user can customize the report
Which item type can be used to display P5_MANAGER?
Switch
Check Box
Popup LOV
Radio Button
Which search type in Search Configurations provides linguistic and fuzzy search capabilities?
List
Standard
Oracle Text
Basic
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.
A workspace can be associated with only one schema.
New schemas cannot be created during workspace creation.
You can create only two workspaces in an APEX Service (APEX Application Development) instance.
To highlight certain rows in the interactive report based on a condition, you must:
Rows cannot be highlighted in an Interactive report
Provide a conditional SQL query
Choose a condition in Format > Highlight
Edit the rows in the report and select a color
You added Access Control feature pages to your application. Which two actions can you perform as an Administrator using the Administration page?
Create Authorization schemes
Assign roles to users
Add Users
Create new application roles
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 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.
Navigate to each facet and in the Property Editor, turn on client-Side Filtering.
Navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute
Which two statements are true about creating and customizing Smart Filters pages?
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.
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
Which two of the following types can an end user save the customized Interactive report as?
Cannot save the report
Default report
A private report
A Public report
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.
The Search Results region can be displayed as an interactive report.
If you create a faceted search page based on a table, the facets are not auto-discovered.
If you create a faceted search page on a view or a SQL query, the facets are auto-discovered.
Which two statements are true about creating and using pages in an APEX application? (Choose all correct answers)
Deleting a page does not delete corresponding breadcrumbs or list entries.
Feature pages can be added only once per application.
A user cannot interact with a nonmodal dialog page or its content.
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 the dialog page type.
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 rearrange columns by dragging and dropping.
For both editable and noneditable interactive grids, end users can change the report layout and create private reports.
End users cannot create private reports.
Choose the three types of aggregations you can apply on a column.
Sum
Count
Average
Standard Deviation
There is a validation of type Item is numeric on the P1_SALARY item. When the page is submitted, this message is displayed both in the notification and below the item: 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
Which is a valid method of logging messages to the execution log in APEX automation?
apex_automation.log_info('SAL for '||:ENAME||' increased by 18.')
apex_debug.info('SAL for '||:ENAME||' increased by 1%.')
apex_error.add_error('p_message => 'SAL for '||:ENAME||' increased by 1%.', p_display_location => apex_error.c_inline_in_notification)
Which two feature pages can you create using the Create Page Wizard?
Search Page
Feedback
Access Control
In a Classic Report, an end user can perform which two of the following actions?
Create Control Breaks in the report
Filter values of a column in the report
Rearrange the columns in the report
Sort the columns of the report
Which two functions can be used by an end user when pivoting an interactive report?
List aggregate
Rank
Median
Minimum
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 restrict acceptable values to Y or N.
It will default to FALSE.
It will default to TRUE.
It will restrict acceptable values to TRUE or FALSE.
What are the result of the following QuickSQL shorthand notation do?
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?
Turn "On" the Enabled switch, under the Edit group.
Ensure that the "Primary Key" switch is turned "On" for the EMPNO column.
Select COMM for "Allowed Row Operations Column".
Set EMPNO, ENAME to "Display Only".
Which two statements are true about REST Data Source Synchronization?
If the local table is not in sync with the Data Profile, Data Synchronization continues to work for columns present in both the table and the Data Profile.
The local table can only be used for Data Synchronization but you cannot add indexes or change physical properties.
To execute REST source synchronizations on schedule, the CREATE JOB privilege must be granted to the application's parsing schema.
If the local table is not in sync with the Data Profile, Data Synchronization doesn't work.
From SQL Workshop, you can perform which two of the following actions?
Delete database
Run SQL commands and scripts
Create and view database objects
Create an APEX user
I want to hide a few columns in my interactive report. To do so, which option should I choose from the Actions menu?
Data
Filter
Format
Columns
Which two types of pages behave similarly in functionality?
Map
Smart Filter
Cards
Faceted Search
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?
Choose the two statements that are TRUE about an Interactive Report. As a developer:
You cannot modify the report source query
You can modify the data in the report after running the app
You can customize the pagination
You can customize the Actions menu to include or exclude certain options.
Which three of the following options are TRUE about a page in an APEX application?
To view the rendered version of the page, you run or submit it to the Oracle APEX engine.
A page can contain buttons, page items and regions.
A page can be viewed and edited in the Page Designer.
An APEX application can have only one page.
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.
Seed data from a SQL script can be uploaded.
Which two are valid evaluation points for Authorization Schemes?
Once per user
Once per session
Never
Once per page view
Which statement is true about Theme Styles in Oracle APEX?
Theme Styles in Oracle APEX determine the layout and structure of a webpage.
When the Is Public attribute is enabled, end users can choose the Theme Style from the runtime environment.
You can only enable the Is Current attribute when the Theme Style has the Read Only attribute disabled.
Theme Styles in Oracle APEX determine the color scheme of a webpage.
Which two statements are true about the usage of a Remote Server in the context of REST Data Sources?
The remote server determines the base URL of the REST Data Source.
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.
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
After Header
Before Header
Which two Plugin types can be created in Oracle APEX?
Region
Email Template
Validation
Process
Which two statements are true about loading data from the "Create an Application From a File" wizard?
CSV, XLSX, XML, TXT, or JSON files can be uploaded.
Seed data from a SQL script can be uploaded.
XML and JSON data can be pasted and loaded.
You can create an APEX workspace and build APEX apps on which of the following platforms?
Oracle Autonomous Cloud
Amazon RDS
Microsoft Azure
Oracle XE
All of the above
Which two actions enable "hide and show" behavior of a data series in a bar chart when its corresponding legend item is clicked?
Setting the Hide and Show Behavior attribute value to Rescale
Setting the Hide and Show Behavior attribute value to No Rescaling
Setting the on Data Change attribute value to slide to Left
Setting the Hide and Show Behavior attribute value to None
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?
Master Detail
Unified Task List
Cards
Interactive Grid
Which statement is true about importing an APEX application?
You cannot change the application ID during the import process.
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 import an APEX application exported from an old APEX version to a latest APEX version.
When a button is pressed, an overlay window is positioned within the viewport. What kind of page mode is it?
Non-Modal Dialog
Modal Dialog
Help Page
Normal Page
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 the application authorization to be changed.
It allows application pages to be reordered.
Choose the two statements that are TRUE about the Universal Theme in APEX
Easy customization
Not designed to work on tablets
Responsive UI
The developers must have extensive knowledge about Javascript, CSS and HTML in order to use the Universal Theme.
Which two Query Source types can be used to create a dynamic Navigation Bar List?
Select List
Procedure
SQL Query
Function Returning SQL Query
Which two are true about Oracle APEX?
Performs the data processing in a middle-tier server
Is declarative. It requires no code generation.
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.
Which two statements are true about the APEX_MAIL API?
You can receive emails using the APEX_MAIL package in an Oracle APEX application
You can send emails using the APEX_MAIL package from an Oracle APEX application.
You can add files as attachments to your emails using the APEX_MAIL package.
The APEX_MAIL package supports sending emails only to Oracle database users.
Choose the two options provided in a Column Heading menu of an Interactive Report.
Group By
Hide
Control Break
Delete
Choose the three different ways in which you can add a checkbox to a page.
Use the context sensitive menu in the Gallery pane.
Right click Body in the Rendering Tree and add a New Page Item as Checkbox Type.
Add a checkbox from the Property Editor
Which statement is true about the Link Column attribute of an interactive report?
A Link Column cannot be sorted, hidden, or moved by an end user.
If you select Link Column, it is always displayed as the last column in the report.
It is not possible to exclude Link Column.
It is not possible to include a custom target in Link Column.
You must create a single master detail page where users can select a row in the master grid to update the detail grids. Which type of master detail implementation should you use?
Stacked
Drill Down
Side by Side
Which statement is true about creating and using a report with 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).
The Create Page Wizard doesn't support the creation of a classic report and form combination.
Both the Create Application Wizard and Create Page Wizard support the creation of an interactive report or classic report and form combination.
Which two approaches can be used to create custom stored procedure in SQL Workshop?
Using SQL scripts
Using Quick SQL
Using Object Browser
Using Data Workshop
