Oracle
1Z0-074 · Question #11
A CDB, CDB1, has a LOCATIONS application container. NORTH_PDB and SOUTH_PDB are two application PDBs in LOCATIONS. In CDB2, you create a remote clone, LOC_R, of the LOCATIONS application root. You…
The correct answer is E. by creating a proxy PDB in CDB2 root, referencing LOC_R. Explanation/Reference:
Using Advanced SQL Features
Question
A CDB, CDB1, has a LOCATIONS application container. NORTH_PDB and SOUTH_PDB are two application PDBs in LOCATIONS. In CDB2, you create a remote clone, LOC_R, of the LOCATIONS application root. You want to query data across the LOCATIONS application PDBs created in CDB1 and CDB2. How can you do this?
Options
- Aby creating a proxy PDB in LOCATIONS_ROOT in CDB1, referencing LOC_R
- Bby creating a proxy PDB in CDB1 root, referencing LOC_R
- Cby using private database links created in CDB1 and CDB2
- Dby using public database links created in CDB1 and CDB2
- Eby creating a proxy PDB in CDB2 root, referencing LOC_R
How the community answered
(59 responses)- A3% (2)
- B2% (1)
- C14% (8)
- D7% (4)
- E75% (44)
Explanation
Explanation/Reference:
Topics
#proxy PDB#application container#cross-CDB queries#database links
Community Discussion
No community discussion yet for this question.