Faceted search pages in APEX provide dynamic filtering. The true statements are:

Faceted Search supports the ability to filter columns storing multiple values: Facets can handle multi-

value columns (e.g., comma-separated lists or JSON arrays) using appropriate SQL (e.g., INSTR or

JSON_TABLE), enabling complex filtering scenarios like tags or categories.

Facets map to specific database columns: Each facet is tied to a column in the underlying query (e.g.,

DEPTNO or JOB), ensuring data-driven filtering.

Multiple charts are not visible in the same region: False; multiple facets can display charts within the

same region, depending on settings.

A facet’s chart can be seen only in a nonmodal dialog: False; charts can appear inline or in dialogs,

configurable via facet attributes.

This functionality makes faceted search ideal for exploratory data analysis.

Reference: Oracle APEX 23.2 Documentation - "Managing Faceted Search" under Regions.