1z0-770 Practice Exam Questions with Answers Oracle APEX Cloud Developer Professional Certification

APP_USER is a built-in substitution string in Oracle APEX that stores the user name of the current user session. The APEX engine uses APP_USER as one component of a key for tracking each user’s session state. As a user navigates from page to page, the APEX engine sets the value of APP_USER to identify the user. The APEX engine also uses APP_USER to perform security checks and conditional processing. You can reference APP_USER using different syntax depending on the context, such as SQL, PL/SQL, or static text.

Plug-ins can be used declaratively in all of the following components in APEX: Dynamic Actions, Regions, Items, Process Type, and Authentication and Authorization Schemes. Plug-ins are shared components that enable developers to extend the native functionality of APEX with custom components1. Plug-ins can be created or imported from the Shared Components page or the App Gallery1.

The Create Page wizard supports three form types that you can create: Interactive Grid, Form, and Master Detail4. An interactive grid is a report that allows users to view and edit data in a tabular format. A form is a page that enables users to update a single row in a database table or view. A master detail is a page that reflects a one-to-many relationship between two tables or views4. An interactive report is not a form type, but a report type that allows users to customize the report layout and filter data interactively5.

Task definitions that exist on the application level in the Shared Components section are made up of all of the following: Participants, Task Settings, Parameters, and Actions. Task definitions are used to define approval workflows for data changes in interactive grids or forms5. Participants are the users or groups who can approve or reject tasks. Task Settings are the properties that control how tasks are created, assigned, and completed. Parameters are the variables that store information about tasks or data changes. Actions are the PL/SQL code blocks that execute when tasks are created, updated, or completed5.

A master detail form is a type of form that enables users to query, insert, update, and delete values from two related tables or views. A master detail form reflects a one-to-many relationship between tables in a database. Typically, a master detail form displays a master row and multiple detail rows. In APEX, you can create three types of master detail forms using the Create Page Wizard or the Create Application Wizard:

• Stacked: A stacked master detail form contains a single page with editable interactive grids based on two related tables or views. Users select a row in the master grid to update the detail grid. Developers can create a stacked master detail with either the Create Application Wizard or the Create Page Wizard.
• Side by Side: A side by side master detail form contains a single page with two editable interactive grids based on two related tables or views. Users can see and edit both the master and detail grids at the same time. Developers can create a side by side master detail with either the Create Application Wizard or the Create Page Wizard.
• Two Page Drill Down: A two page drill down master detail form contains two pages based on two related tables or views. The first page is a non-editable interactive grid for the master table. Users click the Edit icon on the first page to edit details on the second page. The second page includes both a standard form for the master and an editable interactive grid for the detail. Developers can create a two page drill down master detail with only the Create Page Wizard.

The feature pages that can be created using the Create Page Wizard are About Page, Access Control, Activity Reporting, Configuration Options, Email Reporting, Feedback, Login Page, and Theme Style Selection. These pages provide application-level functionality that can be added to an existing application. Search Page and Unified Task List are not feature pages that can be created using the Create Page Wizard. Verified References: Managing Feature PagesFeature Page Types

To migrate an APEX app between environments, such as from development to production, you need to consider three components that make up an APEX app:

• Database objects: These are the tables, views, procedures, functions, packages, triggers, sequences, synonyms, and other schema objects that store or manipulate the data used by the app. You need to move these objects from the source schema to the target schema using tools such as SQL Developer, Data Pump Export/Import, or Data Workshop.
• Images: These are the static files, such as images, CSS files, JavaScript files, or PDF files, that are used by the app for display or download purposes. You need to move these files from the source web server to the target web server using tools such as FTP, SCP, or File Explorer.
• Application definition and all associated files: These are the metadata files that define the app components, such as pages, regions, items, buttons, processes, validations, computations, dynamic actions, shared components, and so on. You also need to include any supporting object definitions or data scripts that are used to create or populate database objects for the app. You need to move these files from the source APEX instance to the target APEX instance using tools such as App Builder Export/Import or One-click Remote Application Deployment.

