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.)
A.
A proxy PDB must exist in the application root in the remote CDB.
B.
A database link must exist in the local CDB root referring to the remote CDB.
C.
PDB3's application root replica must exist in the local CDB.
D.
A database link must exist in the remote CDB referring to the local 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.
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).
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
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
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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
mporislav
Highly Voted 3 years, 2 months agoRogazan
3 years, 1 month agoObserverPL
Highly Voted 3 years, 1 month agoantonica
Most Recent 3 months, 3 weeks agoflaviogcmelo
10 months agokaka321
11 months, 4 weeks ago_gio_
1 year agoScottL
1 year, 2 months agovkra
1 year, 4 months agoNonicknameavailable
1 year, 5 months agojackymak
1 year, 6 months agoABAJ
3 years, 1 month agoRinD
3 years, 2 months ago