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 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.)
To support the execution of a query on a table shared by application local PDBs (PDB1 and PDB2) and a remote PDB (PDB3), three requirements must be met. First, a database link must exist in the local CDB root referring to the remote CDB. This will facilitate communication between the local and remote CDBs. Second, a proxy PDB must exist in the application root in the local CDB. The proxy PDB acts as a mediator to synchronize and manage the connections and data with the remote database. Finally, the HR_ROOT replica must exist in the remote CDB, ensuring the necessary data structures and metadata are accessible in the remote environment. Together, these facilitate the seamless execution of queries that span local and remote PDBs.
B, E, F
OK BEF: 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. Option F 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).
Weird, but according to Oracle documentation (link provided by RinD) the correct answers are B, E, F.
BEF is the right answer. https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/administering-application-containers- -sql-plus.html#GUID-B96087B5-678C-4781-9464-42FC468B1FCC
see: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-application-containers-with-sql-plus.html#GUID-84C7C5F4-C647-4DCB-9EF3-63B1129F5EE0
ACD https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/administering-application-containers-with-sql-plus.html#GUID-84C7C5F4-C647-4DCB-9EF3-63B1129F5EE0
BEF, i agree
Based on the documentation, I believe the correct alternatives should be: B, E, F https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-application-containers-with-sql-plus.html#GUID-84C7C5F4-C647-4DCB-9EF3-63B1129F5EE0
DEF is correct. this a scenario where local and remote pdb will be accessing a common table. its a must that datalink from remote cdb to local cdb will exist. since a remote pdb is involved a app_root replica must exist in the remote cdb and a proxy pdb in the local cdb that helps update the app_root replica in the remote cdb. i am 100% sure of this from oracle documentation. take your time to digest this document. https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/administering-application-containers-with-sql-plus.html#GUID-1AFD0268-6A2B-4F84-BB4D-4D36976DE53B
here the reference: https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-application-containers-with-sql-plus.html#GUID-7D442C17-28E6-4337-8EF5-6930FBC0BCC8
BEF - see ObserverPL and vkra
A,D.E https://docs.oracle.com/en/database/oracle/oracle-database/19/multi/administering-application-containers-with-sql-plus.html#GUID-84C7C5F4-C647-4DCB-9EF3-63B1129F5EE0
For E, https://docs.oracle.com/en/database/oracle/oracle-database/18/multi/administering-application-containers-with-sql-plus.html#:~:text=The%20query%20can%20show