Search Configurations is a feature that allows developers to define how end users can search for data in an application. There are three types of search configurations: Standard, List, and Oracle Text. Oracle Text is a search type that provides linguistic and fuzzy search capabilities by using an Oracle Text index on a table column or view column. Linguistic search enables end users to search for data based on language-specific rules and preferences, such as stemming, stopwords, synonyms, etc. Fuzzy search enables end users to search for data based on approximate matches that account for spelling errors, typos, OCR errors, etc. Verified References: [Managing Search Configurations - Oracle Help Center], [Oracle Text User’s Guide]

From SQL Workshop, you can perform the following actions:

• Run SQL commands and scripts: You can use SQL Commands or SQL Scripts components to run individual SQL statements or PL/SQL blocks interactively or in batch mode. You can also view the results, errors, or explain plans of your commands or scripts.
• Create and view database objects: You can use Object Browser component to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can also use this component to create new objects, modify existing objects, drop objects, or run object reports.

The other options are incorrect because:

• Create an APEX user: You cannot use SQL Workshop to create an APEX user. You can use Workspace Administration component to create and manage users in your workspace.
• Delete database: You cannot use SQL Workshop to delete database. You can only delete database objects such as tables or views from your schema.

Verified References: [About SQL Workshop] [Using SQL Commands] [Using SQL Scripts] [Using Object Browser] [Managing Workspace Users]

To hide a few columns in your interactive report, you should choose Columns from the Actions menu. This option allows you to select which columns to show or hide in your report by using checkboxes. You can also reorder or resize the columns from this option.

The other options are incorrect because:

• Filter allows you to filter the data in your report by applying one or more conditions on the columns.
• Data allows you to add, modify, or delete data in your report by using inline editing or modal dialog editing.
• Format allows you to change the appearance of your report by applying conditional formatting rules or highlighting colors.

Verified References: [Customizing Interactive Reports] [Actions Menu]

When you enable the Save Public Report attribute for an interactive grid, end users can save their report preferences as either private or public reports. Private reports are only visible to the user who created them, while public reports are visible to all users who have access to the interactive grid. You can also specify an authorization scheme to control who can save public reports. Verified References: Managing Interactive Grids - Oracle Help Center, [Interactive Grid Attributes - Oracle Help Center]

The navigation menu is the list of pages that displays when you click on the hamburger menu in the upper-left corner of an APEX application. The navigation menu is a shared component that can be created and edited in the Shared Components page3. Lists, breadcrumbs, and navigation bar entries are other types of navigation components in APEX, but they are not the same as the navigation menu.

A calendar is a type of component that enables users to view and manage data based on dates. A calendar can display data in different views, such as monthly, weekly, daily, or list. Users can also interact with the calendar by creating, editing, or deleting events, or by using drag and drop functionality. Three of the features of a calendar in Oracle APEX are:

• Next - Navigates to the next month. This feature allows users to move forward in time and see the events for the following month.
• Previous - Navigates to the previous month. This feature allows users to move backward in time and see the events for the previous month.
• Month, Week, Day - Displays a monthly, weekly and daily view. These features allow users to switch between different views of the calendar and see the events for a specific month, week, or day.

You can create two types of card layout in APEX: Float and Grid. Float layout displays cards in a single row that wraps to the next row when the available space is filled. Grid layout displays cards in a fixed number of columns that can be responsive to the screen size1. Vertical and Horizontal are not valid card layout types in APEX.

The Query Source types for a Navigation Bar List are SQL Query and Function Returning SQL Query. These types allow you to define the list entries using a SQL statement or a PL/SQL function that returns a SQL statement. The other options, Select List and Procedure, are not valid for a Navigation Bar List. Verified References: Create Page Wizard: Navigation Bar List AttributesCreating Lists

In a Classic Report, an end user can perform the following actions:

• Filter values of a column in the report by using the Search Bar. This bar allows the user to enter a search string and apply it to one or more columns in the report.
• Sort the columns of the report by clicking on the column headers. This action toggles the sort order between ascending and descending for the selected column.

