Oracle Database Administration II — Question 89

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.)

Answer options

• 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.

Correct answer: B, E, F

Explanation

Option B is correct because a database link in the local CDB root is necessary to connect to the remote CDB for executing queries. Option E is also correct, as the HR_ROOT replica in the remote CDB is needed to support the query execution. Finally, F is right since a proxy PDB in the local CDB's application root is required for facilitating the connection to the remote database. Options A, C, and D are incorrect as they do not meet the requirements needed for the query execution across the specified databases.