1Z0-083 practice question 35 of 35

our SALES_ROOT application container has two application PDBs. The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs. Examine this query and its output: Which two are true? (Choose two.)

Full set: 286 questions
Answer options
A: The CONTAINERS clause cannot be used in queries on the REVENUE table.
B: The REVENUE table must be a list-partitioned table.
C: The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table. Correct answer
D: The MAPTABLE table is a metadata-linked table.
E: A container map exists for the REVENUE table, but is not enabled.
F: The REVENUE table partitions are not pruned across the PDBs automatically. Correct answer
Correct Answer:
C. The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.; F. The REVENUE table partitions are not pruned across the PDBs automatically.
Explanation

The question, despite missing the query and output, describes a scenario involving an application common table queried across multiple PDBs. The options point to the use of container maps. A container map's purpose is to define a logical partition key, enabling queries to be routed only to the PDBs containing the relevant data (Option C). If a container map is not implemented or enabled, the database cannot automatically prune PDBs from the query. Consequently, the query must be executed against the table in all PDBs, meaning partitions are not pruned across PDBs automatically (Option F).

Why Incorrect

A. The CONTAINERS clause is specifically designed for querying application common objects across PDBs. It would not be prohibited unless the object setup was incorrect.
B. There is no requirement for a table involved in a container map to be list-partitioned; it can be any type of table.
D. A container map is a distinct database object that directs queries; it is not a metadata-linked table, which shares structure but not data.
E. This is a possible state, but F describes the direct consequence of the map not being active. F is a more fundamental truth about the default behavior.

References

Oracle Database Administrator's Guide, 19c, Chapter 39, "Managing Application Containers". Section: "Querying Data Across PDBs in an Application Container". This section explains that a container map enables partition-pruning-like behavior for PDBs.

Oracle Database Administrator's Guide, 19c, Chapter 39, "Managing Application Containers". Section: "About Container Maps". This section states, "A container map routes queries to the PDBs that contain the data for the query... Without a container map, a query of a data-linked common object must be executed in all of the PDBs..."

Scroll to Top