The other options are incorrect because:

• Create Control Breaks in the report is not an action that an end user can perform in a Classic Report. This action is only available in an Interactive Report by using the Control Break option in the Actions menu.
• Rearrange the columns in the report is not an action that an end user can perform in a Classic Report. This action is only available in an Interactive Grid by using the Reorder option in the Actions menu.

Verified References: [About Classic Reports] [Searching Classic Reports] [Sorting Classic Reports]

Oracle APEX is a low-code development platform that enables you to build database-centric web applications using only a web browser. Oracle APEX has the following features:

• Requires no additional client software. A web browser is the app development IDE: You can use any modern web browser to access the Oracle APEX development environment and build your applications. You do not need to install or configure any additional software or tools on your client machine.
• Is declarative. It requires no code generation: You can use declarative tools, visual editors, drag-and-drop components, and pre-built templates to define your application logic, user interface, security, and integration features. You do not need to write or generate any code for your applications.

The other options are incorrect because:

• Performs the data processing in a middle-tier server: Oracle APEX performs the data processing in the database server. It uses SQL and PL/SQL to access and manipulate the data stored in the database. It does not rely on any middle-tier server or framework for data processing.
• Requires developers to be proficient in Java, Python and other programming languages: Oracle APEX does not require developers to be proficient in Java, Python or other programming languages. It uses SQL and PL/SQL as the primarylanguages for data processing. It also supports HTML, CSS, JavaScript, and jQuery for user interface development.

Verified References: [About Oracle APEX] [Oracle APEX Architecture]

A map is a type of component that enables users to view and manage data based on geographic locations. A map consists of a background map and spatial geometry objects that are sourced from data in a table or from a REST data source. Spatial geometry objects are shapes that represent real-world features on a map, such as points, lines, polygons, or heat maps. Three of the supported spatial geometry objects in Oracle APEX are:

• Polygons: A polygon is a closed shape that consists of three or more vertices connected by straight line segments. A polygon can represent an area on a map, such as a country, a state, a city, or a building. A polygon can have different colors, patterns, or borders to indicate different attributes or categories of the data.
• Heat map: A heat map is a type of visualization that uses color gradients to show the density or intensity of data values in a geographic area. A heat map can represent the distribution or variation of a numeric variable on a map, such as population, income, crime rate, or temperature.
• Points: A point is a zero-dimensional shape that represents a single location on a map. A point can have different symbols, sizes, or colors to indicate different attributes or categories of the data. A point can also have a label or a tooltip to display additional information about the data.

 A faceted search is a type of component that enables users to filter information easily and intuitively by selecting the options in each facet. A faceted search consists of a faceted search region and a search results region. The faceted search region displays on the left and upper part of the screen and shows possible values and occurrence counts for each facet. The search results region displays on the right side of the screen and shows the data that matches the selected facet values. The search results region can display as either a classic report or a cards report. Three of the statements that are true about faceted search are:

• After the end user changes a facet, the results, dependent facets, and occurrence counts refresh immediately. This feature provides instant feedback to the user and allows them to refine their search criteria without reloading the page.
• The right side of the page features a Search Results region, which can display as a classic report or a cards report. A classic report displays data in a tabular format with columns and rows. A cards report displays data in a grid of cards with images and text.
• The facets are displayed on the left and upper part of the screen. This layout provides a clear separation between the facets and the results and allows users to see and access all the facets without scrolling.

The Approvals Component is a feature in Oracle APEX that enables you to create and manage tasks for user approval. The Approvals Component deals with all aspects of human approval in Oracle APEX, allowing you to put approval functionality into your applications. The Approvals Component creates one or more tasks for items that require approval based on a pre-configured template, known as the Task Definition. The Task Definition specifies the data source, display attributes, potential owners, business administrators, and available actions for the tasks. You can set up task approvers and administrators at design time or determine them dynamically at runtime based on data related to the task. For example, you can use a SQL query or a PL/SQL function to return the list of potential owners or business administrators for each task based on some criteria, such as department, role, or location.

