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
This section is not available anymore. Please use the main Exam Page.1z0-083 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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, 5 months agoRogazan
3 years, 5 months agoObserverPL
Highly Voted 3 years, 5 months agoantonica
Most Recent 6 months, 4 weeks agoflaviogcmelo
1 year, 1 month agokaka321
1 year, 3 months ago_gio_
1 year, 3 months agoScottL
1 year, 5 months agovkra
1 year, 8 months agoNonicknameavailable
1 year, 8 months agojackymak
1 year, 9 months agoABAJ
3 years, 4 months agoRinD
3 years, 5 months ago