1Z0-083 · Question #5
Your 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?…
The correct answer is C. -> CORRECT - https://docs.oracle.com/en/database/oracle/oracle- F. -> CORRECT - because CONTAINERS_DEFAULT is not enabled for the revenue table. Tested in lab with exact same setting like in the output shown. database/19/multi/administering-application-containers-with-sql-plus.html#GUID-AAF93A02- 7C70-4024-8758-E351C213543E
Question
Your 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.)
Exhibit
Options
- A-> incorrect - The CONTAINERS clause can be used.
- B-> incorrect - It can be also a range based.
- C-> CORRECT - https://docs.oracle.com/en/database/oracle/oracle-
- D-> incorrect - Regular table
- E-> incorrect - shown in the output CONTAINER_MAP = YES
- F-> CORRECT - because CONTAINERS_DEFAULT is not enabled for the revenue table.
How the community answered
(27 responses)- A4% (1)
- C85% (23)
- D4% (1)
- E7% (2)
Explanation
Tested in lab with exact same setting like in the output shown. database/19/multi/administering-application-containers-with-sql-plus.html#GUID-AAF93A02- 7C70-4024-8758-E351C213543E
Topics
Community Discussion
No community discussion yet for this question.