Oracle
1Z0-074 · Question #13
1Z0-074 Question #13: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-074 to reveal the answer and full explanation for question #13. The question stem and answer options stay visible for context.
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.
Unlock 1Z0-074 to see the answer
You've previewed enough free 1Z0-074 questions. Unlock 1Z0-074 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.