Free Oracle 1z0-771 Practice Exam with Questions & Answers | Set: 2

In SQL Workshop, custom stored procedures can be created using:

SQL Scripts: Allows developers to write and execute PL/SQL code directly to define stored procedures.

In Oracle APEX, a faceted search page allows users to filter data using facets, which are displayed as UI components in the Faceted Search region. According to the Oracle APEX documentation, the supported facet item types include:

Range: Used for numeric or date ranges, allowing users to filter data within a specified range (e.g., salary or hire date).

The Data Workshop utility in APEX is designed to load and unloadtable data only, not other schema objects like procedures or views. Option A is false because XLSX files with multiple worksheets are supported (each worksheet can be mapped to a table). Option B is incorrect as it’s limited to table data. Option D is partially true but not the most precise answer, as "multiple tables at a time" depends on the process, whereas C is universally accurate.

In Oracle APEX, when configuring search functionality (e.g., in reports or faceted search), "Oracle Text" refers to a specific search type leveraging the Oracle Text engine. This is a powerful full-text search capability built into Oracle Database, supporting keyword-based searches, fuzzy matching, and indexing.

Standard: A basic SQL-based search (e.g., LIKE), not tied to Oracle Text.

List: Not a search type; it might refer to a UI component or LOV, not a search mechanism.

Plugins extend APEX’s functionality beyond built-in components:

C. Process: A Process plugin executes custom server-side logic (e.g., PL/SQL) during page processing or AJAX calls. Example: A plugin to sync data with an external API after form submission. It’s defined with execution points and parameters.

D. Region: A Region plugin creates custom UI areas (e.g., a dynamic chart or carousel). Example: A plugin rendering a custom dashboard. It supports attributes, templates, and refresh events.

A. Validation: While validations are customizable, they’re not a plugin type; they’re declarative or PL/SQL-based within APEX.