A stacked master detail is a form type that displays two editable interactive grids based on two related tables or views on the same page. Users select a row in the master grid to update the detail grid6. In this scenario, the departments names with location on the left is the master grid and the employees details on the right is the detail grid. A cards report is not a form type, but a report type that displays data in cards with an image and text7. A side by side master detail is a form type that displays two editable interactive grids based on two related tables or views side by side on the same page. Users select multiple rows in the master grid to update multiple detail grids6. An interactive report is not a form type, but a report type that allows users to customize the report layout and filter data interactively5.

Data Load Definition is a feature that enables developers to create pages with data loading capability. Users can upload files and load data into tables or collections. Some key features of Data Load Definition are:

• The APEX_DATA_LOADING PL/SQL API is available for custom processing. Developers can use this API to programmatically load data by calling an application data loading definition .
• Column mapping occurs at design time, removing the burden on end users. Developers can define SQL expressions, SQL queries, lookups, or transformation rules for each data profile column.
• Easy workflow for end users: upload the file, verify the preview, and load data. Users can follow a simple three-step process to load data from a file into a table or a collection.

Data Load Definition does not support only XML data format. It also supports CSV, JSON, XLSX, and XML formats.

Using Data Workshop, you can perform the following tasks:

• Load vast amount of data into the database: You can use the Data Load option to load data from various file formats such as XLSX, CSV, XML, and JSON into a table or a collection in your database. You can also use the Data Load Wizard to guide you through the steps of loading data.
• Export vast amount of data from the database into a file: You can use the Data Unload option to export data from a table or a collection in your database into a file in CSV or JSON format. You can also use the Data Unload Wizard to guide you through the steps of exporting data.
• Load data using various file formats such as XLSX, CSV, XML, and JSON: You can use the Data Load option to load data from different file formats into your database. You can choose the file format from a list of supported formats or let Oracle APEX detect it automatically.

The other option is incorrect because:

• Delete data from the database: You cannot use Data Workshop to delete data from the database. You can use SQL Commands or SQL Scripts in SQL Workshop to run DELETE statements to delete data from the database.

Verified References: [About Data Workshop] [Loading Data] [Unloading Data]

You can create a report in any of these three methods:

• Create a report as a new page in an application by using the Create Page Wizard. This wizard guides you through the steps of selecting a page type, defining attributes, selecting a source (such as SQL query or table), and adding items or buttons.
• Create a report when you create a new database application by using the Create Application Wizard. This wizard allows you to generate one or more reports based on existing tables or views in your schema. You can also create a report and form on the same table or view.
• Create a report region on a page in an application by using the Page Designer. This tool allows you to drag and drop a region type (such as Classic Report, Interactive Report, or Interactive Grid) onto the page and define its attributes and source.

The other option is incorrect because:

• You cannot create a report from Object Browser. Object Browser is a tool that allows you to view and manage the database objects in your schema, such as tables, views, indexes, etc. You can only run SQL queries or scripts from this tool, not create reports.

Verified References: [Creating Database Applications] [Creating Pages] [Creating Regions] [Using Object Browser]

App Builder is the main interface of Oracle APEX that allows developers to create and manage web applications. App Builder provides various features and tools to design, develop, test, debug, deploy, and maintain applications. Some of the tasks that you can perform using App Builder are importing previously exported apps, creating new apps from scratch or from predefined templates or blueprints, editing app properties and attributes, adding pages and regions, creating shared components, running and debugging apps, exporting apps to files or workspaces, etc. You cannot create join queries using drag and drop or generate DDL statements from the Oracle data dictionary using App Builder. Verified References: [Using App Builder - Oracle Help Center], [App Builder Concepts - Oracle Help Center]

A form is a type of component that is part of an HTML form and can accept user input or display output. There are many types of forms that can be created in APEX, such as forms on tables, forms on procedures, forms on web sources, and so on. Each type of form has different properties and attributes that affect its appearance and functionality. Three of the ways in which you can create a form in APEX are:

