Explanation
The REST-enabled SQL feature in Oracle APEX allows developers to execute SQL statements and PL/SQL blocks on a remote Oracle Database by using REST services. The prerequisites to use this feature are:
On the remote Oracle Database, install ORDS 19.x or later.
REST enable the schema in the remote Oracle Database using ORDS.ENABLE_SCHEMA.
Create a REST Data Source with REST Enabled SQL as the REST Data Source Type in Oracle APEX.
Create an Authorization Scheme based on the REST Data Source in Oracle APEX. You do not need to create a database link to the remote Oracle Database or install Oracle APEX in the remote Oracle Database to use this feature. Verified References: [Using REST Enabled SQL - Oracle Help Center],
[REST Enabled SQL Service - Oracle Help Center]

Explanation
A faceted search page is a type of page that allows end users to filter data by applying one or more facets. A facet is a set of filters based on a column or expression. By default, when end users select a facet value, they need to click on an Apply button for that facet to apply the filter to the report. To make report filtering automatically executed when any facet value changes, you need to navigate to the faceted search region Attributes, and disable the Batch Facet Changes attribute. The Batch Facet Changes attribute determines whether end users need to click on an Apply button for each facet or not. When this attribute is disabled, the report is automatically refreshed when any facet value changes. The other options are not relevant to the report filtering behavior. Verified References: [Faceted Search Attributes - Oracle Help Center], [Batch Facet Changes - Oracle APEX]

Explanation
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]

Explanation
Oracle APEX is a low-code application development platform that enables developers to build scalable, secure, and data-driven web and mobile apps. Some of the statements that are true about Oracle APEX are:
APEX eliminates middle-tier application logic. APEX runs entirely within Oracle Database and does not require any additional middleware or application server to function. This simplifies the architecture and reduces the complexity, cost, and security risks of deploying applications.
You can build interactive reporting apps based on data from disparate systems. APEX supports various data sources, such as local database, REST Enabled SQL Service, REST Data Source, Web Source Module, etc. You can use these data sources to create interactive reports that allow end users to filter, sort, search, aggregate, and visualize data from different sources.
The other statements are false because:
Application definition is stored in the database. APEX stores the metadata of the application components, such as pages, regions, items, buttons, etc., in the database tables.
Processing and data manipulation is executed in the database. APEX leverages the power and performance of Oracle Database to process and manipulate data using SQL and PL/SQL.
Running an APEX app does not need client software. APEX apps are web-based and can be accessed from any browser on any device without installing any client software. Verified References: [Oracle Application Express (APEX) - Oracle Help Center], [Platform - Oracle APEX]

Explanation
A Faceted Search and a Smart Filter are two types of pages that behave similarly in functionality. They both allow users to filter data based on multiple criteria and see the results in real time. They differ in the following aspects:
A Faceted Search uses facets to filter data. A facet is a set of filters based on a column or expression. A facet can be displayed as a list, a range slider, a star rating, or a chart.
A Smart Filter uses conditions to filter data. A condition is a logical expression that evaluates to true or false. A condition can be based on a column, an item, or a function.
The other options are incorrect because:
A Map is a type of region that displays spatial data on an interactive map. It allows users to zoom, pan, and select features on the map.
A Cards is a type of region that displays data in a grid of cards. Each card represents one row of data and can contain text, images, icons, or buttons.
Verified References: [About Faceted Search] [About Smart Filter] [About Maps] [About Cards]