Oracle
1Z0-074 · Question #13
The EMP_CDB1 and EMP_CDB2 CDBs are in ARCHIVELOG mode. Oracle Managed Files is enabled in both CDBs. EMP_CDB1 has a PDB, EMP_PDB1. In EMP_CDB2, you log in as the SYS user. You plan to execute this…
The correct answer is C. EMP_PDB2 should be opened in read-write mode to complete the relocation process. E. EMP_LINK should exist as a public link in EMP_CDB1 and EMP_CDB2. Explanation/Reference:
Using Advanced SQL Features
Question
The EMP_CDB1 and EMP_CDB2 CDBs are in ARCHIVELOG mode. Oracle Managed Files is enabled in both CDBs. EMP_CDB1 has a PDB, EMP_PDB1. In EMP_CDB2, you log in as the SYS user. You plan to execute this statement:
CREATE PLUGGABLE DATABASE emp_pdb2 FROM emp_pdb1@emp_link RELOCATE; Which two statements are true? (Choose two.)
Options
- AThe AVAILABILITY MAX clause should be added to the command to ensure transaction consistency
- BSYSOPER privilege should be granted to the user defined in EMP_LINK and used to connect to the
- CEMP_PDB2 should be opened in read-write mode to complete the relocation process.
- DEMP_PDB1 should be dropped manually from EMP_CDB1 after executing the relocating command.
- EEMP_LINK should exist as a public link in EMP_CDB1 and EMP_CDB2.
- FOnly EMP_PDB1 should be in local undo mode.
How the community answered
(33 responses)- A3% (1)
- B3% (1)
- C85% (28)
- F9% (3)
Explanation
Explanation/Reference:
Topics
#PDB relocation#RELOCATE clause#database link#pluggable database
Community Discussion
No community discussion yet for this question.