• Using the Create Page wizard: This method allows you to create a new page with a form component using a guided wizard. You can choose from different types of forms, such as report with form, editable interactive grid, single page master detail, two page master detail, form on table, form on procedure, and so on. You can also specify various options for your form, such as data source, display style, validations, processes, and branches.
• Create a Form region in Page Designer: This method allows you to create a complex form region that includes multiple form items and processes on an existing page. You can use the Create Form Region wizard in Page Designer to create a form region based on a table, view, procedure, web source module, or SQL query. You can also customize your form region by adding or modifying items, buttons, validations, computations, processes, and dynamic actions.
• Using the Create Application Wizard: This method allows you to create a new application that contains one or more forms using a guided wizard. You can choose from different types of applications, such as database application, web source application, blueprint application, or from scratch application. You can also specify various options for your application and forms, such as name, icon, theme style, features, data source, navigation menu entry, and so on.

A page process type defines what action the page process performs when it is executed. There are many page process types available in Oracle APEX, such as Execute PL/SQL Code, Data Loading, Branch, etc. One of the valid page process types is Set Value. The Set Value page process type sets session state for an item or items on a page using a computation or PL/SQL expression. You can use this page process type to assign values to items based on logic or conditions. The other options are not valid page process types. Execute JavaScript Code is a dynamic action type, not a page process type. Send E-Mail is an application process type, not a page process type. Verified References: [Understanding Page Processes - Oracle Help Center], [Set Value Process Type - Oracle Help Center]

Low Code Apps are applications that are developed using a low-code development platform such as Oracle APEX. Low Code Apps have the following characteristics:

• Scalable: Low Code Apps can handle large volumes of data and users without compromising performance or reliability. They can also leverage the scalability features of the underlying database or cloud platform.
• Provide Rich Functionality with Less Code: Low Code Apps can provide complex business logic, user interface, security, and integration features with minimal or no coding. They use declarative tools, visual editors, drag-and-drop components, and pre-built templates to speed up the development process.

The other options are incorrect because:

• Not Mobile Friendly: Low Code Apps are mobile friendly by default. They use responsive design techniques to adapt to different screen sizes and orientations. They also support touch gestures, device features, and offline capabilities.
• Expensive: Low Code Apps are not expensive to develop or maintain. They reduce the cost of development by requiring less time, resources, and skills. They also reduce the cost of maintenance by simplifying the deployment, testing, and debugging processes.

Verified References: [What is Low Code?] [Why Choose Oracle APEX?]

The Create Application Wizard is a tool that allows developers to create a new application by following a series of steps. Some of the actions that you can perform using the Create Application Wizard are:

• Reorder application pages. You can use the Reorder Pages option in the Pages step to change the order of the pages in your application by dragging and dropping them.
• Add or delete application pages. You can use the Add Page or Delete Page options in the Pages step to add new pages or delete existing pages from your application. You can also use the Create Page Wizard to create additional pages after creating the application. You cannot upload JavaScript or CSS files required for an application or change the application authorization using the Create Application Wizard. You can use other features in App Builder to perform these actions, such as Shared Components > User Interface > Files and Shared Components > Security > Authentication Schemes. Verified References: [Creating an Application Using the Create Application Wizard - Oracle Help Center], [Create Application Wizard - Oracle APEX]

Cards are a page type that display information in a grid layout of tiles. Each card can contain an image, a title, a subtitle, and an optional link. Cards are suitable for presenting summary or overview information in an attractive and compact way1 Verified References: 1: Understanding Page Types, Features, and Settings - Oracle Help Center

When pivoting an interactive report, you can use different functions to aggregate or summarize the data in the pivot table. Some of the available functions are Minimum, Maximum, Average, Sum, Count, Median, and Rank. Minimum returns the smallest value in a set of values. Rank returns the rank of each value in a group of values. Verified References: 56

Template options provide developers with a declarative approach to applying different styles to components on an Oracle APEX page. Developers can use template options to declaratively apply CSS modifiers to the templates they have chosen for pages, regions, reports, lists, breadcrumbs, items and buttons. Developers can use template options in all of the following ways:

