1Z0-083 · Question #115
The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3. Which three are true? (Choose three.)
The correct answer is B. A database link must exist in the local CDB root referring to the remote CDB. E. The HR_ROOT replica must exist in the remote CDB. F. A proxy PDB must exist in the application root in the local CDB. Database link must be created in master application root (local CDB) referring to replica application root (remote CDB). Option B Proxy PDB must be created in master application root (local CDB) using this database link. Replica application root must exist in remote CDB…
Question
The HR_ROOT application container must support the execution of a query on a table shared by application local PDBs PDB1 and PDB2, and remote PDB PDB3. Which three are true? (Choose three.)
Options
- AA proxy PDB must exist in the application root in the remote CDB.
- BA database link must exist in the local CDB root referring to the remote CDB.
- CPDB3's application root replica must exist in the local CDB.
- DA database link must exist in the remote CDB referring to the local CDB.
- EThe HR_ROOT replica must exist in the remote CDB.
- FA proxy PDB must exist in the application root in the local CDB.
How the community answered
(46 responses)- A17% (8)
- B70% (32)
- C9% (4)
- D4% (2)
Explanation
Database link must be created in master application root (local CDB) referring to replica application root (remote CDB). Option B Proxy PDB must be created in master application root (local CDB) using this database link. Replica application root must exist in remote CDB (created or upgraded using SYNC in local Proxy PDB). Option E With this, we can make a SELECT that will show data from local and remote PDB applications (Query in local master application root using CONTAINERS clause). https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/administering-application- containers-sql-plus.html#GUID-B96087B5-678C-4781-9464-42FC468B1FCC
Topics
Community Discussion
No community discussion yet for this question.