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 questionsThe 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).
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.
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..."
Keep practicing
Take the free 1Z0-083 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-083 practice questions
- Question 1Which two are true about flashback features in Oracle Database 19c and later releases? (C…
- Question 2Which two statements are true about Resource Manager plans for individual pluggable datab…
- Question 3Choose three. Which are the three steps in the SQL tuning process for Oracle Database env…
- Question 4Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgra…
- Question 5Choose three. Which three capabilities require the use of the RMAN recovery catalog?
- Question 6Choose two. In which two situations can you use Database Upgrade Assistant?