• Applying different colors or accents. Developers can use template options to change the color scheme or accent color of components, such as buttons, lists, or regions.
• Rendering buttons in different styles, with and without icons. Developers can use template options to change the shape, size, style, and icon of buttons on a page.
• Applying different spacing and padding. Developers can use template options to adjust the spacing and padding of components, such as regions, items, or reports.
• Displaying form fields with different alignments. Developers can use template options to change the alignment of form fields and labels, such as left-aligned, right-aligned, or top-aligned.

To create a REST Enabled SQL Reference, you need to meet the following requirements:

• Install Oracle REST Data Services (ORDS) 19.x or later. ORDS is a Java application that enables developers to create, publish, and manage RESTful web services for Oracle databases1.
• Activate REST Enabled SQL for the target schema on the remote database. REST Enabled SQL is a feature of ORDS that allows you to execute any SQL or PL/SQL through a REST endpoint. You need to enable this feature for the schema that contains the data you want to access2.
• Configure and enable the REST Enabled SQL service feature. This is a workspace-level setting that allows you to use REST Enabled SQL references in your APEX applications. You need to specify a path prefix and a secret for the REST Enabled SQL service3.

You do not need to set up any remote database, as long as it meets the ORDS and REST Enabled SQL requirements. You can use any Oracle database or MySQL database as a remote data source2.

A chart is a type of component that enables users to visualize data in different ways and perform data analysis. A chart can display data in various formats, such as bars, lines, areas, ranges, combinations, scatters, bubbles, polars, radars, pies, donuts, funnels, and more. Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations. Oracle JET is a modular open source toolkit based on modern JavaScript, CSS3, and HTML5 design and development principles. Three of the correct statements about charts in Oracle APEX are:

• You can visualize data as bar, line, area, range, combination, scatter, bubble, polar, radar, pie, donut, funnel and more. This statement is true because Oracle APEX provides a rich set of chart types that can be used to display data in different ways and support different analysis scenarios. You can choose from over 20 chart types when creating a chart in Oracle APEX.
• Oracle APEX supports charts based on the Oracle JavaScript Extension Toolkit (Oracle JET) Data Visualizations. This statement is true because Oracle APEX uses Oracle JET as the underlying technology for rendering charts in the browser. Oracle JET provides high-performance and interactive data visualizations that are compatible with various devices and browsers.
• Each Oracle JET visualization supports animation, accessibility, responsive layout, internationalization, test automation, and a range of inter activity features. This statement is true because Oracle JET offers many features and capabilities that enhance the user experience and functionality of the charts. For example:

The Page Designer Toolbar allows you to perform various actions related to the development of an APEX page. Two of the actions that you can perform are:

• Navigate to Shared Components: This option lets you access the shared components of your application, such as lists, breadcrumbs, navigation menus, and so on. You can edit, create, or delete shared components from this option. To access this option, click the icon that resembles a puzzle piece on the Page Designer Toolbar.
• Create a new page: This option lets you create a new page for your application using the Create Page Wizard. You can choose from different page types, such as blank page, form, report, chart, calendar, and so on. To access this option, click the icon that resembles a plus sign (+) on the Page Designer Toolbar.

A workspace is a logical work area that enables multiple users to work within the same Oracle APEX installation while keeping their objects, data, and applications private. Creating and managing an APEX workspace involves the following statements:

• During workspace creation, you can associate the workspace with an existing database schema or create a new schema for the workspace. A schema is a collection of database objects such as tables, views, indexes, etc. that belong to a user.
• A workspace enables multiple users to work within the same Oracle APEX installation. Each user can have a different role and privilege in the workspace, such as workspace administrator, developer, or end user.
• A workspace can be associated with one or more schemas. You can add or remove schemas from a workspace after it is created.
• You can create as many workspaces as you need in an APEX Service (APEX Application Development) instance. There is no limit on the number of workspaces per instance.

Verified References: Managing WorkspacesAbout Workspaces