Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-771

Free Oracle 1Z0-771 Exam Questions (page: 2)

Page 2 of 8
PDF with 53 Questions

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?

  1. Popup LOV
  2. Range
  3. Date Picker
  4. Checkbox Group

Answer(s): B,D

Explanation:

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

Checkbox Group: Used for multi-select options, enabling users to select multiple values from a list (e.g., departments).

Other types like Popup LOV and Date Picker are valid item types in APEX but are not natively supported as facet types in the Faceted Search region. Popup LOV is typically used for single-value selection in forms, and Date Picker is a standalone item type, not a facet-specific UI.


Reference:

Oracle APEX 23.2 Documentation - "Managing Faceted Search" under Application Builder User's Guide.



Which two SQL format options does the APEX Assistant provide when using the "Create Data Model using AI" feature?

  1. Quick SQL
  2. MySQL
  3. Oracle SQL
  4. Oracle PL/SQL

Answer(s): A,C

Explanation:

The "Create Data Model using AI" feature in APEX Assistant leverages AI to generate data models based on natural language input. The supported SQL format options are:

Quick SQL: A shorthand syntax for defining database objects, which APEX can convert into full DDL.

Oracle SQL: Standard SQL syntax compatible with Oracle Database for creating tables and other objects.

MySQL is not supported as it's specific to a different database system, and Oracle PL/SQL is a procedural language, not a format for defining data models in this context.


Reference:

Oracle APEX 23.2 Documentation - "Using APEX Assistant" under AI Features.



At what level does a developer enable push notifications so that end users can receive them on their devices from an APEX application?

  1. Region
  2. Application
  3. Page
  4. Instance

Answer(s): B

Explanation:

Push notifications in Oracle APEX are enabled at the application level. This allows the application to register with the Progressive Web App (PWA) framework and manage subscriptions for all end users. Once enabled in the Application Definition under "Progressive Web App" settings, APEX handles the subscription process, and developers can use APIs like APEX_PWA.SEND to send notifications. Enabling at the region, page, or instance level is not supported for this feature.


Reference:

Oracle APEX 23.2 Documentation - "Enabling Push Notifications" under Application Definition Attributes.



In which two formats can the GetCurrentPosition Dynamic Action in Oracle APEX return coordinates?

  1. Function Body returning SQL Query
  2. Latitude and Longitude
  3. GeoJSON
  4. State and Pincode

Answer(s): B,C

Explanation:

The GetCurrentPosition Dynamic Action retrieves geolocation data from the user's device. It supports:

Latitude and Longitude: Returns coordinates as separate numeric values (e.g., lat: 37.7749, lon: - 122.4194).

GeoJSON: Returns coordinates in a structured JSON format compliant with the GeoJSON standard (e.g., { "type": "Point", "coordinates": [-122.4194, 37.7749] }).

Function Body returning SQL Query is a dynamic action type, not a coordinate format, and State and Pincode is unrelated to geolocation coordinates.


Reference:

Oracle APEX 23.2 Documentation - "Using GetCurrentPosition Dynamic Action" under Dynamic Actions.



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

  1. Using Quick SQL
  2. Using Data Workshop
  3. Using SQL Scripts
  4. Using Object Browser

Answer(s): C,D

Explanation:

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.

Object Browser: Provides a GUI to create and edit database objects, including stored procedures, by defining their specifications and bodies.

Quick SQL is for generating table DDL, not stored procedures, and Data Workshop is for loading/unloading data, not creating procedures.


Reference:

Oracle APEX 23.2 Documentation - "SQL Workshop Guide" under SQL Scripts and Object Browser sections.



Which two are prerequisites to use the REST-enabled SQL feature in Oracle APEX?

  1. Create a database link to the remote Oracle Database in the local APEX schema.
  2. Install ORDS 19.x or later on the remote Oracle Database.
  3. REST-enable the schema in the remote Oracle Database by using ORDS.ENABLE_SCHEMA.
  4. Install Oracle APEX in the remote Oracle Database.

Answer(s): B,C

Explanation:

To use REST-enabled SQL in APEX:

Install ORDS 19.x or later: Oracle REST Data Services (ORDS) must be installed and configured on the remote database.

REST-enable the schema: The schema on the remote database must be REST-enabled using ORDS.ENABLE_SCHEMA to allow SQL execution via REST.

A database link is not required, and installing APEX on the remote database is unnecessary since REST-enabled SQL connects APEX to a remote schema via ORDS.


Reference:

Oracle APEX 23.2 Documentation - "Using REST-Enabled SQL" under Data Sources.



Which statement is true about the Data Workshop utility?

  1. You cannot load data from an XLSX file with multiple worksheets.
  2. The wizards load and unload all types of schema objects.
  3. The wizards load and unload table data only.
  4. You can load or unload multiple tables at a time.

Answer(s): C

Explanation:

The Data Workshop utility in APEX is designed to load and unload table 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.


Reference:

Oracle APEX 23.2 Documentation - "Using Data Workshop" under SQL Workshop.



Which two declarative options in Oracle APEX allow you to download BLOB/CLOB content?

  1. Download Dynamic Action
  2. APEX_UTIL.DOWNLOAD PL/SQL API
  3. Download Page Process
  4. Share Dynamic Action

Answer(s): A,C

Explanation:

Declarative options for downloading BLOB/CLOB content include:

Download Dynamic Action: A built-in action type to trigger downloads of BLOB/CLOB data.

Download Page Process: A process type that declaratively handles BLOB/CLOB downloads from a table.

APEX_UTIL.DOWNLOAD is a PL/SQL API, not a declarative option, and Share Dynamic Action is for sharing URLs, not downloading files.


Reference:

Oracle APEX 23.2 Documentation - "Downloading Files" under Dynamic Actions and Page Processes.



Viewing page 2 of 8



Post your Comments and Discuss Oracle 1Z0-771 exam prep with other Community members:

1Z0-771 Exam Discussions & Posts