nerdexam
Oracle

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…

Manage Multitenant Container Databases

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)
  • A
    17% (8)
  • B
    70% (32)
  • C
    9% (4)
  • D
    4% (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

#application container#proxy PDB#database link#cross-CDB query

Community Discussion

No community discussion yet for this question.

Full 1Z0-083 Practice